Datastage/Kafka Developer

Senior ETL Developer

Our client's Commercial Lending team is looking for a Senior level ETL (Extract, Transform, Load) Developer to assist on project demand. This role will be required to learn and model using a variety of different ETL tools and databases. Current ETL tools consist of SSIS and DataStage, Databases include SQL server, Oracle, Event Hub (kafka) and DB2. Candidate will need to lead their own work and do dual duty on both Datastage and SQL. Candidate will also be required to develop, maintain and enhance code for new projects and current bank deliverables, ensure all IT SDLC processes are documented and practiced, work closely with the Enterprise Information team, and cross impact other bank applications as code and processes change.

Key Responsibilities

• 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.

Basic Qualifications

• Bachelor’s degree or military experience in related field (preferably computer science).
• At least 5 years of experience in ETL development (Datastage and SQL SSIS).
• Kafka Stream Processing
• At least 5 years of experience writing SQL queries, troubleshooting.
• Star Schema design and coding (Dimension and Fact Table design)
• Understanding of enterprise data warehousing best practices and standards.
• Good communication and interpersonal skills.
• Good organization skills and the ability to work independently as well as with a team.

Preferred Qualifications

• Experience in financial services (banking) industry.
• Focus on customer service
• Willingness and aptitude for continuous improvement
• Event Hub / Query Hub experience would be a plus