ETL Developer

Translate requirements and data mapping documents to a 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 project team.Support continuous improvement by identifying and solving opportunities.

Must-Have Skills:At least 5 years of experience in ETL development within a Data Warehouse.Experience in ETL development within a Data Warehouse.Python/PySpark, DataStage ETL and SQL, AWS and Azure, preferably Snowflake. AWS Certified Solutions Architect Associate, AWS Certified DevOps Engineer Professional and/or AWS Certified Solutions Architect Professional.Deep understanding of enterprise data warehousing best practices and standards.Strong experience in software engineering comprising of designing, developing and operating robust and highly-scalable cloud infrastructure services.Strong experience with Python/PySpark, DataStage ETL and SQL development.Proven experience in cloud infrastructure projects with hands on migration expertise on public clouds such as AWS and Azure, preferably Snowflake.Knowledge of Cybersecurity organization practices, operations, risk management processes, principles, architectural requirements, engineering and threats and vulnerabilities, including incident response methodologies.Understand Authentication & Authorization Services, Identity & Access Management.AWS Certified Solutions Architect Associate, AWS Certified DevOps Engineer Professional and/or AWS Certified Solutions Architect ProfessionalExperience defining future state roadmaps for data warehouse applications.Experience leading teams of developers within a project.Experience in financial services (banking) industry.

Good-to-Have Skills:CA7 scheduling tool knowledge is good to have.Good knowledge of Unix and SQLs is required.

• DataStage
• MS SQL Server
• Python
• Snowflake