Application Developer II

Location : Detroit, Michigan – MUST WORK ONSITE IN DETROIT

Duration : 1.4 years

Resource will be required to come onsite now or in the future?

Yes, vaccine is required

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

Responsible for ‘On Call’ production system support, including off hours and weekend on a rotation basis

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+ 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