ETL IBM DataStage Developer

Key Responsibilities

• ETL Development & Architecture: Design, develop, and maintain scalable and reliable ETL jobs using IBM DataStage, following established technical specifications, architecture standards, coding standards, and development best practices.
• DataStage Job Design: Develop complex DataStage parallel jobs, job sequences, transformations, mappings, and data integration workflows to support enterprise data movement and business requirements.
• Production Support: Troubleshoot DataStage job failures, investigate root causes, resolve production issues, and provide ongoing operational support for existing ETL processes.
• Data Integration: Develop ETL solutions for data exchanges between agency databases, data warehouses, external agencies, vendors, and open-data platforms.

Required Skills & Qualifications

• Experience: 10+ years of dedicated professional experience utilizing IBM DataStage (version 11.7.x and higher) for enterprise data integration.
• OS & Scripting: Strong, non-negotiable proficiency in Linux operating systems and Linux shell scripting.
• Data Integration Tools: Practical hands-on experience utilizing Kettle alongside DataStage.
• Database & Querying: Advanced proficiency in IBM DB2 and SQL Server, with a proven ability to write complex SQL queries for data-driven validation and optimization.
• Communication & Teamwork: Strong interpersonal skills coupled with articulate verbal and written communication abilities to collaborate effectively across technical and non-technical teams.
• Testing: Experience performing developer-level testing and collaborating with QA teams during SIT, UAT, integration testing, and defect resolution.

Preferred Qualifications

• Experience with JavaScript and HTML for supporting data-driven applications and integration requirements.
• Experience with reporting and visualization tools such as Cognos 11.x and Tableau.