Application Developer II

Location : Detroit, Michigan – MUST WORK ONSITE IN DETROITDuration : 1.4 yearsEngagement 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 requiredCreates 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, OracleBuild, maintain, and enhance all objects packages/functions in PL/SQL to support application processProvide Support for QA TestingAssist and resolve production issuesTune and optimize ETL batch jobs for performance and throughputResponsible for ‘On Call’ production system support, including off hours and weekend on a rotation basisTop 3 Required Skills/Experience:5+ years of working experiences with ETL Informatica PowerCenter Tool5+ years of experience in writing and executing PL/SQL programming5+ years of experience with Unix Shell ScriptingRequired Skills/Experience

– 5+ yearsUnderstanding of dimensional data models (STAR Schema)Design, Code, and Test Informatica ETLsCoding SQL Stored Procedures and Triggers in SQL Server/OracleAbility to performance tune SQL code and Informatica componentsAbility to conform with established coding standardsUNIX Shell ScriptingSDLC MethodologyWritten and verbal communicationPreferred Skills/Experience :Java.NETKnowledge of Agile ProcessCareAdvance ApplicationEducation/Certifications : Bachelor’s degree required – Computer Science or Equivalent

#J-18808-Ljbffr