ETL tester/DB testing

A specialist operating in the Financial Services & Risk Management sector, delivering enterprise-grade data warehousing, reporting, and compliance analytics. Our teams build and validate large-scale ETL pipelines that feed risk models, regulatory reports, and operational dashboards for institutional clients.

Role: ETL Test Engineer
Location: India (On-site)

• Design, author, and execute comprehensive ETL test cases to validate data ingestion, transformation, and loading across source-to-target mappings.
• Develop and run SQL-based data validation and reconciliation scripts to detect data mismatches, duplicates, and quality issues.
• Validate complex transformation logic (SCD, CDC, aggregations, joins) and verify data lineage and business rule implementation.
• Log, prioritize, and track defects using test management and issue-tracking tools; collaborate with ETL developers to drive timely fixes.
• Build and maintain test data sets and automation scripts for regression testing and repeatable data validations.
• Contribute to test plans, estimation, and continuous improvement of QA processes and data quality controls.

Must-Have

• SQL
• ETL Testing
• Informatica PowerCenter
• Data Warehousing
• Unix Shell Scripting
• Oracle Database

Preferred

• SSIS
• Hive
• Python

Qualifications

• Proven track record in enterprise ETL / database testing for data warehouse or BI implementations.
• Familiarity with change data capture (CDC), slowly changing dimensions (SCD), and data lineage validation.
• Experience working on-site with cross-functional teams and participating in release cycles for production ETL pipelines.

• On-site, collaborative environment focused on data quality and domain expertise.
• Opportunities for technical growth, cross-training in data engineering and automation.
• Competitive compensation, professional training, and a structured career path in data QA.

If you are a detail-driven ETL tester experienced in validating complex data flows and delivering high data quality in production systems, we encourage you to apply. This role is on-site in India and reports into an experienced data engineering and QA leadership team.

Primary job title used for sourcing: ETL Test Engineer