ETL DataStage Developer

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 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 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.