Search Jobs

DataStage ETL Developer

Status : Open

Openings: 3

Location; NEW YORK

Number of Years Required: 6-8
Targeted Skills & Competencies:
The ETL Developer / Tech lead will be responsible for the delivery of all ETL artifacts from the design to the delivery phase. They will be 100% accountable for the quality of all ETL code within their control. They will work with their business partners to ensure the business requirements are met for specific data integration projects throughout the organization.

Expected Responsibilities:

Expertise in Extraction, Cleansing, Validating and Integrating of data from multiple systems. Hands on experience in Transforming Business specific rules into functional Specs. Work with the Data Integration Architect to create ETL standards, High Level and Low-level design documents. Strong experience in designing Parallel, Server Jobs, Job Sequencers and Batch Jobs in DataStage 8.1.2 and 8.5 Extensively worked with portioning for splitting multiple data streams into sub chunks to distribute the load evenly across all available processors to achieve maximum thru put. Strong Knowledge of Data Warehouse Architecture, Star Schema, Snow flake Schema, Fact tables and Dimensional tables. Experience in Integration of various data sources like TeraData, DB2UDB, SQL Server, Oracle, Sybase and Ms-Access. Strong experience in writing database procedures, functions and fine-tuning SQL for performance optimization. Good experience in writing Shell Scripts to automate file manipulation and data loading procedures. Responsible for Production Support and involved in On-Call for Data Integration applications. Hands on experience in tuning mappings, identify and resolving performance bottlenecks in various levels like source and target mappings.

Tasks and Responsibilities:

Suggested Experience & Qualifications: Bachelors degree in Computer Science or related field, or equivalent work experience Good Domain Knowledge in Finance and Asset Management Excellent team player with good organizational, communicational, analytical and logical skills. A minimum of a bachelor of science in Computer Science, CIS/MIS or equivalent degree from an accredited four year institution. Typically 4-5years of experience, including project management, application development, infrastructure selection and support, and systems technology analysis, with a heavy emphasis on DataStage ETL In-depth knowledge of one or more financial business functions. Collaboration and consensus building among diverse groups. Ability to handle multiple tasks and to work independently as well as in a team, experienced in interacting with Business/Technology group

Interested candidates can post their updated resume to felix@gantecusa.com




No comments:

Post a Comment