ETL Testing

ECMS REQ ID

542400

Number of Openings

2

Detailed JD (Roles and Responsibilities)

• Design and execute ETL test strategies for data ingestion, transformation, and reporting.

• Develop Python scripts to automate data validation, reconciliation, and regression testing.

• Validate data across source systems and target databases (DB2, Netezza, Oracle, SQL Server, and Snowflake).

• Perform schema validation, data profiling, and row-level comparisons.

• Experience on DataStage tool

• Execute the ETL Jobs through DataStage and ControlM

• Good Experience on ControlM Scheduler

• Maintain test documentation, test cases, and defect logs.

• Participate in Agile ceremonies and contribute to continuous improvement.

• Strong experience in ETL Testing across data warehouses and lakes.

• Proficiency in Python for test automation and data validation.

• Hands-on experience with SQL (Oracle, PostgreSQL, Snowflake).

• Good Communication skills.

Total Experience

3+ Years

Relevant Experience

3 Years

Mandatory skills

ETL Testing, SQL Query, Python

Desired skills

ETL Testing, SQL Query

Domain (Industry)

Banking

Work Location

Infosys DC locations

Vendor rate

6800 INR / Day

Background checK (Before onboarding / After onboarding)

After Onboarding

Mode of Interview- Telephonic/Face to Face/Video Interview

Face to Face

WFO / WFH / Hybrid

Hybrid

Shift Details (Time)

Regular Shift / on need basis second shift