Lead ETL Developer

Role Overview

• Translate requirements and data mapping documents to technical design
• Develop, enhance, and maintain code following best practices and standards
• Create and execute unit test plans
• Support regression and system testing efforts
• Debug and problem solve issues found during testing and/or production
• Communicate status, issues, and blockers with the project team
• Support continuous improvement by identifying and solving opportunities

Requirements

• Bachelor’s degree
• A minimum of 5 years of experience in ETL development (Datastage and PySpark)
• A minimum of 5 years of experience writing SQL queries and troubleshooting
• Star Schema design and coding (Dimension and Fact Table design)
• Understanding of enterprise data warehousing best practices and standards
• Good organization skills and the ability to work independently as well as with a team
• Experience in financial services (banking) industry
• Experience with AWS Cloud technologies and/or Snowflake
• Experience in Agile processes
• Experience leading development teams

Tech Stack

• AWS
• Cloud
• ETL
• PySpark
• SQL

Benefits

• health insurance coverage
• wellness program
• life and disability insurance
• retirement savings plan
• paid leave programs
• paid holidays
• paid time off (PTO)