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