View Bench List Portal

Similar candidates

• No Matching Candidates Found

• Over 7 years of experience in Analysis, Development and Maintenance of Business Intelligence solutions using Informatica Power Center 9.x/8.x/7.x, IDQ, MDM

• Worked on various domains including Insurance, Finance, Banking, Pharmaceutical and Retail.

• Extensive knowledge on the SDLC development life cycle. Involved in different phases starting from Requirement Gathering to Production Deployments

• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

• Involved in Informatica Administration, grid management, creation and up gradation of repository contents, creation of folders and users and their permissions.

• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer

• Developed various mappings using different transformations like Source Qualifier, Expression, Filter, Joiner, Router, Union, Unconnected / Connected Lookups and Aggregator.

• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2) loads
  
  
  • Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow and  Worklet Designer.
  
  
  • Good understandingof relational database management systems like Oracle, Teradata, DB2, SQL Server and worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems
  
  
  • Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
  
  
  

• Good Understanding of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake and Operational Data store (ODS)
  
  
  • Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
  
  
  • Worked with Oracle, PL/SQL Stored Procedures, Functions Cursors, Indexes and Triggers and involved in Query Optimization.
  
  
  • Setup the data mart on Oracle database by running the SQL scripts from ERWIN designer.
  
  
  • Extensively worked on Informatica IDQ for data profiling, data enrichment and standardization.
  
  
  • Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
  
  
  • Usage of Informatica mapping variables/parameters and session variables strong in UNIX Shell scripting and Perl Scripting. Scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab and Autosys.
  
  
  • Extensively involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of daily loading into the Warehouse
  
  
  • Interacted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements