Datastage Developer (Ref code: 020314-MELTAY-EX-IO34-JOH)
Eagan, MN
6 months+

Job Summary:
The Integration Developer, in conjunction with established process and procedures, writes and tests programs to meet business functionality requirements in compliance with IM (Information Management) Solution Architecture and IM integration guidelines.

Responsibilities:
Analyze source data/file structures, technical metadata, profile source data and develop data mapping and transformation rules and detail ETL specifications based on business requirements;
Assist in the collection of technical metadata supporting the implementation;
Utilize automation tools to schedule, execute, and monitor ETL jobs;
Design, test, and debug data flow plans to populated databases;
Design of the ETL application;
Performance tune the application to meet operational production requirements;
Develop and execute, in conjunction with the ETL Architect, Quality and Release, and Process Analyst system and integration test plans;
Implement audit, balance and controls per business requirements;
Implement upper and lower control limits as required in the business requirements;
Design and code functions of the application in accordance with the ETL standards and architectural guidelines;
Execute test plans and document results and discrepancies;
Prepare applicable ETL application supporting documentation;
Responsible for on-call support;
Assist in researching and resolving data issues uncovered during development and testing.