Job Title: Data Integrator (ETL Developer)
Location: Auburn Hills, MI
Long Term contract
Job Description (Scope of Work):
This role will required the candidate to have comfort wearing multiple hats and working in a cross-functional role.
Minimum 5+ years of software engineering experience, with a focus on integration Design and implement application integration using Informatica PowerCenter 9.x, 10.x. Strong experience in Informatica tools is required: Repository manager, Designer, Workflow manager, Workflow monitor. Ability to work with complex mappings using different transformations like Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator Demonstrated skill in Informatica PowerCenter ETL, and Informatica PowerExchange, preferably utilized with mainframe data (look for individuals who have worked at other financial institutions or automotive companies) Ability to put together ETL data maps, listing source, transformation rules, and target fields
Review and analyze functional requirements and mapping documents. Assist in deploying and migrating project artifacts within the production environment. Must have experience with developing ETL processes that integrate with Cloud systems (Salesforce and databases in AWS RDS as source and/or targets). Experience with integrating data from multiple data sources: Mainframe VSAM files, Oracle, DB2, SQL Server, spreadsheets. Hands-on experience in one or more programming or scripting languages, such as C++, C#, Java, JavaScript, Python, Perl.