Job Title:Informatica Developer
Job Location:Minneapolis, MN
Duration: 6+ months
Required Skills:
- 6+ years’ experience in Data Warehousing and ETL
- Deep understanding of Data warehousing concepts.
- 5+ years’ experience on Informatica PowerCenter 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 the 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.