Maxima is looking to hire an ETL IBM DataStage Developer to join our growing team on a new project in Milwaukee. An ideal candidate has experience in financial services, Experience with the auto industry is a plus with a focus on the following:
Duties and Responsibilities
- Translate functional ETL requirements provided by business teams into a technical design document
- Design, develop, enhance, debug, and implement new and existing DataStage jobs and sequences to pull data from source systems, transform to meet business requirements, and load into tables supporting business tools and reports
- Coordinate with Lead Designers on suggestions for improvements and enhancements to existing DataStage jobs and designs
- Work with QA Testers to review test cases and resolve defects
- Partner with Business Analysts to understand business requirements
- Work with Lead Designers for guidance and governance
Required Skills
- Six (6) or more years of experience with IBM Infosphere DataStage development, including:
- Three (3) or more years of experience developing with DataStage version 11.5 or later
- Three (3) or more years of recent experience designing, debugging, and optimizing SQL queries in at least two (2) of the following database environments:
- Oracle 12c or later
- IBM DB2 10.5 or later
- SQL Server 2012 or later
- Three (3) or more years of experience with unit and regression testing of ETL and other technical components in support of QA activities
- Excellent problem-solving and troubleshooting skills
- Excellent written and spoken English communication skills
- Strong attention to detail
- Ability and willingness to demonstrate skills through participation in brief skills testing session (30 minutes or less) prior to any official engagement
- Bring a high level of knowledge and skill to the team regarding DataStage development. Candidate cannot merely supplement existing skills within the team
Preferred Skills
- Data Integration
- Database Modeling
- Process Flow
- Database Architecture
- Review Business Design Requirements
- Database Design
- Current Oracle Certification – OCA, OCP, OCM.
- Experience with data management in a financial environment.
- Experience in a highly-regulated environment.
- Experience with DB2 UDB or Microsoft SQL Server.
- Experience with Service Request management using ServiceNow SaaS solution.
- ITIL Foundation Certification (2011 or later)