ETL Informatica Developer

ETL Informatica Developer

Location: Detroit, MI

Duration: 15 months

Description:

Dept. HMO Support, WCM, Provi

Engagement Description:

- Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications and Performs source system analysis as required

- Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter and prepare corresponding documentation.

- Design and develop database objects like Tables, Procedures, Functions, Indexes and Views using SQL Server, Oracle

- Build, maintain, and enhance all objects packages/functions in PL/SQL to support application process

- Provide Support for QA Testing

- Assist and resolve production issues

- Tune and optimize ETL batch jobs for performance and throughput

Top 3 Required Skills/Experience:

- 5+ years of working experiences with ETL Informatica PowerCenter Tool

- 5+ years of experience in writing and executing PL/SQL programming

- 5+ years of experience with Unix Shell Scripting

Required Skills/Experience - 5 Plus years:

- Understanding of dimensional data models (STAR Schema)

- Design, Code, and Test Informatica ETLs

- Coding SQL Stored Procedures and Triggers in SQL Server/Oracle

- Ability to performance tune SQL code and Informatica components

- Ability to conform with established coding standards

- UNIX Shell Scripting

- SDLC Methodology

- Written and verbal communication

Preferred Skills/Experience:

- Java

- .NET

- Knowledge of Agile Process

- CareAdvance Application

- TWS scheduling

Education/Certifications:

- Bachelor's degree required - Computer Science or Equivalent