SUMMARY

• Over SEVEN years extensive experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Power Center 9, 8.6.1/ 7.x.
• 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 Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger). Strong understanding of OLAP and OLTP Concepts.
• Experienced in designing ETL procedures and strategies to extract data from heterogeneous source systems like Oracle 11g/10g, SQL Server 2012/2008R2/2005, DB2 10, 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.
• Used Informatica Metadata Manager and Metadata Exchange exhaustively to maintain and document metadata. Analyze complex queries tuning, statistics, and performance of CPU, IO, and memory.
• Evaluate and recommend new database software, utilities, and tools and set the strategy for implementing new technologies.
• Strong experience in understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and SDLC (Software Development Lifecycle), Quality analysis.
• 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. Experience in Informatica Master Data Management (MDM), IDE, IDQ.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9, 8.x/7.x, DVO, SFDC, IDE, IDQ, MDM, DAC

Reporting Tools: Informatica Data Analyzer, Web Focus, Cognos

Operating Systems: UNIX, Windows 98/ NT/2000/XP, Solaris

Database: Oracle 11g/10g/9i, SQL Server, DB2, Oracle EBS 11i/12

Database GUI Tools: TOAD, SVN, Agile, Jira

Web Development: HTML, XML

Programming Languages: Oracle SQL, PL/SQL, UNIX Shell Script, Perl Scripts

Job Scheduling Tools: Autosys, Control M, Tidal

PROFESSIONAL EXPERIENCE

Confidential, Grapevine, TX

Informatica MDM Lead

Responsibilities:

• Used Informatica data services to profile and document the structure and quality of all data. Worked on power center tools including Designer/Repository, Workflow Manager/Monitor. Worked Informatica support to troubleshoot any critical issue.
• 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.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica. 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 9.5.1. Extensive Knowledge in Hadoop and Big data. 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. Tested mapping and debug transformation error and find the root cause.
• Created Informatica complex mappings with PL/SQL procedures / function to build business rules to load data in Oracle 11g and 12i. Experience in using Data Warehouse Administration Console (DAC 10.1.3.4) for scheduling and executing Incremental ETL loads.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems. Performed complex defect fixes in various environments and scheduled it to job scheduler (Tidal). Data validation between two different environments using tool DVO.
• Worked on custom and standard model in Informatica MM (Meta Data Management). Attended daily status call with internal team and weekly calls with client and updated the status report. Created rule set in Informatica MDM to get the golden sent of record.

Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager, DVO, IDQ, IDE, Workflow Monitor), SQL Server, Oracle 10g, TOAD, UNIX Shell Scripting, Flat Files, SQL Developer, SAP, Tidal, Informatica MDM, DAC, OBIEE 10.1.3.4/10.1.3.3

Confidential, San Antonio, TX

ETL Developer /Informatica Developer

Responsibilities:

• Used Informatica data services to profile and document the structure and quality of all data. Worked on power center tools including Designer/Repository, Workflow Manager/Monitor. Worked Informatica support to troubleshoot any critical issue.
• 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.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica. 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 9.5.1. Experience in Administering DAC 10.1.3.4 and Informatica 9.0.1. 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. Tested mapping and debug transformation error and find the root cause.
• Worked on Informatica Application Life Cycle Management (ILM) for cost effective handling data growth. Performed complex defect fixes in various environments and scheduled it to job scheduler (Tidal). Worked on Informatica IDE and IDQ.

Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager, DVO, IDQ, IDE, Workflow Monitor), SQL Server, Oracle 10g, TOAD, UNIX Shell Scripting, Flat Files, SQL Developer, SAP, SAP ABAP, Tidal, DAC, SOAP

Confidential, NJ

Informatica/ ETL Developer

Responsibilities:

• Worked with Power center tools like Designer, Workflow Manager, Workflow Monitor, 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.
• 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. Worked on Creation of report using Oracle Business Intelligence. Developed ETL mappings, transformations using Informatica Power center 8.6.
• Strong experience with Oracle EBS R12. 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.
• Worked on EDI X12 and XML and understand how to create complex XML templates in Informatica. Created automated scripts to perform data cleansing and data loading.
• Performed complex defect fixes in various environments like UAT, SIT etc. 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: Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, IDE, IDQ), SQL Server, Oracle 10g, TOAD, UNIX Shell Scripting, Flat Files, SQL Developer, Oracle EBS 11i

Confidential, MN

ETL/Informatica Developer

Responsibilities:

• Extensively used Informatica 8.6 to extract, transform and load data from multiple data sources. Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Monitoring and tracking the applications as per the schedule run. Handling the user queries and tickets for Informatica applications. Mainly involved in ETL design & development. Mainly involved in Preparation of Low level Designs by understanding the system CPMS.
• Encapsulated PL/SQL procedures and functions in packages to organize application. Responsible in developing the ETL logics and the data maps for loading the tables. Responsible for migrating from Development to staging and to Production (deployments).
• Designed for populating Tables for one time load and Incremental loads. Reloading of applications run and need to make sure reloading process is completed. Analyze functional requirements provided by Business Analysts for the code changes.
• Create workflows based on Dependencies in Informatica for the code changes. Provided extensive support in UAT (user acceptance testing) and deployment of mappings.

Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Teradata, UDB, UNIX, Oracle 10g, Mainframes (DB2, VSAM Files, Sequential Files)

Confidential

ETL/Database Developer

Responsibilities:

• Performed design of ETL components in this project. Creation of Design documents, Development and testing were primary responsibilities. Created the warehouse tables using Informatica Power Mart Warehouse designer.
• Designed the source to target mappings that contain the business rules for the server during the extract, transform and load process using Informatica ETL Tool.
• Created and maintained documents including data quality plan design, mapping inventory, mapping specifications, change request form, unit test plan, test case list, target-source matrix etc.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Tasks, Workflows and the Target Data. Making Enhancement and fixes in the Procedures, Packages, Triggers.
• Creation of Bitmap indexes & Partitioned indexes for partitioned tables to maximize performance. Proficient in physical/logical design, SQL, PL/SQL, Stored Procedures, Functions, Cursors and Trigger.

Environment: Informatica Power Center, Oracle, MS SQL Server2003, PL/SQL, Windows NT, Oracle 9i