Etl Tester-INFY 26

Infosys

Dadri, Hyderabad, Pune District

Remote

INR 600,000 - 900,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 Testing professional for PAN India operations focused on Data Warehouse and Big Data testing. You will analyze requirements, design ETL test plans, and validate extraction, transformation, and loading across multiple data sources and targets.

You will verify data quality, perform database testing with complex SQL, and collaborate with data engineers and BI teams to resolve issues. Knowledge of SDLC/Agile and experience with tools like Informatica, Talend, and JIRA is

Qualifications

  • 3 to 8 years of experience in ETL Testing and Data Warehouse Testing.
  • Proficient in writing and executing complex SQL queries.
  • Hands-on experience with ETL tools Informatica, Talend, SSIS, DataStage, or Pentaho.
  • Experience validating ETL workflows, mappings, transformations, and data pipelines.
  • Knowledge of Data Warehouse concepts: Star/Snowflake schemas, fact and dimension tables.
  • Experience with Oracle, SQL Server, MySQL, PostgreSQL, Teradata, or Snowflake.
  • Strong defect management using JIRA or Azure DevOps.
  • Familiarity with SDLC, STLC and Agile methodologies.
  • Excellent analytical and troubleshooting abilities.

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.

Skills

ETL Testing
SQL Queries
ETL Tools
Data Warehouse Concepts
Data Validation
Defect Tracking
SDLC/Agile
Analytical Skills

Education

Bachelor's degree in a relevant field

Tools

Informatica
Talend
SSIS
DataStage
Pentaho
JIRA
Azure DevOps
Hadoop
Hive
Spark
Databricks

Job description

EXP: 2 TO 10 YEARSLocation: 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
Etl Tester

Infosys • Hyderabad, Pune District, Bengaluru

On-site
INR 600,000 - 1,100,000
Etl Testing Engineer
Etl Testing Engineer

Infosys • Chennai District, Bengaluru, Hyderabad

On-site
INR 900,000 - 1,500,000
ETL Tester
ETL Tester

People Centro India • Ernakulam

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

Leading Client • Bengaluru

Hybrid
INR 800,000 - 1,200,000
Etl Tester-Hyderabad
Etl Tester-Hyderabad

Infosys • Hyderabad, Chennai, Bengaluru

Hybrid
INR 600,000 - 1,000,000
Software Test Engineer
Software Test Engineer

Infosys • Hyderabad, Pune District, Mumbai

On-site
INR 900,000 - 1,800,000
Etl Tester - Hyderabad
Etl Tester - Hyderabad

Infosys • Kolkata District, Hyderabad, Pune District

On-site
INR 900,000 - 1,500,000
ETL Test Engineer
ETL Test Engineer

Infosys • Chennai District

On-site
INR 600,000 - 1,000,000
Data/ETL test lead
Data/ETL test lead

Fa Etvl Saasfaprod1 • Pune District

On-site
INR 2,400,000 - 4,200,000
Senior ETL QA / ETL Testing
Senior ETL QA / ETL Testing

Vivantify • India

Remote
INR 2,800,000 - 4,000,000