Law

Title: ETL / Informatica Developer

Location: Ridgefield, CT

Duration: 6+months

Face to face required after telephonic

Responsibilities:

Develop Informatica mappings and workflows to load move data from databases and files into a data warehouse.

Develop Informatica ETL processes according to best industry standard practices.

Conduct analysis and critique design of database tables using PL-SQL queries.Responsible for delivery of assigned module/ components /phases of a project.

The project will require developers to deliver: Data flow architecture diagrams, ETL Specifications, ETL Mappings, Unit Test Cases & Results, System Test Cases & Results, Deployment packages, KT Docs, Run book Create low-level design documents and testing scripts.

 Conduct unit testing and peer review of other team members.Responsible for Status reporting & for Knowledge transfer and arriving at SLAs for steady state.

Provide assistance in completing other small enhancements and service requests as needed.

Technical skills:

5+ years of Data Integration/ETL development experience using Informatica.

Excellent understanding of Data Warehousing approaches and architectures.

Must have experience with all aspects of Informatica PowerCenter. Experience with additional Informatica tools such as Data Exchange, Data Transformation, MDM, IDQ and IDE preferred.

Must know core best practices for Informatica PowerCenter.

Candidate must have good knowledge of Unix/Linux shell scripts. Must have good knowledge of Oracle (Including 10g & above).

Must be capable of optimizing/performance tuning Informatica mappings and database queries on the Oracle database platforms.

Excellent analytical skills; must be capable of systematically debugging code that was written by someone else, and performing root cause analysis on large, complex systems.

Strong initiative, ability to self-manage and also work in a team environment

Regards-

Rimmi kaur

Amtex Systems Inc.

Direct Dial: 646 202 9552,

rimmi@amtexsystems.com