SUMMARY

• Over 7 years of experience in Information Technology including Data Warehousing using Informatica Power Center versions 9.x, 8.x and 7.x.
• Extensive experience in all the phases of Data Warehouse life cycle which involves Requirement Analysis, Design, Coding, Testing, and Deployment.
• Got extensive experience in Data Extraction, Transformation and Loading by using ETL tool.
• Hands on experience in SQL and worked on stored Procedures, Functions, Packages and Triggers.
• Extensive experience in Informatica Power Center to implement Data Marts which involve creating, debugging and executing mappings, sessions, tasks, and workflows.
• Expertise in extraction, transformation and loading of data directly from different heterogeneous source systems like SQL Server, Oracle, Flat files (Fixed width & Delimited), XML files.
• Involved in the Software Development Lifecycle (SDLC) from requirements gathering through development and support for Financial institution using Informatica Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Extensive working knowledge on Teradata and its utilities like TPT, multiload, fastload and BTEQ.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2 and type 3.
• Hands on knowledge on Teradata Database concepts.
• Good exposure to Data Modeling (Dimensional and Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good Knowledge on UNIX shell scripting.
• Skilled in Performance Tuning, Error Handling and Production Support.
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels and quick adaptability to new technologies.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x/7.x/6.x-Power Center

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, OLAP, OLTP.

Databases: Oracle 8i, 9i, 10g, 11g, MS Access, MS SQL Server 2012/2008/2005 , DB2, Teradata V2R12/V2R6/V2R5.

Operating Systems: UNIX, Windows 7/8/XP

Programming: SQL, PL/SQL, HTM, C, C++, Java, UNIX Shell Scripting

Database Tools: TOAD, SQL*PLUS, ERWIN, MS VISIO, BTEQ, MLOAD, FLAOD, TPUMP

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Sr. Informatica Developer

Responsibilities:

• Involved in design and development of business requirements and prepared requirement specification document with the help of Business Analysts.
• Participated actively in user meetings and collected requirements from users.
• Designed Informatica ETL jobs for extracting data from various heterogeneous sources, transforming it and finally loading it into the data warehouse.
• Designed Mappings, Sessions and Workflows using Informatica Power Center Tool to load the data from Sources such as Oracle, Flat files, XML files into Teradata by using various Teradata load utilities like BTEQ, MLOAD, FLAOD and TPUMP to various targets.
• Implemented SCD type 1 and 2.
• Responsible for defining, developing and testing programs necessary to extract data from clients operational databases, transform, cleanse data and load into data marts.
• Performed QA testing and worked on resolving the defects.
• Migrated Informatica code from Development to QA environment.
• Enhanced the Informatica Code (Mappings & Workflows) to improve the performance.
• Provided support for sustained projects in production environment in case of any errors or glitches.
• Created Unix Shell Scripts to run Workflows.
• Developed optimized SQL queries and PL/SQL procedures, functions to implement business logic.
• Provided support to Business Objects team to pull data from database after loading of data by using Informatica.
• Participated in daily status update meetings with the team.

Environment: Informatica Power Center 9.5.1/9.0.1 , Teradata, Oracle 11g, DB2, SQL, PL/SQL, UNIX, TOAD, SQL Server 2012.

Confidential, Mclean, VA

Informatica Developer

Responsibilities:

• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Involved in brain storming discussions to find the best approach for data migration.
• Responsible for development, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Created various Data Marts from data warehouse and generated reports using Business Objects.
• Participated in the Design Team and user requirement gathering meetings.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Written simple and complex SQL-overrides in source qualifier as well as in look-up transformations according to the Business Requirements.
• Worked on Star Schema approach throughout the project.
• Developed ETL code with the similar logic for re-usability.
• Created Data Marts for both kinds of applications, CRM and financial and used effective querying and formatting tools to present data to the end users.
• Created Stored Procedures, Packages, Triggers, Tables, Views in Oracle.
• Extracted source data from Oracle, Flat files, XML files using Informatica and loaded into target Database.
• Developed mappings to implement SCD Type-1, Type 2, Type 3 to load data from various sources.
• Monitor production jobs and if there is any issue then investigated the root cause of the issue and resolved it within service request deadline.
• Generated weekly and monthly reports for client.
• Coordinated team efforts like handing over, tracking the timelines and reviewing the code and performing testing sessions and met the business requirements and client standards.

Environment: Informatica Power Center 9.1/9.5, Oracle 11g/10g, MS SQL Server 2008/2012, UNIX, XML, Flat Files

Confidential, Fountain Valley, CA

Informatica Developer

Responsibilities:

• Analyzed the source data coming from Oracle, Flat Files and contributed my skills to develop dimensional data model.
• Imported various Sources, Targets using Informatica Power Center.
• Optimized Informatica Mappings for better performance.
• Developed various Sessions, Mappings for data loading from Sources (text files, SQL server tables) to Target tables.
• Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.
• Created Facts and Dimension Tables.
• Scheduled sessions on Informatica Server using Informatica Workflow Manager and used Autosys.
• Developed and optimized SQL queries and PL/SQL scripts to implement business logic.

Environment: Informatica Power Center 8.6/9.1, Oracle 10g, SQL developer, Flatfiles, TOAD, PL/SQL, MS SQL Server 2008, UNIX, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Interacted with the Business Personnel to analyze the business requirements and transform the business requirements into the technical requirements.
• Developed standard and re-usable mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup- connected/unconnected and filter.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations for better performance.
• Worked extensively to build and run Workflows with Informatica Workflow Manager and monitored the statistics using Informatica Workflow Monitor.
• Prepared and used test data/cases to verify accuracy and completeness of ETL process.
• Assisted in production support and also transferred knowledge to the other team members.

Environment: Informatica 8.6, Oracle 9i, DB2, SQL, PL/SQL, UNIX, TOAD, Flat Files.

Confidential

Jr. Informatica Developer

Responsibilities:

• Developed mappings using transformations like Filter, Joiner, Expression, Aggregator, Router and Lookup transformations.
• Written and executed UNIX shell scripts to run the Work Flows.
• Created complex SQL queries, Stored Procedures, Functions, Database Triggers and Views for the purpose of data analysis.
• Created technical specification document after ETL code was developed.

Environment: Informatica Power Center 8.1.2, Oracle 9i, DB2, SQL, PL/SQL, UNIX.