ETL Testing Consultant

Infosys

About The Position

The ETL Testing Consultant works in the assigned Job Role of Technology Consultant 2 within Infosys Financial Services. The role contributes to software delivery across the SDLC, from requirements gathering and design through coding, testing, implementation, and production support. It focuses on data warehouse and ETL testing, automation, data quality, and validation across financial datasets and cloud-based data platforms. The position may require relocation and/or travel to the work or project location. Applicants must be authorized to work in the United States without employer-based visa sponsorship; Infosys cannot provide immigration sponsorship for this role now or in the future. Infosys Financial Services works with financial institutions on digital transformation, using AI, cloud, and data-led innovation across banking, wealth management, and insurance. The company describes itself as a global digital services and consulting provider serving clients in more than 50 countries.

Requirements

Experience understanding data warehousing testing concepts, including facts, dimensions, star schema, and SCD validations.
Experience building and maintaining scalable ETL, data warehouse, and data migration pipelines using Apache Spark, PySpark, Spark SQL, and Python, with a focus on end-to-end automation.
Strong expertise in SparkSQL and database validation across Oracle, SQL Server, PostgreSQL, Snowflake, AWS Redshift, or BigQuery.
Experience developing Python-based automation for ETL pipeline execution, data ingestion, transformation, and operational workflows.
Experience with ETL tools such as Informatica, Ab Initio, ODI, SSIS, DataStage, Azure Data Factory, or Databricks.
Experience developing automated data quality controls within Apache Spark pipelines, including reconciliation, schema validation, data profiling, and exception handling for high-volume financial datasets.
Experience validating cloud-based data platforms on AWS, Azure, Databricks, Snowflake, or GCP.
Experience with batch job validation, workflow monitoring, and scheduling tools such as Autosys, Control-M, or Airflow.
Experience developing automation solutions using Python or Shell scripting for ETL and data validation activities.
Bachelor’s degree or foreign equivalent from an accredited institution, or three years of progressive experience in the specialty in lieu of each year of education.
Must be authorized to work for any employer in the United States without employer-based visa sponsorship.

Nice To Haves

Experience in banking, capital markets, wealth management, or mortgage domains.
Experience using Selenium and Python for automation testing.

Responsibilities

Document assigned portions of business requirements as part of requirements elicitation.
Facilitate software application design discussions and document design decisions for the technical team.
Participate in coding and integrate new features or updates into existing applications while maintaining system stability.
Conduct code reviews, make codebase changes, and maintain code repositories.
Implement test strategies, analyze results, and coordinate bug fixes to uphold software quality standards.
Develop user training programs, documentation, and support frameworks to facilitate transitions to new software applications.
Help resolve production issues and recommend preventive strategies to improve system reliability.
Maintain records of code, testing techniques, and support activities for the knowledge base and related projects.
Contribute across end-to-end SDLC phases, translating requirements into development tasks and collaborating with cross-functional teams on software integration.
Develop and maintain automated ETL, data warehouse, and data migration pipelines and validate data quality, ingestion, transformation, workflows, and operational processes.