ETL DataStage Developer
PSG Global Solutions · New Jersey
📍 Woodbridge Township, NJ, usvia smartrecruitersPosted 2016-02-04
Apply on company site ↗
CareerRiver pulls this listing straight from the employer's hiring system — no recruiter middleman, no reposts. Applying takes you directly to PSG Global Solutions.
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.
Summary:
We are seeking an ETL Developer (DataStage) for long-term consulting work with a Fortune 500 organization in Central New Jersey.
Job Purpose/ Description:
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
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.
Renil John "Neil" Cervantes
National Talent Advisor - TrueBridge Resources
+1 980 244 3270
More New Jersey jobs
New Jersey jobs · Browse all locations