SUMMARY:

• Having 7+ years of professional experience in IT industry and wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation including but not limited to Databases, Reporting, Data Warehouse and ETL Design Applications. Experience in the field of Data warehouse using ETL tools such as Informatica Power Center 10.1/9.x/8x/7x, PowerMart 9x/8x databases as DB2, Oracle, MS SQL Server and Teradata.
• Extensive experience in the implementation of Extraction, Transformation & Loading (ETL) using Informatica Power Center, Teradata Studio 15.1 , Oracle 11g/10g/9i, MS SQL Server 2008, SSRS and SSAS.
• Strong knowledge in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema, Fact and Dimensional tables.
• Worked data mapping, data cleansing, program development for loads, and data verification of converted data to legacy data.
• Worked on ETL Informatica transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Rank, Aggregator, and Stored Procedures, Sorter and Sequence Generator and created complex mappings.
• Experience in documenting High Level and Low level Design , Source to Target Mapping ( STM ), Macro and Micro Documents , Unit test plan, Unit test cases and Code Migration Report.
• Experienced in UNIX work environment, file transfers , job scheduling and error handling .
• Knowledge in Oracle, BTEQ, SQL, PL/SQL, MS Access, MS Excel on UNIX and Windows platforms.
• Experience in populating the data warehouse tables using SQL*Loader, MULTILOAD, FASTLOAD, Oracle Packages, Stored procedures, Stored functions.
• Knowledge in Data Analyzer tools like Informatica Power Exchange to capture the changed data.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Extensive experience in Informatica Data Integration Tools - Such as Repository Manager, Designer, Workflow Manager, Workflow Monitor and Scheduled workflows using Workflow Manager.
• Knowledge of complete Software Development Life Cycle (SDLC) including Requirement Analysis, Requirement Gathering, Design, Development, Implementation and Testing.
• Experience in Agile Scrum methodologies and played role as Scrum Team Member following the sprint/standup meetings, and analyzed the Iteration Burn Down charts.
• Ability to meet deadlines, coordinating multiple tasks in project, excellent communication, interpersonal and analytical skills with ability to interact with individuals at all levels and work as a part of a team as well as independently.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/ 9.6/9.5/8.6 /7.1, Powermart, Informatica Power Analyzer.

Databases: Oracle 11g/10g/9i, SQL, DB2, Teradata, MS Access, MS Excel, VBA, SQLServer 2008/07, Informix.

DB Tools: SQL Plus, TOAD, Oracle SQL Developer and Teradata Studio 15.1 & TD SQL Assistant, Data Mart.

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, and Snow-Flake Modeling, Erwin.

Production Support and Reporting Tools: Infa Power Center, AutoSys, Tidal , SSRS, SSAS, SAP BO

Languages: SQL, PL/SQL, HTML, CSS, JavaScript, JQuery, XML, Unix Shell ScriptingOperating Systems

MS Windows 2008: /XP/VISTA 08/07, Solaris, Linux, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Rancho Cordova, CA

ETL/Informatica developer

Responsibilities:

• Analyzed business requirements, involved in designing the specifications, documents, data modeling and designing data warehouse.
• Worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Extensively used Informatica Power Center 9.6 & 10.1 for Extraction, Transformation and Loading data from relational tables and flat files.
• Involved in the data analysis for source and target systems. Good understanding of Data warehousing concepts, Star schema and Snow-flake schema.
• Use Agile Methodology for SDLC and utilize scrum meetings for creative and productive work.
• Extensively worked in various transformations like Lookup, Joiner, Filter, Sequence, Stored procedures, Sorter, Aggregator, Router, Rank and Source Qualifier to create complex mapping .
• Created the repository manager, users, user groups and their access profiles.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Developed ETL’s for Data Extraction, Data Mapping and data Conversion using SQL, PL/SQL and various ETL scripts.
• Developed and design of ETL processes using Informatica ETL tool to load data from Source System XML and load into target system (SQL server).
• Extracted the data from Oracle, DB2, CSV, Teradata Studio and Flat files .
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created UNIX scripts to deal with flat file data like merging delta files with whole files and to concatenate header, detailed and trailer parts of the files.
• Involved in writing SQL scripts, stored procedures and functions and debugging.
• Mappings, Sessions, Workflows from Development to Unit Test to UAT environment then to Production environment.
• Provided Tier l support duties for Informatica Production Support, including off hours and weekends. Keep the Production Support team management informed of any issues or concerns. New development and support task responsibilities.

Environment: Informatica Power Center 9.6/10, Power Mart, Oracle 11g, Teradata Studio 15.1, MS-SQL Server, OBIEE, SAPBO, SSRS, PL/SQL, SQL, XML, BTEQ Scripting, Erwin, Windows 7/10.

Confidential, San Gabriel, CA

ETL/Informatica developer:

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
• 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.
• 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.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Extensively worked on migrations and Conversions with legacy systems data in SQR Production Reporting.
• Demonstrated expertise utilizing ETL tools, including Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Extensively performed Data Masking for preserving the referential integrity of the user data.
• Performed Data Encryption on user data and client data for maintaining consistency and security.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Developed ETL’s for Data Extraction, Data Mapping and data Conversion using SQL, PL/SQL and various ETL scripts.
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution
• Interacted with Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and peer developers to analyze system requirements, design and develop software applications. Technical solutions and supporting deliverables will be constructed to enable Well Care clients to accomplish their business objectives.
• Created new extracts for external vendors and use Informatica ETLs for new workflows to move data out of multiple data sources.
• Unit test coding changes, fill out required documentation such as installation instructions, and follow standards and procedures.

Environment: Informatica Power Center 9.6, Oracle 11g, SQR, OBIEE, ETL, Teradata SQL Assistant and Administrator, XML, UNIX Shell Scripting.

Confidential, Dayton, OH

ETL/Informatica Developer

Responsibilities:

• Designed and Developed mappings using different transformations like Source Qualifier, Expression, Lookup (Connected & Unconnected), Aggregator, Router, Rank, Filter and Sequence Generator.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• 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.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Extensively used PL/SQL programming procedures, packages to implement business rules.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Workflow Manager.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for ETL.
• Extensively used ETL to load data from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Extensively dealt with the performance issues and made necessary coding changes for improving the system Performance.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Used different Cache properties, such as dynamic cache session property to perform the Update and Insert into the relational table simultaneously using Lookup transformation.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions
• Created and used reusable Mapplets and transformations.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Design and Developed pre-session, post-session routines and batch execution routines.

Environment: Informatica Power Center 9.5, Oracle 11g, SQL server 2005/2000, SQR, XML, Windows, UNIX and PL/SQL Developer.

Confidential, Washington, DC

Informatica Developer

Responsibilities:

• Extensively used Informatica to load data from Oracle9 and flat files into the target Oracle 10g database.
• Used various transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy and Stored Procedures.
• Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Created and scheduled workflows using Workflow Manager to load the data into the Target Database.
• Involved in performance tuning of Targets, Sources, and Mappings. Improved performance by identifying performance bottlenecks.
• Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail and timer for scheduling of the workflow.
• Involved in meetings to gather information and requirements from the clients.
• Involved in Designing the ETL process to extract, translate and load data from flat files to warehouse data base.
• Used Debugger to validate mappings and also to obtain troubleshooting information about data by inserting Breakpoints.
• Extensively used Variables, Break points, and Sorted inputs.
• Documented the number of source / target rows and analyzed the rejected rows and worked on re-loading the rejected rows.
• Created UNIX shell scripting and automation of scheduling processes.
• Wrote SQL Queries, PL/SQL Procedures, Functions, and Triggers for implementing business logic and for validating the data loaded into the target tables using query tool TOAD.

Environment: Informatica Power Center 9.0/9.1, ETL, PL/SQL Developer, Oracle 11g, UNIX, Microsoft SQL Server, TOAD.

Confidential, Phoenix, AZ

Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a STAR SCHEMA.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Involved in creating and maintaining various database objects like SQL Joins, synonyms and aggregate conditions and worked on various databases and their connectivity from various parts of the Source Systems.
• Involved in extracting the data from the Flat Files and other RDMS databases into staging area and pro-actively involved in Storage of data.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica PowerCenter Designer.
• Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Migrated Mappings, Sessions, Workflows from Development to Test and then to Production environment and development.
• Prepare DR plan and recovery process for GDW application.
• Create RTM, Document process and transfer knowledge.

Environment: Informatica Power Center 8.6/9.0, ETL, Oracle 11g, DB2, PL/SQL, TOAD, SQL* Plus, SQL*Loader, SQL Server 2000, Windows Server 2000.