ETL Test Engineer - SQL Data Warehousing

Key Responsibilities

• Write and optimize complex SQL queries to validate data transformation and migration logic.
• Design and execute detailed test plans and scripts for ETL processes.
• Perform data reconciliation between source and target systems using advanced SQL techniques.
• Validate ETL workflows and data pipelines for accuracy, completeness, and performance.
• Collaborate closely with developers and business analysts to troubleshoot and resolve data-related defects.
• Automate ETL test cases to enhance scalability and reduce manual effort.
• Document test results and maintain defect tracking Skills :
• Expert-level SQL skills, including writing and debugging complex queries for data validation.
• Hands-on experience with Informatica.
• Strong understanding of data warehousing concepts, including Star Schema and dimensional modeling.
• Ability to work with large datasets and perform multi-table joins, aggregations, window functions, and subqueries.
• Exposure to Informatica or similar ETL tools is important, but SQL proficiency is the top Information :