ETL DataStage Developer

PSG Global Solutions; Woodbridge Township (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading staffing firm is looking for an ETL Developer (DataStage) for long-term consulting work with a Fortune 500 organization in Central New Jersey. This role requires a strong focus on ETL development using DataStage, along with experience in Oracle SQL, data acquisition, and integration. Ideal candidates will have 4-6 years of IT experience and the ability to work collaboratively to deliver effective data solutions. Competitive pay with an emphasis on professional growth is offered.

Qualifications

• 4-6 years of IT work experience focused in Data Acquisition and Data Integration using DataStage.
• Experience with Oracle SQL and PL/SQL Package.
• Ability to design multi-tiered data delivery applications based on requirements.

Responsibilities

• Design and implement ETL High Level and Detailed Design.
• Create input/output record layouts and documentation on data transformations.
• Develop and validate ETL processes ensuring they are accurate and efficient.

Skills

ETL development using DataStage

Oracle SQL and PL/SQL

Data acquisition and data integration

UNIX scripting

Collaborative work

Education

Bachelor’s Degree in Computer Science or related field

Job 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 of the extract, transform, and load process
• ETL High Level Design
• ETL Detailed Design
• Input and output record layouts
• File/Directory naming conventions
• 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.

National Talent Advisor - TrueBridge Resources