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