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)

Role & Responsibilities

• 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.

Skills & Qualifications

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.

Benefits & Culture Highlights

• 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