Description

You own the administration, release pipeline, and optimization of the ETL environment for US data warehouse projects.

This role is on-site.

Responsibilities

• Perform import and export of ETL jobs across various projects and servers, maintaining ownership of release activities.
• Conduct ETL optimization, troubleshooting, and debugging for production and job issues.
• Establish projects, roles, users, and privileges in DEV, QA, and PROD environments.
• Record and maintain ETL software procedures, ensuring repeatable and scalable operations.
• Collaborate with data warehouse developers to implement and support ETL solutions.

Required Skills

• 8+ years of experience in data warehouse testing or development.
• Expert in SQL, including creating source-to-target comparison test cases.
• Proficient with PySpark, Python, and Databricks.
• Experience with Azure Data Factory and Azure Data Bricks.
• Familiarity with Mainframe technologies including COBOL Copybooks and EBCDIC.
• Hands-on experience with GitHub, JIRA, and Agile Kanban/Scrum methodologies.
• Knowledge of ETL tools such as Informatica and automation tools like Autosys.

Preferred Skills

• Azure certifications (AZ-900, DP-900, or DP-203).
• Experience with Tosca or other quality engineering automation tools.

Key Skills

Education

Bachelor's degree