SUMMARY

• Good understanding of Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inman Snow Flake schema methodology.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Suite 9.x - Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Management, Informatica Data Quality, Master Data Management).
• Strong understanding of OLAP and OLTP Concepts
• Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like oracle 11g/10g, SQL Server 2008/2005, DB2, Flat files, XML, SAP R/3 etc.
• Experience in SQL, PL/SQL and UNIX shell scripting.
• Worked with Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes/Agile.
• Used 3rd generation programming languages like C++ & Java.
• Used Informatica Metadata Manager and Metadata Exchange exhaustively to maintain and document metadata.
• Strong experience on understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and SDLC (Software Development Lifecycle), Quality analysis.
• Dealt with Master data (MDM), Transaction data, Control data etc.
• Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes with Query optimizations as part of ETL Development process.
• Adept in UNIX operating system commands & Shell Scripting.
• Experienced in Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.
• Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development.
• Strong decision-making and interpersonal skills with result oriented dedication towards goals.
• I am an Enterprise Data Warehouse Architect and Programmer with extensive experience working for world-class IT departments fluent in all aspects of data architecture, modeling and programming, with a focus on data management and database programming.
• For the last 8+ years, Data Warehouse Design, ETL Programming and Business Intelligence have been my focus. I have experience with all the major RDBMS. I have excellent communications skills and work well with end users and management

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x,PowerExchange IDQ, MDM, IDS, MM

Data Modeling: Dimensional Data Modeling, Star/Snow-Flake Modeling, Physical/Logical Data Modeling, Erwin

Testing Tools: Quick Test Professional 11/10.0, HP Quality Center 11.x, Load Runner, Rational Performance, J meter

Programming: Visual Basic, VB script, VBA, SQL, PL/SQL, Java Script,C, C++,HTML, and XML

RDBMS: ORACLE 11g/10g/9i/8i/8/7x, MS SQL Server 2000/05/08 & MS-Access 2010

Operating Systems: Unix, Linux, Windows NT/2000/2003 Server/95/XP/7/8.

Architecture: Client server, web based application

Software and Tools: Toad 9.7.2 for Oracle

PROFESSIONAL EXPERIENCE

Confidential

INFORMATICA SME

Responsibilities:

• Worked with Informatica Suite 9.6.0 - PowerCenter 9.x tools like Designer, Workflow Manager, Workflow Monitor Informatica Data Services and Repository Manager.
• Used Informatica data services to profile and document the structure and quality of all data.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Involved in Installs, Upgrade and applying Hotfixes/Patches to existing Informatica Products.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema on Oracle 9i Instance.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Developed ETL mappings, transformations using Informatica Power center 8.6
• Deployed the Informatica code and worked on code merge between two difference development teams.
• Extensively used PL/ SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Created Informatica complex mappings with PL/SQL procedures/functions to build business rules to load data.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Created automated scripts to perform data cleansing and data loading.
• Performed complex defect fixes in various environments like UAT, SIT to ensure the proper delivery of the developed jobs into the production environment.
• Attended daily status call with internal team and weekly calls with client and updated the status report.

Environment: Sun Solaris, Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), MDM, IDQ, MM, IDS, SQL Server, Oracle 11g, Toad, UNIX Shell Scripting, Flat Files, SQL Developer, and Windows XP Professional.