Etl Tester

Infosys

Hyderabad, Pune District, Bengaluru

On-site

INR 600,000 - 1,100,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Infosys is seeking an ETL Tester to join our pan-India delivery teams. You will analyze requirements and data models, design ETL test plans, and validate end-to-end data loading and quality across data warehouse environments.

Ideal candidates have 3–8 years of ETL/Data Warehouse testing experience, strong SQL skills, and hands-on with Informatica, Talend, SSIS, DataStage or Pentaho. Collaboration with data engineers and BI teams is essential.

Qualifications

  • Experience in ETL testing and data warehouse validation.
  • Strong expertise in writing and executing complex SQL queries.
  • Hands-on with Informatica, Talend, SSIS, DataStage, Pentaho or similar tools.
  • Experience validating ETL workflows, mappings, and data pipelines.
  • Knowledge of data warehouse concepts and star/snowflake schemas.
  • Experience with Oracle, SQL Server, MySQL, PostgreSQL, Teradata or Snowflake.
  • Understanding of SDLC, STLC, and Agile methodologies.
  • Proficient defect tracking with JIRA or Azure DevOps.

Responsibilities

  • Analyze business requirements, source-to-target mappings, and data models.
  • Design and execute ETL test plans, test strategies, and cases.
  • Validate data extraction, transformation, and loading processes.
  • Perform source-to-target validation and reconciliation testing.
  • Execute database testing with complex SQL queries.
  • Verify data quality and integrity across systems.
  • Conduct data warehouse, migration, and reporting validation testing.
  • Identify, document, and track defects using defect management tools.
  • Collaborate with developers, analysts, and data engineers to resolve issues.
  • Validate incremental loads, batch jobs, and scheduling processes.
  • Support end-to-end testing in DW and BI environments.
  • Participate in Agile/Scrum ceremonies and quality improvement initiatives.

Skills

ETL Testing
SQL Queries
Informatica
Talend
SSIS
Data Warehousing
Data Migration
JIRA
Azure DevOps

Tools

JIRA
Azure DevOps

Job description

EXP: 2 TO 10 YEARS

Location: PAN INDIA

ETL Testing - Datawarehouse testing , Bigdata testing

Skills:

Key Responsibilities
  • Analyze business requirements, source-to-target mappings, and data models.
  • Design and execute ETL test cases, test plans, and test strategies.
  • Validate data extraction, transformation, and loading processes.
  • Perform source-to-target data validation and reconciliation testing.
  • Execute database testing using complex SQL queries.
  • Verify data quality, completeness, consistency, and integrity across systems.
  • Conduct data warehouse, migration, and reporting validation testing.
  • Identify, document, and track defects using defect management tools.
  • Collaborate with developers, business analysts, and data engineers to resolve data-related issues.
  • Validate incremental loads, batch jobs, and scheduling processes.
  • Support end-to-end testing in Data Warehouse and BI environments.
  • Participate in Agile/Scrum ceremonies and contribute to quality improvement initiatives.
Required Skills
  • 3 to 8 years of experience in ETL Testing and Data Warehouse Testing.
  • Strong expertise in writing and executing complex SQL Queries.
  • Hands-on experience with ETL tools such as Informatica, Talend, SSIS, DataStage, Pentaho, or similar tools.
  • Experience in validating ETL workflows, mappings, transformations, and data pipelines.
  • Knowledge of Data Warehouse concepts, Star Schema, Snowflake Schema, Fact and Dimension tables.
  • Experience with databases such as Oracle, SQL Server, MySQL, PostgreSQL, Teradata, or Snowflake.
  • Strong understanding of Data Migration and Data Validation techniques.
  • Hands-on experience with defect tracking tools like JIRA or Azure DevOps.
  • Understanding of SDLC, STLC, and Agile methodologies.
  • Excellent analytical and troubleshooting skills.
Preferred Skills
  • Experience with Big Data Testing using Hadoop, Hive, Spark, or Databricks.
  • Exposure to cloud platforms such as AWS, Azure, or GCP.
  • Experience in testing data lakes and modern data platforms.
  • Knowledge of automation tools for ETL validation.
  • Familiarity with BI reporting tools like Power BI, Tableau, Cognos, or Business Objects.
  • Experience with Python or Shell scripting for data validation.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Etl Tester-INFY 26
Etl Tester-INFY 26

Infosys • Dadri, Hyderabad, Pune District

Remote
INR 600,000 - 900,000
Software Test Engineer
Software Test Engineer

Infosys • Hyderabad, Pune District, Mumbai

On-site
INR 900,000 - 1,800,000
ETL Testing
ETL Testing

Infosys • Hyderabad

On-site
INR 900,000 - 1,300,000
Etl Testing Engineer
Etl Testing Engineer

Infosys • Chennai District, Bengaluru, Hyderabad

On-site
INR 900,000 - 1,500,000
Senior ETL QA / ETL Testing
Senior ETL QA / ETL Testing

Vivantify Technology Solutions India Pvt. Ltd. • Coimbatore District

On-site
INR 2,500,000 - 4,000,000
ETL Testing-3-10 yrs-Pan India-s
ETL Testing-3-10 yrs-Pan India-s

Infosys • Hyderabad, Chennai District, Bengaluru

Hybrid
INR 1,200,000 - 1,800,000
ETL Tester_HYD_5 To 10 years
ETL Tester_HYD_5 To 10 years

Infosys • Hyderabad

On-site
INR 800,000 - 1,200,000
Etl Testing Engineer
Etl Testing Engineer

LTM • Bengaluru

Hybrid
INR 700,000 - 1,100,000
Etl Tester_4 To 10 years _Hyderabad
Etl Tester_4 To 10 years _Hyderabad

Infosys • Chennai, Bengaluru, Hyderabad

On-site
INR 800,000 - 1,200,000
ETL Tester
ETL Tester

People Centro India • Ernakulam

Hybrid
INR 1,339,000 - 1,786,000