Wrote stored procedures and UNIX scripts as a part of ETL Process. Worked on existing mapping for the performance tuning to reduce the total ETL process time. Worked extensively with slowly changing dimensions (SCD Type 1,2).Įxtensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
Worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator. Having hands-on experience in creating Informatica Mappings, Sessions and Workflows. Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange, Power Connect as ETL tool on Oracle, Netezza Databases. Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center. Proficient in loading data from flat files into database tables using SQL*Loader scripts. Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables. Well experienced in writing complex views for the reporting team. Worked on Dynamic SQL and Exception Handling.
Used Explain Plan, HINTS for performance tuning of SQL, PL/SQL queries. Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views, Analytical and Database collections.Ĭreated Cursors and Ref Cursors in the PL/SQL Blocks.įunctions and Query Re-write in Oracle 11g/10g /9i database.
Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema)Įxperience in working with relational databases such as Oracle and Netezza. Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor. Email: years of extensive experience in IT as a PL/SQL, Oracle Developer with expertise in Design, Development, Testing, Technical Documentation and Support.