ETL DataStage Developer

ETL DataStage Developer

Founded on a simple belief – do what's right for our clients and our people. TrueBridge leverages proven talent identification / attraction / screening solutions to match highly qualified IT and business professionals with great opportunities.

We made the Staffing Industry Analyst's 'Fastest Growing' list in 2013, 2014 and 2015.

Job Description

We are seeking an ETL Developer (DataStage) for long-term consulting work with a Fortune 500 organization in Central New Jersey.

• Minimum of 4-6 years of IT work experience focused in Data Acquisition and Data Integration using DataStage
• Minimum 4-6 years of experience with ORACLE SQL and PL/SQL Package
• Experience working with flat files and XML transformations
• Deep experience in ETL development using DataStage V8 or higher
• Ability to design multi-tiered data delivery applications based on given requirements
• Ability to facilitate requirements and design sessions with business users
• Experience creating high level and low level designs and working with business stakeholders
• 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

Qualifications

• Bachelor's Degree or equivalent work experience in Computer Science, Information Systems, or other related field.
• 4-6 plus years of IT work experience in IBM DataStage is a MUST
• 4-6 plus years of IT work experience in Oracle RDBMS is a MUST
• 1-2 Years of UNIX Scripting is desirable
• 1-2 Years of Autosys is desirable

All your information will be kept confidential.