Job Description

• Collaborate with cross-functional teams to understand ETL requirements and specifications.
• Design, develop, and execute ETL test cases and scenarios to validate data accuracy, transformation, and integration across systems.
• Perform data validation and reconciliation between source and target systems.
• Identify, document, and report defects and anomalies in ETL processes and data flows.
• Develop and maintain test data sets for ETL testing purposes.
• Perform performance and scalability testing of ETL processes to ensure optimal performance and efficient data processing.
• Utilize ETL tools, AWS services, Snowflake, and Teradata to conduct testing activities.
• Participate in the design and implementation of testing frameworks and methodologies to improve testing efficiency and effectiveness.
• Collaborate with developers, data engineers, and data analysts to understand data structures and mappings.
• Conduct root cause analysis and collaborate with teams to address and resolve ETL-related issues.
• Keep up to date with industry best practices and emerging technologies in ETL testing, AWS, Snowflake, and Teradata.
• Prior automation experience will be given priority.

Qualifications :

• Proven experience as an ETL Tester or Data Quality Analyst.
• Strong hands-on experience with ETL testing tools and methodologies.
• Proficiency in using ETL tools such as Informatica, Talend, or similar.
• Solid understanding of AWS services related to data integration and storage.
• Experience working with Snowflake and Teradata databases.
• Knowledge of SQL and data querying for validation purposes.
• Familiarity with data warehousing concepts and data modeling.
• Strong analytical skills and attention to detail.
• Excellent communication and collaboration skills.
• Ability to work in an Agile development environment.
• AWS or ETL certification is a plus.
• Prior automation exposure will be given priority
• HC experience

Job Tags

Similar Jobs