Etl Tester

Skills and attributes for success

• Develop Test Strategy for Testing BI & DWH Projects for various aspects like ETL testing & Reports testing (Front end and Backend Testing), Integration Testing and UAT as needed. Provide inputs for Test Planning aligned with Test Strategy.
• Perform Test Case design, identify opportunity for Test Automation. Develop Test Cases both Manual and Automation Scripts as required.
• Ensure Test readiness (Test Environment, Test Data, Tools Licenses etc)
• Coordinate testing efforts with cross-functional teams, including ETL developers, data engineers, business analysts, and project managers, to ensure testing aligns with project timelines and objectives

To qualify for the role, you must have

• BE/BTech/MCA/M.Sc
• Overall 5-8 years of experience in Testing Data warehousing / Business Intelligence solutions, minimum 3 years of experience in Testing BI & DWH technologies and Analytics applications.
• Strong in Data warehouse testing - ETL and BI and having exposure to the reporting tools such as Cognos/PowerBI/Tableau/Qlik etc
• Exposure to one or more ETL tools such as Informatica, SSIS, SAP Data services, AWS Glue, Azure Data factory
• Strong SQL skills with experience in writing complex data validation SQLs on databases like Oracle/ SQL Server/ Teradata / Snowflake/Postgres/Redshift
• Proficiency in data services of any leading cloud providers like AWS, Azure, GCP and thorough knowledge on data platforms like Databricks, Azure synapse
• Validate data integrity and consistency across various stages of ETL pipelines.
• Experience in master data management (MDM) is added advantage
• Working experience with python data processing is desirable.
• Work with cross-functional teams to ensure that ETL solutions meet business needs and quality standards.
• Experience in Bigdata testing with Hadoop/Spark framework and exposure to predictive analytics testing is desirable

Ideally, youll also have

• Experience in Performance & Load Testing for backend systems is preferred. Exposure to Performance Tuning (Tuning concepts - indexes, segments, partitions, query tuning) of database systems would be an added advantage.
• Experience/ exposure to Test Automation and scripting experience in perl & shell is desirable
• Experience with Test Management and Defect Management tools preferably HP ALM
• Able to contribute as an individual contributor and when required Lead a small Team
• Able to create Test Strategy & Test Plan for Testing BI & DWH applications/ solutions that are moderate to complex / high risk Systems
• Design Test Cases, Test Data and perform Test Execution & Reporting. Should be able to perform Test Management for small Projects as and when required
• Participate in Defect Triaging and track the defects for resolution/ conclusion
• Good communication skills (both written & verbal)
• Good understanding of SDLC, test process in particular
• Good analytical & problem solving or troubleshooting skills
• Good understanding of Project Life Cycle and Test Life Cycle. Exposure to CMMi and Process improvement Frameworks is a plus. Should have excellent communication skills & should be able to articulate concisely & clearly
• Should be ready to do an individual contributor as well as Team Leader role