Description

Key Skills

Datastage, sql

Responsibilities

Responsibilities include:

• Development and support for IBM InfoSphere Datastage datastage ETL jobs necessary to build a
• simplified Dealer Datamart
• Providing integrated data services by loading complex data from multiple regions and multiple
• applications into one simplified datamart
• Supporting data for a large number of applications and significant enterprise projects that will
• enable data-driven decisions to create a competitive advantage for the company
• DNI needs 2 Software Engineers with experience in delivering ETL solutions. This is a terrific opportunity
• to become part of a global team, contribute to strategic client data & project initiatives, as well as learn
• various aspects of the client Dealer & Market Retail IT and business processes.
• Key Responsibilities:
• Be a part a client product team and collaborate with a Product Owner, Product Manager, Anchor,
• and software engineers
• Work with Business teams to understand requirements for PDO Backlog features and deliver ETL
• solutions with high business value using Agile
• Assist with analyzing commonality in DNI datamart models and identify needs for Extract,
• Transform and Load (ETL)
• Contribute to the migration from mainframe ETL to DataStage ETL and the creation of a Dealer
• datamart
• Participate in PDO product team ceremonies such as Standups, Iteration Planning,
• Retrospectives, and Release Planning

Position Qualifications:

• ETL development experience with IBM DataStage v11.7
• Experience with AutoSys job scheduling
• SQL/database experience involving multiple, complex queries
• Exceptional analytical experience of complex applications and data relationships
• Experience with Linux/Unix Shell scripting and file management
• Team oriented with strong interpersonal skills and able to work as part of a product team
• Strong written/oral communication skills
• Strong drive for results and ability to work independently
• Demonstrated commitment to quality and project timing
• Experience in creating and executing detailed test plans

Nice to Have Skills:

• Experience in extract, transform and load (ETL) development with Oracle
• Knowledge and experience with DB2/SQL, FTP, Connect Direct
• Experience with mainframe languages/tools including COBOL, JCL, CA7
• Experience with Java and API development
• Experience with Rally

Education Required:

• Bachelor's degree in Information Technology or a related discipline

Experience Required :

• 5+ years ETL development and integration experience with IBM InfoSphere
• (DataStage v11.5)
• 5+ years SQL development experience

Key Skills

Education

Any Graduate