Etl Tester-INFY 26

3 - 8 years

Noida Hyderabad Pune

Posted:5 days ago

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.

Skills Required

Data Warehouse Testing ETL Testing Big Data Testing Software testing Warehouse Data warehousing Data Testing Big Data

Work Mode

Hybrid

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Big Data Interview
cta

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.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Infosys logo
Infosys

IT Services and IT Consulting

Bangalore Karnataka

RecommendedJobs for You