applicants

Data integrator XI (ETL) Consultant Qualifications

Our client, located in the Bridgeport area is looking to add an ETL Data Integrator to their growing staff. This is a 4-6 month project with a possibility of extension. The ideal candidate will have strong leadership qualities, be a self starter and possess excellent oral and written communication skills. He/She will have strong technical, analytical, and organizational skills and have the ability to work independently on projects. They will have the ability to work under pressure and meet challenging deadlines.

In addition, the ideal candidate will possess the following skills:

• Experience with all phases of the Software Development Life Cycle (SDLC). * Experience in developing, maintaining, and documenting data standards, guidelines and procedures. * Knowledge of Source Controls tools 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. * Strong knowledge of SQL, PL/SQL, Stored procedures and query tuning.

Data Integrator XI (ETL) Programming Qualifications

• Two or more years of 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.