Need: ETL/Data Integrators for Comerica Bank in Auburn Hills, MI
Steave Nickson
Please find the specs of the requirement below; kindly send suitable profiles to srik...@ksourceinc.com
Greetings..
Location: MI
Duration: 6+ Months
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.
---------------------------
Thanks & Regards