QA Engineer

• 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
• 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
• Be a self-starter and possess the ability to research issues and improve processes
• Show initiatives and accountability with strong time management skills with project teams.

Must Have:

• 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

Education and Experience:

• Bachelor Degree in Science or Engineering or Equivalent with overall 5 years of experience or Masters Degree in Science or Engineering or Equivalent with overall 3 years of experience in IT fields.