Data Integrator XI (ETL) Consultant

Description Data Integrator consultant needed for a Financial services company.

Job Description:

• Job entails the use of Data Integrator XI to extract, transform and load data marts.
• 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.
• Perform simple and complex transformations in Data Flows.
• Design and develop Data Integrator scripts for data transformation. The job will entail cleansing data in DI using proper data types and mappings.
• Create Workflows using object library and tool palette to execute data flows.
• Create, test and execute Data Integrator jobs using Data Integrator Designer to transfer data from source to target.
• Debug execution errors using Data Integrator logs (trace, statistics, and error) and by examining the target data.
• Implement Change Data Capture (CDC).

Eliassen Group, a national technology consulting and staffing solutions company, introduces companies to high quality and committed professionals for project, supplemental and permanent opportunities. An award-winning firm, Eliassen invests in its people through relationship-building strategies that result in long-term associations and goodwill among candidates and clients.

At Eliassen, our skilled consultants maximize our clients' technological potential.

Eliassen is the leading source of opportunities for today's in-demand specialists. Please visit our website for detailed position descriptions.

For our clients, we provide unparalleled technology project and staffing solutions. For our consultants, we provide challenge and great opportunities to develop your expertise. For our internal staff of technical recruiters and account executives, we provide an environment that has been recognized as a "Best Place to Work" by Boston Business Journal for 5 consecutive years.

Headquartered in Wakefield, Massachusetts, Eliassen has regional offices in Mansfield, MA, New London, CT, Charlotte, NC and the New York Metro area.

If you have a relationship with an Eliassen recruiter, please contact him/her directly.

THIRD-PARTY SUB-CONTRACTING AGENCIES NEED NOT APPLY! Proof of eligibility to work in US required.Global Variables

Requirements

Qualifications:

• 3+ years experience.
• Expert skills in Data integrator XI (ETL) in design, creation, and implementation of Data Integrator scripts, work flows, and data flows
• SQL
• System Configuration Set Ups
• Excellent Oral and Written Communication skills.
• Ability to interact with End Users and Business Analysis.
• Experienced with all phases of the Software Development Life Cycle (SDLC).
• Experience in developing, maintaining, and documenting data standards, guidelines and procedures.
• 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 2000.
• Familiar with Windows environment.
• Strong knowledge of SQL, PL/SQL, Stored procedures and query tuning.
• Two or more years of Data Integrator XI experience Administration (plus).