ETL Infosphere DataStage Developer

ETL : 

Job Description

The primary responsibility will be to design, develop and maintain the various ETL/CDC solutions (Infosphere, ESB) consisting of data exchange process models, ETL specifications and underlying ETL code base serving (online transaction- based, MDM, etc) applications, specialized data warehouse and data mart applications. He or she will possess ETL skills.

Analyze business requirements to design, build, develop and implement highly efficient, highly scalable ETL processes and the ETL development efforts

• Work with the Solution and Enterprise Architects to resolve any issues encountered during the development, testing and deployment phases of development projects

• Provide input to the Data Architecture function on data management standards and conventions, data dictionaries, data element naming standards and metadata standards

• Deliver assigned work on schedule and provide regular status reports to the Project Manager(s) and team manager

• Perform data mappings and design of ETL workflow solutions

• Define data extract, transformation and load routines as necessary to support requirements, in the form of a design specification

• Prepare, maintain and publish ETL documentation, including design, source-to-target mappings and business-driven transformation rules

• Define, document and develop unit test cases