Datastage Consultant

Datastage Consultant

Job Code: TJ_1794
Job Location: Iselin, New Jersey
Zip Code: 08830
Job Category/Title:
Employment Category: Contract - Corp-to-Corp, Contract - Independent, Contract - W2
Position Type: Senior Level
Travel Required: No
Interview Type: In-person
Education: Associate Degree
Experience: 5-10 year(s)
Job Description: Skills:

• Primary Skills: Data Stage, Quality Stage, Oracle SQL # of Years Required: 6-8.
• Secondary Skills: IBM MDM # of Years Required: 6-8.

Job Purpose/ Description:

• 6-8 plus years of IT work experience in IBM DataStage is a MUST
• 6-8 plus years of IT work experience in Oracle RDBMS is a MUST
• 1-2 Years of IBM CDI/MDM is desirable 1-2 Years of Autosys is desirable
• Minimum of 6-8 years of IT work experience focused in Data Acquisition and Data Integration using DataStage
• Experience integrating the components of the following ORACLE, SQL and Data Stage (ETL)
• Deep Experience working with flat files, XML transformations
• Deep experience in Quality Stage, Data Acquisition and Data Integration
• Solid experience with Quality Stage Address Standardization CASS modules is required.
• Deep experience in ETL development using DataStage V8 and/or V11
• Ability to design multi-tiered data delivery applications based on given requirements
• Ability to facilitate requirements and design sessions with analytic business users
• Experience creating high level and low level designs and working with business stakeholders to
• Experience with IBM CDI/MDM is desirable
• Minimum 6-8 years Experience with ORACLE Analyzes performance and capacity issues of the highest complexity with systems / applications software and/or application components.
• Provides mentoring and training to junior staff.
• Excels at working collaboratively with IT staff on development, troubleshooting, and other technical efforts.
• Translates business requirements into functional / technical specifications; oversees implementation of these specifications.

Tasks and Responsibilities:

• Logical descriptions the extract, transform, and load process
• ETL High Level Design
• ETL Detailed Design
• Input and output record layouts
• File/Directory naming conventions
• File/table sizing information
• File/table volume information
• File retention/archival information
• Documentation on how the data will be transformed
• ETL Test Plan
• ETL Performance Test Plan
• Mapping Specification
• Mappings
• Workflows
• Unit Test Documentation
• Tested ETL processes
• Validated ETL processes
• Accurate and efficient ETL process moved to production
• Required education/experience: Bachelors Degree or equivalent work experience in Computer Science, Information Systems, or other related field.
Duration: 6 Month(s)
No. of Posts: 1
Job Expiry Date: April 9, 2016
Telecommute: No
Contact Information Login To View