ETL Testing Specialist - Data Warehouse & Automation

Infosys Limited; Richardson (TX); Vor Ort; USD 95.000 - 135.000; Vollzeit

Benefits dieser Stelle

Long-term/Short-term Disability

Health and Dependent Care Reimburse

Insurance (Accident, Critical Illness,

401(k) plan

Zusammenfassung

Infosys Limited is seeking a Technology Consultant 2 focused on Data Warehouse Testing for its US Financial Services unit. You will contribute to end-to-end data solutions, from requirements through production, leveraging Spark, Python, and various ETL tools across cloud platforms.

You will collaborate with cross-functional teams, implement robust test strategies, and help maintain data quality and reliability in banking, wealth management, and insurance projects.

Qualifikationen

• Experience in Data Warehousing concepts including Facts, Dimensions, Star Schema, and SCD validations.
• Experience building and maintaining scalable ETL/data pipelines using Spark, PySpark, Spark SQL, and Python with 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 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 Spark pipelines (reconciliation, schema validation, data profiling, exception handling).
• 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/Shell scripting for ETL and data validation activities.

Aufgaben

• Document assigned parts of business requirements to guide technical teams.
• Facilitate design discussions and document decisions for software solutions.
• Participate in coding and integrate features while maintaining stability.
• Conduct code reviews and maintain code repositories.
• Implement test strategies and coordinate bug fixes.
• Develop user training materials and support frameworks.
• Resolve production issues and propose preventive strategies.
• Maintain detailed records of code, testing techniques, and knowledge base.

Kenntnisse

Data warehousing concepts

End-to-end SDLC

Python automation

Spark/SparkSQL

Data quality controls

Ausbildung

Bachelor’s degree

Tools

Informatica

Ab Initio

ODI

SSIS

Databricks

Azure Data Factory

DataStage

Autosys

Control-M

Airflow

Jobbeschreibung

Infosys Limited is seeking a Technology Consultant 2 focused on Data Warehouse Testing for its US Financial Services unit. You will contribute to end-to-end data solutions, from requirements through production, leveraging Spark, Python, and various ETL tools across cloud platforms.

You will collaborate with cross-functional teams, implement robust test strategies, and help maintain data quality and reliability in banking, wealth management, and insurance projects.