ETL DataStage Developer
Company Description
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
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
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
Additional Information
All your information will be kept confidential.
Renil John "Neil" Cervantes
National Talent Advisor - TrueBridge Resources
+1 980 244 3270