Senior Engineer - ETL Testing / TOSCA

Key Responsibilities

• Collaborate with Product Owners, Product Managers, and Scrum Teams to review backlog items and define Test Requirements.
• Design and implement test strategies and test plan for end-to-end ETL, BI, and data integration solutions, including functional, non-functional, system, UAT and regression testing.
• Perform comprehensive testing for transactional and analytical systems, data pipelines, including File based, API, streaming, and cloud-to-cloud data sharing, to ensure data integrity and system compliance
• Develop and implement automated testing solutions using appropriate test automation frameworks to optimize efficiency and repetitive validation tasks.
• Validate data transformations using advanced SQL, stored procedures, and database design principles.
• Utilize Unix / Python scripting for data validation, and process automation.
• Contribute to developing ETL solutions using tools like Talend or DataStage OR building stored procedures, scheduling workflows, and integrating data pipelines. Additionally, develop BI reports using tools like Power BI or Cognos.
• Apply expertise in data warehousing concepts, dimensional modeling, and data mart design for validation and testing.
• Track, document, and manage defects and test artifacts using test management tools like JIRA, Zephyr, and Confluence.
• Act as a Testing SME, sharing knowledge artifacts and best practices across the team.
• Proactively conduct data audits and assessments to identify and resolve quality issues across data sources.
• Ensure compliance with data governance policies and assess business processes for efficiency improvements.
• Troubleshoot production issues, host defect Triage and collaborating with developers and Business to ensure timely resolution.
• Adapt to shifting priorities, communicate progress effectively, and support continuous improvements in testing processes.

Key Skills (Must Have s) :

Non-Technical Skills :

Key Skills (Nice to Have s) :

Skills Required

Talend, Datastage, Tosca, Advanced Sql, Power Bi, Python