Rate: $50hr Max.
Bridgeport, CT
Long Term Contract.
Phone and Inperson will be required.
Data integrator XI (ETL) Consultant Qualifications
- General Qualifications.
- Strong Leadership qualities and a self starter.
- Excellent Oral and Written Communication skills
- Strong Technical, Analytical, and Organizational Skills.
- Ability to work independently on projects.
- Team Player with excellent inter-personal skills.
- Ability to work under pressure and meet challenging deadlines.
- Ability to interact with End Users and Business Analysis
- Experienced with all phases of the Software Development Life Cycle (SDLC).
- Ability to Estimate Work Effort.
- Experience in developing, maintaining, and documenting data standards, guidelines and procedures.
- 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 environment.
- 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.
- 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.
No comments:
Post a Comment