Data Integrator XI

Location: New York
Duration: 6 Months plus

Description:
Data Integrator XI experience in using Data Integrator for extraction, transformation and loading of data marts.
Expert skills in Data integrator XI (ETL) in design, creation, and implementation of Data Integrator scripts, work flows, and data flows.
Try Block/Catch block
** Knowledge of Source Controls tools is a plus.
** Banking Experience is a plus.
** Familiarity with DOS and FTP commands is a plus.
** Experience in Oracle 8i through 10i; Sybase 11 through 12; Sybase IQ; and MS SQL Server 7.0 through 2005.
** Familiar with Windows; knowledge of SQL, PL/SQL, Stored procedures and query tuning.
Requires;
** Data Integrator XI experience in using Data Integrator for extraction, transformation and loading of data marts.
** Candidate must be able to follow program specifications to write, test, debug, document, and implement complex Batch jobs and Real time jobs to extract data from a variety of data sources, transform the data, and load the data to specified destinations using Data Integrator XI (ETL).
** Know how to define database Data Stores and File Formats to allow Data Integrator XI to connect to the source or target database and files.
** Expert skills in Data integrator XI (ETL) in design, creation, and implementation of Data Integrator scripts, work flows, and data flows.
** Experience in performing simple and complex transformations in Data Flows.
** Ability to design and develop Data Integrator scripts for data transformation.
** Experience in cleansing data in DI using proper data types and mappings.
** Ability to create Workflows using object library and tool palette to execute data flows.
** Experience in Creating, Testing and Executing Data Integrator jobs using Data Integrator Designer to transfer data from source to target.
** Experience in debugging execution errors using Data Integrator logs (trace, statistics, and error) and by examining the target data.
** Experience in implementing Change Data Capture (CDC) is a plus.
Additional Nice to have skillsets;

Data integrator XI (ETL) Administrative Skills are a plus and not a requirement

** Experience in installation and configuration of Data Integrator on Windows.
** Experience in creating and administering the metadata Data Integrator repository in a multi user environment.
** Ability to Configure the Data Integrator Job Server, Data Integrator Access Server, and repository usage.
** Familiar with Administration of the repository including starting and stopping the service; backup and restore; as well as performance tuning.
** Understands how to Configure and Manage adapters.
** Publishing batch jobs and real time services via web services using Data Integrator Administrator.
** Experience in implementation of Recovery Mechanism for unsuccessful batch jobs execution

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