DataStage ETL Developer

Role: DataStage ETL Developer Location: Chicago, IL Duration: 12+ months Job Description:

• Design, develop and deliver data integration/data extraction solutions using IBM DataStage and Data Warehouse platforms
• Debug data quality issues by analyzing the upstream sources and provide guidance to data integration team resolutions
• Work closely with support teams for code migrations and production support
• Have a hands-on approach to solving problems; when required, be able to lead-by-example-type of person in developing snippets of the code that team can use and follow
• Have deep knowledge of data architectures, ODSs, Data warehouses and methodologies.
• Own and operate Production ETL teams streamline all production ETL jobs, SLAs and communication channels.
• Maintain and constantly refine the Production failures and escalations; be able to capture, articulate and create knowledge base of Production ETL functioning and potential points of failures.
• Have a thorough knowledge of working in Agile environments and adapt to multiple itineraries running in concurrency.
• Directs system enhancements and projects through the SDLC life cycle, Agile methodologies, defining project objectives, aligning project resources to achieve goals and ensuring established timelines are met.
• Drive the requirement gathering process for all system enhancements initiatives, establishes and enforces best practices for analysis.
• Maintains an in-depth knowledge of business operations and understands the technical scope and objectives of each project.
• Coordinate with Business Partners, Technical Analysts and Developers to identify and define specifications indicate areas of system impact and continuously communicate project status and needs.

• 8+ years of experience as an DataStage ETL architect, developer and data warehouse developer

• ETL, Latest DataStage version x11, Unix, Data Warehouse, and SQL
• Senior level knowledge in Core Competencies: Hands-on development on DataStage as an ETL tool, ETL architecture, Data warehouse development knowledge, Systems Analysis, Project Management, Information Technology/Software Development, Basic Technical Writing and Process Flow Documentation
• Highly skilled in managing all aspects of all sizes and complexities of multiple projects simultaneously across the software development life cycle phases (SDLC)
• Strong track record of interviewing business partners, setting and managing expectations in relation to deliverables and requirements
• Knowledge of Finance industry especially Banking industry is a plus.
• Ability to prioritize and handle multiple projects.
• Great to have Google Cloud Experience
• Excellent problem-solving skills and analytical skills.
• Excellent verbal and written communication skills