Senior Quality Assurance Engineer - ETL/Datawarehouse Testing

Job Summary :

We are seeking an experienced Senior ETL Test Lead / Data Warehouse QA Engineer with strong expertise in ETL Testing, Data Warehouse Validation, Teradata, Informatica, SQL, Python, and API Testing.

The ideal candidate should have experience validating enterprise data platforms, designing complex test scenarios, and ensuring data integrity across large-scale ETL pipelines.

Experience in Banking, Financial Services, or Commercial Lending environments is highly preferred.

Key Responsibilities :

- Design, develop, and execute end-to-end ETL and Data Warehouse test strategies.

- Validate complex ETL workflows, mappings, transformations, and data reconciliation.

- Perform source-to-target data validation across enterprise data warehouses and data marts.

- Develop and execute SQL queries to validate large datasets and business transformations.

- Perform API validation and automate API testing.

- Develop Python-based automation scripts for ETL and data validation.

- Validate enterprise reporting, analytics, and downstream data consumption.

- Perform data quality, reconciliation, and regression testing across multiple data sources.

- Collaborate with Business Analysts, Data Engineers, Developers, and Product teams to understand business requirements.

- Participate in defect management, root cause analysis, test planning, and release validation.

- Work in Agile and Waterfall delivery environments while ensuring high-quality deliverables.

Required Skills :

- 8+ years of experience in ETL Testing and Data Warehouse Testing.

- Strong hands-on experience with Teradata.

- Strong hands-on experience with Informatica.

- Excellent SQL skills with experience writing complex validation queries.

- Strong experience in ETL validation and data reconciliation testing.

- Experience in API testing and automation.

- Strong Python scripting experience.

- Experience validating enterprise Data Warehouses and Data Marts.

- Understanding of data architecture, data lineage, metadata, and enterprise data governance.

- Experience in defect management, test planning, and quality assurance best practices.

- Experience working in Agile and Waterfall methodologies.

- Excellent analytical, communication, and stakeholder management skills.

Preferred Skills :

- Experience supporting Commercial Lending System (CLS) implementations or modernization programs.

- Experience in Banking or Financial Services domain.

- Experience validating AI, Analytics, or Reporting solutions.

- Exposure to Data Lake and Cloud Data Platforms.

- Familiarity with enterprise workflow and process automation initiatives.

- Experience with modern enterprise data platforms and cloud technologies.