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.
