ETL Test Engineer

Job Title : Data Warehouse Tester

Experience : 8+ Years

Location : Pune

Job Summary :

We are looking for a skilled Data Warehouse Tester to join our team and ensure the accuracy, integrity, and performance of data warehouse solutions. The ideal candidate will have experience reviewing complex SQL queries, identifying performance bottlenecks, validating ETL processes, and automating testing activities in a banking or financial domain setup.

Key Responsibilities :

• Review and analyze complex SQL queries to validate data accuracy and business requirements.
• Identify and troubleshoot performance bottlenecks in SQL and PL / SQL programs to optimize data retrieval processes.
• Review PL / SQL stored procedures, functions, and packages for quality, correctness, and efficiency.
• Identify opportunities for automation in data-centric testing to improve efficiency and coverage.
• Perform effort estimation for data testing activities including test planning, preparation, execution, and reporting.
• Prepare comprehensive test plans that include scope, objectives, resources, schedules, and deliverables.
• Execute data validation and ETL testing to ensure data consistency and integrity across source and target systems.
• Validate data warehouse data flows and transformations by matching source data against target tables.
• Work extensively with multiple ETL tools (e.G., Informatica, DataStage), reporting tools (e.G., Tableau, Power BI), and databases (Oracle, SQL Server, Teradata).
• Collaborate with developers, data engineers, and business analysts to clarify requirements, track defects, and drive issue resolution.
• Use tools such as MS Project for project tracking and coordination.
• Participate in regression, integration, and system testing, documenting all results and defects clearly.
• Support production validation and post-deployment testing activities to ensure smooth go-lives.

Required Skills and Qualifications :

Preferred Qualifications :