PROFESSIONAL SUMMARY:

• Total 10 years of experience in Informatica Developer with strong background in ETL Data warehousing experience using Informatica PowerCenter 9.x/8.x/7.x/6.x.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLAP.
• Experience in designing Small to Mid - level Data Warehouse Systems involving Star Schema and Snowflake for Major RDBMS systems like Oracle
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS).
• Extensive experience in developing complex mappings from varied transformations like Source Qualifier, Connected and Unconnected lookups, Router, Filter, Sorter, Expression, Aggregator, Joiner, Union, Update Strategy, Sequence Generator etc.
• Experience in functional, system, regression, user acceptance (UAT), integration and stress/load testing.
• Experience working in agile environment and waterfall methodologies.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Worked with various SQL Editors such as SQL DEV, TOAD, SQL Plus, and Query Analyzer.
• Wrote Server-side Stored Procedures and Triggers, Optimizing Query Plan, Performance Tuning.
• Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter/PowerMart 9.6/9.5/9.1.0/8.6.1/8.1/8.0/ 7.1.3/6.2/6.1/ 6.0/5.1 (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations, Sessions, Workflows, etc.).

Tools: Toad, SQL Developer, PL/SQL Developer, JIRA (Project tasks’-status tracking tool), MATT (Specs generating tool), DAC

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, HTML, Unix Shell Scripting

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2012/2008R 2/2008/2005/2000, Teradata

Operating Systems: MS-DOS 6.22, Win 3.x/XP/95/98, Win NT 4.0, UNIX

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

ETL/Informatica Developer

• Worked on developing new Business Intelligence Warehouse (BIW) for Purchasing and payables module by extracting data from oracle11i, flat file and different ERP systems (AS400, SQL Server, Pervasive & Progress) data from various sources for Invoice, Payment and Receipt which was used for ZYCUS reporting.
• Developing ETL process for extracting data from operation, legacy and heterogeneous systems and loading into PADB Columnar Database on cloud for POS project to get multiple vendors(ACE, B&Q, LOWES) transactional data to load into EDW.
• Working knowledge with designing columnar databases PADB to support ETL and reporting.
• Involved in designing, developing, testing and maintaining ETL Informatica mappings and workflows. Extensive experience with Optimizing and performance tuning for better load throughput and Performance.
• Performed Unit Testing and tuned the Informatica mappings for better performance.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production and support for production environment.
• Worked closely with the Business User, Business Analyst in requirement gathering for quality deliverable.
• Extensively worked on DAC scheduler to Configure, Monitor and Schedule ETL jobs for Full and Incremental ETL loads.
• Worked with Cross-functional team member in Supporting QA testing for SIT, CIT, UAT and Production GO-LIVE.
• Used UNIX shell scripts to write wrapper scripts to call ETL Jobs, FTP and File-watcher Automation, PMCMD Automation etc.

Environment: Informatica Power Center 9.6, Oracle 11g, UNIX, Flat files, DAC.

Technical Lead

• Worked in the project of comparing data from HFM General Ledger consolidated metric with ODS Common Trans metric for Microstratagy reports.
• Developed Informatica processes to perform DQ check to process valid records to stage and invalid records to error table and also developed the process to identify New/Update records compared to previous run.
• Involved in all the phases of project like requirement gathering, Analysis, Design and Build.
• Developed Design, Mapping, Unit test and change hand over documents.
• Perform Unit test (Component and assembly test) and loaded the results to Quality center.
• Opened RFC’s to move code to higher environments.
• Provided support for SIT, UAT and deployment of mappings.

Environment: Informatica Power Center 9.0, Oracle 11g, UNIX, Flat files, Control M, Quality Center.

Informatica Data Migration Developer

• Work in the project of migrating and integrating data from multiple source systems into IBM InfoSphere Master Data Management (MDM) as part of five ETL developers team.
• Design and develop complex ETL processes in Informatica PowerCenter to support data staging from source systems prior to sending the data to MDM.
• Develop ETL mappings using advanced techniques such as Web Service Client transformation, XML transformation, Pushdown Optimization, etc.
• Perform performance tuning on Informatica mappings.
• Develop reusable processes in Oracle PL/SQL and initiate the processes from ETL.
• Perform unit testing and prepare test reports.
• Worked with DBA's to design and build the Staging/Target databases.
• Involved in change data capture ETL process.
• Followed Informatica recommendations, methodologies and best practices.
• Involved in the Defect analysis for SIT environment along with Testers to understand the root cause and to make any modifications required.

Environment: Informatica Power Center 9.5, Oracle 11g, SQL Server 2008, DB2/400, XML, Flat files.

Informatica Developer

• Extracted data from flat files, xml files and oracle database, applied business logic to load them in the SAP system.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 9.5/8.6.1.
• Used Informatica Power Center 9.5 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Prepared and Updated the Test case document for testing of the application from all aspects.
• Involved in test case design, test script development, test execution, analysis of defects and change requests.
• Performed sanity, smoke and regression testing and updated the test result document.
• Raise the incidents to track the issues that arise in production and UAT.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Monitors and tunes ETL repository and system for performance improvements.
• Creating Folders and manages user and user group access to objects based on LDAP settings.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Highly responsible for performance tuning, deliver the qualitative code and to meet the business requirements
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Involved in test case design, test script development, test execution, analysis of defects and change requests.
• Logged the defects in defect tracking tool and given mandatory information of a defect to developers in order to fix it.
• For implementing business rules and transformations. Created complex T-SQL queries and functions.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.

Environment: Informatica Power Center 9.5/8.6.1, Oracle 11g/9i, SQL, PL/SQL, XML, MS Access, UNIX, Shell Script.

Informatica Developer

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the Repository manager, users, user groups and their access profiles.
• Extracted data from different sources like Teradata, SQL server, flat files and loaded into DWH.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Used data miner to process raw data from flat files.
• Used the update strategy to effectively migrate data from source to target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
• Extracted data from OLTP to OLAP using SSIS using complex data transformations
• Developed and documented Mappings/Transformations, Audit procedures and Informatica sessions.
• Streamline business processes and reduce costs. Increase speed of response to customer requests and improve quality. Transform stressful workplaces into fun environments using Agile Methodologies.
• Performed regression testing on all functionalities.
• Involved in Sanity, Smoke and Functional testing.

Environment: Informatica PowerCenter 8.6.1/7.x (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, Teradata, Oracle 8i, SQL server 2005, SSIS, SQL, PL/SQL, Win 2000.

Data Migration Developer

• Actively participated in the design phase for data conversion architecture.
• Involved in Meetings/Discussions with the site teams on regular basis as part of the requirement gathering.
• Involved in the preparation of High level Design (HLD) and Low Level Design (LLD) specifications.
• Involved in designing and developing the Informatica mappings and work flows for Data Conversion mechanism.
• Accountable for developing the mappings/scripts using Designer to build the business rules for each data element and load the legacy data into APPS from the respective source systems.
• Worked on Perl scripts to process the feed files into database.
• Extensively used XML transformations in the mappings to work with XML sources and XML targets.
• Most of the transformations viz., joiner, expression, aggregator, XML transformations, lookup, filter, router, sequence generator, pre/post SQL etc. are used in development.
• Extensively worked with the Informatica components such as Designer, repository manager, work flow manager and work flow monitor as part of the development and code deployment processes.
• Responsible for creating/updating the solution design documents for all the data elements which are in the conversion process.
• Analyzing data/code issues and providing the solution to the reported site teams.
• Involved in execution of Test Cases and defect reporting
• Developing an application for Client-Server communication using Socket Programming.
• Involved in System and Integration testing.
• Logged defects in defect tracker.

Environment: Informatica 7.1, Oracle 8i, Unix Shell Scripting, XML, Teradata, MS Excel, Flat Files, Legacy Systems, APEX, PL/SQL, Red hat, Windows NT 4.0.

ETL Developer

Responsibilities:

• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto data warehouse
• Developed and documented data Mappings/Transformations and Informatica sessions.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Used the Informatica Designer, Source Analyzer, Warehouse Designer and Mapping Designer.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Implemented Type 1 and Type 2 slowly changing dimensions.
• Used the update strategy to effectively migrate data from source to target.
• Designed several mappings to extract the data from the Flat file sources and Relational Sources. Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Used Informatica as an ETL tool to extract data from Oracle manufacturing applications to Target system.
• Created and scheduled sessions and Batch process based on demand, run on time, run only once using Informatica server manager.
• Scheduled and monitored transformation processes using Informatica Server Manager.

Environment: Informatica Power Center 6.2, Oracle 6i, PL/SQL, SQL Developer, Erwin 4.5, Windows Server 2000.