SUMMARY

• 9+ years of experience in Information Technology with a strong background in Data Warehousing, and ETL process using Informatica Power Center 9.x/ 8.x in Banking and Financial Services.
• Experience in using Informatica Power Center tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Expertise on Mapping Designer, Workflow Manager, Repository Manager and Workflow Monitor.
• Strong experience in Pentaho ETL (PDI), Data ware housing and Informatica Power Center 9.
• Proficient in the development of ETL (Extract, Transform, and Load) processes with a good understanding of source to target data mapping, ability to define and capture Meta data and Business rules.
• Extensive experience in implementing CDC using Informatica Power Exchange 8.x/9.x.
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
• Designed, tested, and deployed plans using Informatica Data Quality (IDQ).
• Experienced in overall Data Warehouse, Database, ETL and performance tuning.
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Database experience using Oracle 11g/10g/9i.
• Knowledge in Master Data Management.
• Experienced with Integration of data from heterogeneous sources such as Relational tables, flat files, MS Excel, and XML files.
• Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse using Informatica Power Center.
• Experienced in all data processing phases, from the Enterprise Model, Data Model (Logical and Physical Model), and Data Warehousing (ETL).
• Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers to implement business rules and validations.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Experience with System Development Life Cycle (SDLC).
• Extensive experience using database tool such as SQL *Plus, SQL * Loader.
• Experience in Data Modeling tool - Erwin and Data Warehousing Concepts.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

Data Warehouse/ETL: Informatica Power Center 8.x/9.x, Data Quality(IDQ).

Operating Systems: Windows, Unix

Databases: Oracle 12c/11g/10g/9i, Teradata

DB Utilities: TOAD, SQL Developer

Scripting Languages: Unix Shell Scripting

Other Tools: MSExcel, PowerPoint, Access, visio and outlook

PROFESSIONAL EXPERIENCE

Confidential, OH

Informatica Developer

Responsibilities:

• Involved in building the ETL architecture using Informatica 9.6.1/ 9.5.1 and Source to Target mapping to load data into Data warehouse.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
• Worked with the project teams to implement new functionality to support business needs.
• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Responsible for Impact Analysis, upstream/downstream impacts.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into the Target.
• Implemented technical data requirements for integrating partner data to be used for production support teams.
• Develop ETL jobs using a tool named Pentaho Kettle (PDI version 3.2). Also provide support and maintenance to the code developed.
• Utilized Informatica Data Quality (IDQ) for data profiling and matching/removing duplicate data, fixing the bad data, fixing NULL values.
• Pentaho ETL tool PDI Version 3.2.
• UNIX
• SQL, PLSQL
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.

Environment: Informatica 9.6.1/ 9.5.1 , Power Exchange 9.1, IDQ, Oracle 11g, Windows XP, SQL, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Consolidated Cleansed, Integrated, and ETL and customized the data.
• Responsible for Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Extensively involved in the Analysis, Design and Modeling.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Oracle, Flat files and loaded into target.
• Design the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ 8.6.1) are the tools are used here.
• DWS projects deals with Pentaho Reporting (version - 3 and 3.5).
• IDE is used for data profiling over metadata and IDQ 8.6.1 for data quality measurement.
• Proof of Concept performed in order to analyze the usage and improvise the current Pentaho BI server.
• Designed and developed data warehouse solutions, integrate new files and data's from other applications into Enterprise data warehouse, Utilize Teradata for reporting, OLAP & history.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• The end report consist the Pentaho BI server with enhanced UI customizations.
• Worked with Informatica IDQ (Data Analyst, Developer) with various data profiling techniques to cleanse, match/remove duplicate data.
• Monitored sessions that were scheduled, running, completed or failed.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections.
• Used Power exchange for mainframe sources.
• Optimized Query Performance, Session Performance and Reliability.
• Developed test plans for unit testing and integration testing.
• Developed data conversion, integration, loading and verification specifications.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Maintained the batch processes using Unix Shell Scripts.

Environment: Informatica Power Center 9.x, Informatica Power Exchange, Teradata, Oracle 10g, Windows XP, UNIX. Pentaho Reporting, Report Designer and Design Studio.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Project plan preparation for all the minor enhancements and small projects and obtaining approval from client.
• Team Management and Capacity planning for pipeline projects on resource requirement.
• Expertise in using data quality tool IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Extracted data from various sources like Oracle and flat files and loaded into the target Oracle database.
• Developed slowly changing dimension Type 2 mappings to maintain the history of the data.
• Developed several mappings in Informatica, a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables and Parameter files in Mapping Designer.
• Created reusable transformations and applets and used them in mappings.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Created Workflows with worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.

Environment: Informatica PowerCenter 8.x, Informatica Power Exchange 8.x, Oracle 10g/11g.

Confidential

Tech Lead

Responsibilities:

• Understanding the FSD.
• Providing KT on requirements to Offshore.
• Creating and maintaining Requirement Traceability Matrix.
• Involved in Mainframe and ETL Informatica/Database Testing.
• Extracted data from Oracle, Flat File and loaded them into DWH.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.
• Developed data Mappings between source systems and warehouse components.
• Created various Transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, and Router etc.
• To retrieve the data from various Tables and to test the database, wrote SQL Queries.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 8.x, Informatica Power Exchange 8.x Oracle 10g, Flat Files, SQLDeveloper.

Confidential

Deputy Manager

Responsibilities:

• Preparation of various analyses on AR & P/L portfolios for Cards, Insurance and Retail Assets using Oracle SQL queries and Informatica Power center.
• Preparation and presentation of Various Business trend Analysis reports.
• Providing Portfolio Performance Reports to Business Intelligence Unit which will be used in framing strategies for new business enhancements and opportunities.
• Development of SQL Scripts to prepare Strategy to identify the Delinquent Cards.
• Involved in creating Tables, Views, Constraints and Indexes.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Designing of MIS Reports as per the requirements of Management.
• Development of dashboards, reports and OBIEE repository.
• Used Informatica Workflow Manager to create workflows, Workflow Monitor was used to monitor and run workflows.

Environment: Informatica 8.x, Informatica Power Exchange 8.x, UNIX Scripts, Oracle, Flat files, Mainframes.