Source description
About the role
Title : Informatica/ Oracle Developer Duration : 24 months contract Location: Minneapolis, MN Visa : GC , USC and GC EAD Must Have 6+ years’ experience of Data Warehousing and ETL Deep understanding of Data warehousing concepts. 5+ years’ experience on Informatica Power Center platform (specifically version 10.x), as well as process and workflow tuning and optimization. 3+ years’ experience in working with Oracle PL/SQL procedures Strong debugging, problem solving and investigative skills. Ability to assimilate disparate information (log files, error messages etc.) and pursue leads to find root cause problems. Expertise in using partitioning, transformations, incremental caching in Informatica toolset Expert understanding of slowly changing dimensions (SCD's) in Informatica. Expert understanding of join logic and query optimization in Informatica Experience with stored procedures, Triggers, PL/SQL in Oracle. Expert in writing efficient Analytic and windowing functions in Oracle. Extensive Business and/or technical background in the areas of Data modeling, EDW, Data Mart, Master Data Management, Metadata management, Data Quality, Data Governance, Data integration (ETL) and Data Security Carry out data modeling, including evolution from conceptual to physical models using a tool like ERWIN Define data profiling and analysis criteria and development of data quality metrics Proficiency in Linux and shell scripts, job scheduling. Nice to have Banking/ Wells Fargo/ Financial Services Experience
More at Thoughtwave Software and Solutions