Previous Job
Sr. ETL Developer/Auburn Hills, MI 7 mth+ contract (NTTJP00002312)
Ref No.: 18-00655
Location: Auburn Hills, Michigan
Position Type:Contract
  Sr. ETL Developer/Auburn Hills, MI  7 mth+ contract  (NTTJP00002312)
Visa: US Citizen or GC or GC EAD or TN Only
Job Level Specific Duties 
• Develops design specifications within defined architecture, utilizing standard procedures and techniques 
• Create or update design and systems documentation for developed or modified services or programs 
• Create process and data flow diagrams for data movement capture 
• Cross train team members for full knowledge coverage on team 
• Analyze and translate business requirements to technical design 
• Collaborate/communicate with project team and business users as required 
• Support functional testing and performance testing 
• Works with technical delivery lead on project activities 
• Ensure assigned work is implemented within project schedules 
• Analyze, design, develop, implement and support ETL solutions using Informatica. 
• Set up complex workflows and schedules 
• Develop ETL data workflows and code for data migration between source and target system 
• Maintain/enhance existing workflows and code 
• Troubleshoots application problems independently. 
• Ability to quickly process information, correlate, disseminate, and make appropriate risk based decisions 
• Has to support the implementations and post deployment support 
• Must possess deep knowledge of data extraction, complex transformations & loading (ETL) methods 
• Review deliverables for accuracy and quality 
• Convert business rules into transformation logic 
• Analyze source data systems to identify cleansing opportunities 
• Implement data cleansing procedures. 
• Map objects and attributes between source and target databases 
• Develop and automate data reconciliation between systems 
• Convert Mappings into ETL workflows. 
• Establish connections to PostgreSQL within the ETL process 
• Accommodate changes to target database system 
• Efficiently turn around defects over the course of SIT and UAT. 

Key Technical Skills 
• Minimum of 7+ years overall IT experience: including 3+ years of Informatica Big Data development experience 
• This role will be doing enhancements to existing Informatica Big Data applications and mappings that move data between files, Oracle databases and within the Cloudera data lake environment within Client System. 
• Automotive OEM environment and concepts experience 
• Experienced in waterfall, iterative, and agile methodologies 
• Oracle/SQL experience 
• Strong experience working in a Cloudera/Hadoop environment using Informatica (including Hive and Blaze engines) 
• Experience with Informatica Power Center workflow, mapping and session development 
• Strong experience with Informatica Big Data Edition development experience 
• Skilled in Microsoft Office applications (Visio, Word, Excel, Access) 
• Experience in both Unix and Windows platforms 
• Must have working knowledge of Perl - scripts are used for job control and process flow 

Typical Years of Experience 
Typically requires 7-8 years.