01
TRPD-26-05504
ETL/DWH Test Engineer (Data Warehouse Testing)
Hiring an ETL/DWH Test Engineer (5–10 years) to validate end-to-end data pipelines and warehouse loads. The role focuses on analyzing business requirements and source-to-target mappings, creating ETL test plans/cases/data, executing backend/database/regression/integration and migration testing, and performing deep data validation (completeness, accuracy, integrity, uniqueness, consistency). Strong SQL (joins, subqueries, aggregations, analytic functions) and defect documentation/management are essential; exposure to common ETL tools and cloud data platforms is a plus.
Position summary
- Location
- India
- Workplace
- On-site
- Employment
- Full Time
- Experience
- Minimum 5 years and Maximum 10 years
Role overview
Why This Role Matters.
Hiring an ETL/DWH Test Engineer (5–10 years) to validate end-to-end data pipelines and warehouse loads. The role focuses on analyzing business requirements and source-to-target mappings, creating ETL test plans/cases/data, executing backend/database/regression/integration and migration testing, and performing deep data validation (completeness, accuracy, integrity, uniqueness, consistency). Strong SQL (joins, subqueries, aggregations, analytic functions) and defect documentation/management are essential; exposure to common ETL tools and cloud data platforms is a plus.
Your Impact
Deliver Enterprise Value
Help organisations solve complex business problems through modern technology, consulting expertise and measurable outcomes.
Collaboration
Work Across Teams
Collaborate with consultants, architects, engineers and client stakeholders throughout the project lifecycle.
Growth
Learn Continuously
Gain exposure to enterprise technologies, certifications, mentoring and real-world project experience.
Career Path
Grow With Ubique
Build a long-term consulting career with opportunities to take on greater responsibility and leadership over time.
Responsibilities
What You'll Be Doing.
Every role at Ubique contributes directly to solving meaningful business challenges for our clients.
02
Prepare test plans, test scenarios, test cases and test data for ETL workflows.
03
Validate data extraction, transformation, loading, aggregation and business rules.
04
Perform source-to-target data validation and reconciliation.
05
Write complex SQL queries involving joins, subqueries, aggregations and analytical functions.
06
Validate data completeness, accuracy, integrity, uniqueness and consistency.
07
Test incremental loads, full loads, duplicate records, null values and exception handling.
08
Perform backend, database, regression, integration and data migration testing.
09
Investigate data mismatches and coordinate with ETL developers and data engineering teams.
10
Document defects, test evidence, execution results and closure reports.
11
ETL testing and Data Warehouse (DWH) testing.
12
Strong SQL and database testing.
Technology stack
Tools & Technologies.
The platforms and technologies you'll use to build modern, enterprise-grade solutions.
01
ETL testing
Required
02
DWH testing
Required
03
Data warehouse
Required
04
SQL
Required
05
Database testing
Required
06
Source-to-target mapping
Required
07
S2T validation
Required
08
Data reconciliation
Required
09
Data validation
Required
10
Data quality
Required
11
Incremental load
Required
12
Full load
Required
13
Regression testing
Required
14
Integration testing
Required
15
Data migration testing
Required
16
Informatica
Required
17
DataStage
Required
18
SSIS
Required
19
Talend
Required
20
Snowflake
Required
Requirements
Skills & Experience.
We value curiosity, collaboration and continuous learning. If you don't meet every requirement but believe you can make an impact, we'd still love to hear from you.
Essential
Required Qualifications
ETL testing
Data Warehouse (DWH) testing
Strong SQL (joins, subqueries, aggregations, analytical/window functions)
Database testing / backend testing
Source-to-target (S2T) mapping validation
Data reconciliation (source vs target)
Understanding of ETL workflows and data transformations
Validation of business rules and aggregations
Data quality validation (completeness, accuracy, integrity, uniqueness, consistency)
Testing incremental loads and full loads
Handling duplicates, nulls, and exception scenarios in ETL testing
Defect management (logging, tracking, closure)
Test documentation (test plans, scenarios, cases, evidence, execution results, closure reports)
Regression testing
Integration testing
Data migration testing
Preferred
Nice to Have
Informatica
IBM DataStage
SSIS
Talend
Snowflake
Oracle
SQL Server
Teradata
AWS Glue
Data lake / lakehouse concepts
Banking domain experience
What you'll gain
More Than Just A Job.
We're committed to helping every team member grow professionally, personally and technically while working on meaningful projects.
Global Exposure
Collaborate with international clients and multicultural teams on enterprise programmes.
Continuous Learning
Expand your expertise through mentoring, certifications and hands-on project experience.
Career Growth
Take ownership, develop leadership skills and grow your consulting career over time.
Flexible Working
Hybrid and remote collaboration designed around trust and delivering exceptional outcomes.
People First
Join a supportive culture where collaboration, respect and long-term relationships come first.
Enterprise Projects
Work on meaningful technology initiatives for leading organisations across industries.
Apply
Apply for ETL/DWH Test Engineer (Data Warehouse Testing)
One page, about two minutes. We only ask for what we actually need to have a first conversation.