We are seeking a SDET (Software Developer Engineer in Test) / Sr SDET. Our ideal candidate will be responsible for designing and executing tests manually (15%) and automatically (85%) to identify and resolve all data related issues to meet quality standards. Our tight-knit team combines a Scrum process with a strong testing culture.
- The QE / Database / Datawarehouse /BI /ETL Test Engineer will be responsible for participating in all test activities.
- In this role you will be responsible to develop test automation strategies and take lead role in Database Testing, BI/DW/ETL Testing.
- Exceptionally Strong SQL skills is must have for this position.
Responsibilities and Duties
- Build and perform End to End QA effort on Data Warehouse/ETL/BI Platforms
- Review requirements, specifications and technical design documents to provide timely and meaningful feedback
- Understand data flow and test strategy for ETL , Data warehouse and Business Intelligence testing
- ETL testing of mapping, transformations and data pipelines.
- Data warehouse testing involving the testing of stored procedures, SSIS packages, slowly changing dimension tables, Change Data capture etc.
- Business Intelligence testing involving the validation of DataMart, ODS, Data models and SSRS reports.
- Create detailed, comprehensive and well-structured test plans and test cases
- Identify, document and track software defects
- Work closely with development teams to perform root cause analysis of issues
- Manage multiple tasks and adjust to shifting priorities, as necessary
- Write advanced SQL queries for ETL/data warehousing/Business Intelligence testing
- Identify test cases which has to be automated. Prepare test automation strategy.
- Design and develop test automation for backend.
- Work with the team to continually improve test processes and practices based on inspection/adaption of previous iterations and to ensure adherence to process, tools and metrics standards within the project team
- Show initiatives and accountability with strong time management skills with project teams.
- Exhibit strong collaboration/interpersonal skills
- Be a self-starter and possess the ability to research issues and improve processes
Qualifications and Skills
- Experience in ETL testing techniques
- Good understanding of Data Warehousing and business intelligence concepts and testing techniques
- Experience in Working with Star Schema, ODS, multi-dimensional models, slowly changing dimensions
- Experience in working with ETL framework, Change Data capture, DataMart, Data models etc.
- Working knowledge of test automation for backend using Java and associated frameworks
- Experience in continuous testing practices in a CI/CD development pipeline, and deploying test automation
- Solid experience in strategizing and planning all testing activities including automation.
- Ability to review and analyze business requirements in order to produce test strategy and test cases.
- Expertise working in Cloud data environment
- Familiarity with one or more SQL-on-Hadoop technology (Hive, Impala, Spark SQL, Presto)
- Experience in Agile projects (Scrum, Kanban etc.).
- Working Knowledge in Test Management software (JIRA,qTest/ALM).
- Solid experience with Defect Management Process.
- Quick learner and self-starter who requires minimal supervision to excel in a dynamic environment.
- Excellent analytical and problem solving skills.
- Strong verbal and written communications skills.
- Experience in Banking or Financial services domain is preferred.
- Experience in working with financial platforms
- Experience in Cluster, Containers/VMs, On Premise, On Cloud is preferred
- Strong knowledge on Data Lake, Azure, ELT & ETL, Data Warehouse, BI, Data Factory Tools
- Strong in SQL preparation in Oracle/SQL Server/NoSQL/RDMS/Big Data
Must have
- Bachelor's degree in Computer Science or related field.
- 5 – 10 years of experience with Software Quality Assurance- QA project life cycle, test plan, test strategies, test scenarios, test cases, traceability matrix.
- 3 - 5+ years of experience in Database/Data Warehouse/ETL Testing.
- 3 - 5+ years of Strong experience in advanced SQL scripting.
- Experience in MS SQL server, SSIS and SSRS.
- 3+ years’ experience of Data Lake/Hadoop platform implementation, including 3+ years of hands-on experience in implementation and performance tuning Hadoop/Spark implementations.
- Awareness of Agile QA Software development life cycle –backlog, sprints, standups, burndowns.