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.
- Robust 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.