Jobs
Interviews
Upskill
Job Alerts
Tools

Upskill and Grow with AI

Skill Gap and Learning Paths See what your target role asks for and learn it free

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on job portals effortlessly

Interview Questions Streamline interviews with ready-to-use questions

Companies Explore leading companies actively hiring talent

Home
>
Jobs in Hyderabad
>
Infosys
>
Etl Tester

Etl Tester

Name: Jobpe
Address: T-Hub, Plot No 1/C, Sy No 83/1, Raidurgam panmaktha, Knowledge City Rd, Hyderabad, Telangana, 500081, IN
Telephone: +91-83339-09630
Price range: Free

Infosys

10 - 15 years

Hyderabad Pune Delhi

Posted:1 week ago

Apply

Job Description

Data Warehouse Testing Engineer - Job Description

Job Title:

Job Summary

We are looking for a skilled Data Warehouse Testing Engineer to validate and ensure the quality, accuracy, and integrity of data across Data Warehouse, ETL, and Reporting systems. The ideal candidate should have strong expertise in SQL, Data Warehousing concepts, ETL testing, and source-to-target data validation.

Key Responsibilities

Analyze business requirements, data models, and source-to-target mapping documents.
Develop test strategies, test plans, test cases, and test scenarios for Data Warehouse projects.
Validate data extraction, transformation, and loading (ETL) processes.
Perform data reconciliation and source-to-target validation.
Verify data accuracy, completeness, consistency, and integrity across systems.
Execute functional, integration, regression, and system testing.
Validate reports, dashboards, and business intelligence solutions.
Perform backend testing using complex SQL queries.
Identify, document, and track defects using defect management tools.
Collaborate with Data Engineers, ETL Developers, Business Analysts, and stakeholders.
Prepare test execution reports and quality metrics.

Required Skills

Strong experience in
Data Warehouse Testing
and
ETL Testing
.
Advanced SQL skills including joins, subqueries, aggregations, and stored procedures.
Strong understanding of
Data Warehousing Concepts
:

Fact and Dimension Tables
Star Schema
Snowflake Schema
Slowly Changing Dimensions (SCD)
OLAP Concepts

Experience with ETL tools such as Informatica, SSIS, Talend, DataStage, or Ab Initio.
Expertise in source-to-target data validation and data reconciliation.
Experience with defect tracking tools such as JIRA.
Knowledge of Software Testing Life Cycle (STLC) and Agile methodologies.

Preferred Skills

Experience with Cloud Data Warehouses:

Snowflake
Amazon Redshift
Azure Synapse
Google BigQuery

Knowledge of Big Data technologies such as Hadoop, Hive, and Spark.
Experience with BI tools such as Power BI, Tableau, or Cognos.
Basic automation knowledge using Python or SQL scripting.
Experience with Data Lake and Data Migration Testing.

Qualifications

Bachelor's degree in Computer Science, Information Technology, or related field.
ISTQB or relevant Data Testing certifications are preferred.

Key Competencies

Strong analytical and problem-solving skills.
Excellent attention to detail.
Ability to understand complex data flows and business rules.
Strong communication and stakeholder management skills.
Ability to work independently and within cross-functional teams.

Keywords for Resume Screening

Data Warehouse Testing, ETL Testing, SQL, Data Validation, Data Reconciliation, Informatica, SSIS, Talend, DataStage, Ab Initio, Star Schema, Snowflake Schema, Fact Tables, Dimension Tables, SCD, Data Migration Testing, Snowflake, Azure Synapse, Redshift, BigQuery, Tableau, Power BI, JIRA, Agile.

Must-Have Skills

Data Warehouse Testing
ETL Testing Advanced SQL Source-to-Target Validation Data Reconciliation Data Warehousing Concepts (Star/Snowflake Schema, Facts & Dimensions) Agile & JIRA Experience

Provide your feedback on BizChat

Skills Required

ETL Testing Data Warehouse Testing DWH Testing Data warehousing Data Software testing Warehouse ETL

Learn the skills this job asks for

See your skill gap for QA / Test Engineer →

Free courses, interview questions and practice for each skill.

Work Mode

Hybrid

Job Type

Full Time

More Jobs at Infosys

Devops Engineer

Bengaluru

6 - 9 yrs

Salary: Not disclosed

Senior Golang Engineer

Bengaluru

5 - 9 yrs

Salary: Not disclosed

Java Developer

Pune, Chennai, Bengaluru

2 - 3 yrs

Salary: Not disclosed

Software Developer - Dotnet

Kolkata, Pune, Bengaluru

5 - 8 yrs

Salary: Not disclosed

Java Back End Developer

Hyderabad, Pune, Bengaluru

1 - 2 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Infosys

IT Services and IT Consulting

Bangalore Karnataka

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Etl Tester