Job Overview:
Evaluate the performance of Extract, Transform, Load (ETL) processes to ensure data accuracy and integrity.
Key Responsibilities:
1. Develop and execute comprehensive ETL test plans, leveraging expertise in source-to-target reconciliation and transformation logic validation.
2. Design and implement custom test automation frameworks using Java, Python, or other object-oriented languages to enhance efficiency and reliability.
3. Collaborate with cross-functional teams to identify areas for process improvements and optimize ETL workflows.
Requirements:
4. Strong programming skills in Java, Python, or other object-oriented languages, with experience building complex test automation frameworks.
5. Expertise in ETL testing, including source-to-target reconciliation and transformation logic validation.
6. Proficiency in Oracle and Snowflake databases, as well as advanced SQL skills for data validation.
7. Experience working with agile methodologies and collaborative tools like JIRA and Xray to ensure traceability and compliance.
8. Familiarity with CI/CD pipelines and quality gates in deployment pipelines is a plus.
Additional Skills:
9. Deep understanding of big data technologies, including Apache Spark and EMR, in distributed data environments.
10. Excellent communication and collaboration skills to work effectively with multiple teams and stakeholders.
Preferred Qualifications:
11. Relevant degree or equivalent in Computer Science, Engineering, or related field.
12. Experience analyzing workflows and identifying opportunities for test automation.
13. Knowledge of Cucumber or BDD tools for designing clear, maintainable business-readable test scenarios.
14. Familiarity with ICEDQ or similar data testing platforms is an asset.