Ref No.: 19-10364
Location: Cedar Rapids, Iowa
 Role: Bi Lead
Location: Cedar Rapids, IA
Duration: Long Term

 
 
Professional Summary
  • 10 Years of solid experience in End-to-End development using Informatica Power Center and building software applications.
  • Designed and developed Complex mappings from various Transformations like re-usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure's, Normalizer.
  • Involved in designing and implementing Data Mart / Data Warehouse applications using Informatica 9.x/10.x (Designer, Workflow manager, Workflow monitor and Repository Manager).
  • Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
  • Proficient in ETL (Extract – Transform – Load) using Informatica PowerCenter 9.x and 8x in Data Warehousing and OBIA 7.9.6.X / 7.9.5 Financials, Procurement, data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification
  • Designed and developed Complex mappings from various Transformations like re-usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure's, Normalizer.
  • Experience in using SQL, PL/SQL, Dynamic SQL, Stored procedures/functions, Triggers and Packages, Complex Joins, Correlated Sub-Queries, Aggregate functions, Analytic functions, Views, Materialized Views, Indexing, Partitioning and Performance tuning the same using explain plan.
  • Involved in designing and implementing Data Mart / Data Warehouse applications using Informatica 9.x/10.x (Designer, Workflow manager, Workflow monitor and Repository Manager).
  • Experience in Ralph Kimball Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables change or transformed of unstructured data to well-formed XML.
  • Experienced in configuring Power Exchange components (Listener, Agent, Logger, and ECCR) on Mainframe server.
  • Experience in data extraction from Mainframe server from DB2 database and VSAM files using Informatica Power Exchange.
  • Expertise in implementing dashboard/Reports using Repository Variables, Initialization Blocks, and Session Variables
  • Experience in Performance tuning of Informatica mappings and Data Warehouse loads and resolve any data inconsistencies across loads.
  • Designed and developed the Informatica Mappings with Registration groups as a source (Power Exchange Navigator) for implementing Change data capture.
  • Designed and developed SCD type 1 and SCD type 2 mappings as part of incremental load.
  • Created Mapping Parameters and variables as part of change data capture load.
  • Experience with high volume datasets from various sources like Oracle, Text Files, DB2 AS400, VSAM, and Mainframe Flat Files.
  • ETL experience in development of mappings and tuned existing mappings for better performance using Informatica Power Exchange, Informatica Power Center as per the business rules.
  • SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns. Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, bitmap indexes and partitions.
  • Solid experience conducting data analysis using SQL and Excel Reporting.
Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms and Ability to learn and adapt to new technologies