PROFESSIONAL SUMMARY:

• Having 8+ years of experience in Information Technology with emphasis on Data Warehouse/Data Mart development using developing strategies for extraction, transformation, and loading (ETL) in Informatica Power Center from various database sources.
• Strong work experience in Data Mart life cycle development, performed ETL procedure to load data from different sources like SQL Server, Oracle, Teradata, DB2, COBOL files & XML Files and flat files into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
• Experience in Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Highly motivated and goal - oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies
• Experience in Entity-Relationship concept, Facts and Dimensions tables and developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modelling.
• Comprehensive experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Extensive experience in developing Stored Procedures, Functions and Triggers, Complex SQL queries using SQL Server TSQL and Oracle PL/SQL.
• Created various profiles using Informatica Data Explorer (IDE) & IDQ, from existing sources and shared those profiles with business analysts for their analysis on defining business strategies in terms of activities such as assigning matching scores for different criteria etc.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Experience in various Informatica designer transformations like Source Qualifier, Dynamic and Static Lookups, connected and unconnected lookups, Expression, Filter, Router, Joiner, Normalizer and Update Strategy transformation.
• Extensively used Teradata Utilities like Tpump, Fast-Load, MultiLoad, BTEQ and Fast-Export.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in Task Automation using UNIX Scripts, Job scheduling and Communicating with Server using pmcmd.
• Extensively used Control-M for Job monitoring and scheduling.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, Informatica Power Exchange, Informatica Data Quality, and Informatica Power Connect

Oracle, MSSQL Server, MS: Access and Teradata, Sybase, IBM DB2

Tools: TOAD, MS VISUAL STUDIO, SQL *PLUS, Quick build, AUTOSYS, Control-M and TIVOLI.

Programming Languages: UNIX, Shell Scripts, SQL, PL/SQL, T-SQL, XML

PROFESSIONAL EXPERIENCE:

Confidential

ETL/Informatica Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis, and testing and project- coordination.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Profile source data using IDQ tool, understand source system data representation, formats & data gaps.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Work with Oracle Extract, Transform and load (ETL) methods and tools (Oracle Data Integrator ODI) to extract data from outside sources, transform it to Fit an organization’s business needs to load it into a target such as an organizations data warehouse or application database.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Extensively used SCD's (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Configured Informatica Power Exchange connection and navigator.
• Created Registration, Data Map, configured Real-Time mapping and workflows for real-time data processing using CDC option of Informatica Power Exchange.
• Worked with ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Used various sources like SAP R/3, Teradata, Oracle, SQL Server and Flat files.
• Created a SSIS Project using SQL Server Business Intelligence Development Studio.
• Importing & exporting database using SQL Server Integrations Services (SSIS) and Data Transformation Services (DTS Packages).
• Enhance PLSQL procedures for bulk loading from source systems such as Teradata, SAP.
• Wrote Script to load multiple tables and used MLOAD utility.
• Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Used PL/SQL to create Packages, Functions, and Procedure.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Writing Complex SQL Queries and PL/SQL Procedures to Extract Data from various source Tables of Data Warehouse
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Performing ETL & database code migrations across environments.
• Created and Configured OLAP Cubes using SSAS, Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Create Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables.
• Created automated reports using SSRS (SQL Server Reporting Services).
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Experience in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Environment: Informatica Power Center 10/9.5, Informatica Power Exchange 9.5, Toad, SSRS, UNIX Shell Scripting, Oracle Exadata, SQL Server, SSIS, SAP R/3, SAP BODS, Python, Teradata 14, Autosys, Linux.

Confidential, Chicago

ETL/Informatica Developer

Responsibilities:

• Extensively developed various mappings that incorporated business logic, which performed Extraction, Transformation and Loading of source data into OLAP schema.
• Extensively used transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner etc. Implemented Lookup transformation to update already existing target tables.
• Extensively used reusable objects like mapplet, sessions and transformations in the Mappings.
• Developed sequential, concurrent sessions and validated them. Scheduled these sessions using workflow manager.
• Developed stored procedures and tested the application with Toad. Developed PL/SQL procedures and functions to build business rules which help to extract data from source and load to target.
• Coordinated with Oracle DBA and UNIX admins on oracle upgrade and server related issues respectively.
• Utilized Informatica Data Quality for data profiling and matching/removing duplicate data, fixing the bad data, and fixing NULL values.
• ETL experience in using SAP BODS, Cognos Data Manager and Informatica.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica Power Center.
• Extensively worked on performance tuning of Informatica and IDQ mappings.
• Worked with SAP and Oracle sources to process the data.
• Created Informatica workflows and IDQ mappings for - Batch and Real Time.
• Worked extensively on SQL, PL/SQL, and UNIX shell scripting.
• Proactively evaluated the quality and integrity of data by unit test and system test for Informatica mappings as per the business needs.
• Managed open defects and brought them to closure by working closely with Developers during SIT, UAT and Performance testing.
• Experience in creating test data in for performance testing using various data generator tools.
• Writing different test cases for business rules validations during UAT phase and logging the defects in Quality Center.
• Extensively used change data capture concept in Informatica as well as in the Oracle DB to capture the changes to the Datamart.
• Experience in implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Managed QA tasks, requirements, and defects in HP Quality Center.

Environment: Informatica Power Center 9.5, Informatica Data Quality (IDQ), Informatica B2B, Oracle 11g, DB2, XML, Flat Files, Win7, SQL * Plus, Control-M, SAP R/3, SAP BODS, Toad and UNIX

Confidential, WI

ETL/Informatica Developer

Responsibilities:

• Experience in requirements gathering, analysis, function/technical specifications, development, deploying and testing.
• Prepare/maintain documentation on all aspects of ETL processes to support knowledge transfer to other team members.
• Used Informatica Power Center for migrating data from various OLTP databases to the data mart
• Worked with different sources like Oracle, flat files, XML files, MS SQL Server.
• Created Mappings using Mapping Designer to load data from various sources, made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Router, Sequence generator, Union and Update Strategy transformations.
• Created mapplets using Mapplet Designer and used those Mapplets for reusable business process in development.
• Created Web services in IDQ developer tool and generated WSDL file for real time services.
• Profile source data using IDQ tool, understand source system data representation, formats & data gaps.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Experience in implementing the Land Process of loading the customer/product Data Set into Informatica MDM
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Configured match rule set property by enabling search by rules in MDM per Business Rules.
• Worked on Informatica cloud for creating source and target objects, developed source to target mappings.
• Loaded data into MDM landing table for MDM base loads and Match and Merge.
• Performance tuning of Informatica designer and workflow objects.
• Used Teradata Utilities (SQL Assistant, BTEQ, MultiLoad, and FastLoad) to maintain the database
• Created pre/post session commands and pre/post session SQLs to perform tasks before and after the sessions.
• Implemented slowly changing dimensions (Type I and Type II) for customer Dimension table loading.
• Created UNIX KSH shell scripts to kick off Informatica workflow in batch mode.
• Invoked Informatica using "pmcmd" utility from the UNIX script Teradata using "BTEQ".
• Experience in Unit testing, Iterative testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Provided support for the applications after production deployment to take care of any post-deployment issues.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.

Environment: Informatica PowerCenter 9.5.1, Informatica IDQ, Teradata 14.0, Teradata SQL, Tableau 10.x UNIX shell scripting.

Confidential, Oklahoma City, OK

ETL/Informatica Developer

Responsibilities:

• Experience in business analysis and technical design with business and technical staff to develop requirement document and ETL specifications.
• Developed the detailed database design document which included data dictionary, data estimates, entity relationship (ER) diagrams, dimensional model (Snowflake schema) using Erwin, MS Office and MS Visio
• Extensively Used Informatica Designer as an ETL tool to extract data from legacy source (Mainframe) systems to Target system.
• Extracted data from multiple operational sources for loading into staging area, Data warehouse, Data Marts using SCD's (Type 1 and Type 2) loads. In this process, Informatica is used to implement business rule, transform and load.
• Created ETL Mappings, sessions and workflows using Informatica Power Center to move Data from multiple sources like XML, DB2, SQL Server, and Oracle into a common target such as Data Marts and Enterprise Data warehouses. And used direct and indirect flat files (delimited and fix width) as a source of data.
• Build a re-usable staging area in Teradata for loading data from multiple source systems using template tables for profiling and cleansing in IDQ
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner (all type of joiner), Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart and Enterprise Data Warehouse.
• Experience in Unit testing. Created the test case documents for individual mappings and tasks.
• Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Control-M.
• Wrote complex SQL queries, Function, Store Procedure using cursor and record data type and trigger in Oracle database.

Environment: Informatica Power Center 9.1, Solaris Server 10, Informatica Data Quality (IDQ), Oracle 10g/11g, DB2, Control-M, Toad, Erwin, MS Office and MS Visio.

Confidential, VA

ETL/Informatica Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively worked on Power Center Client Tools like Power Center Designer, Workflow Manager, and Workflow Monitor, Power Connect.
• Analyzed the source data coming from different sources and worked on developing ETL mappings/mapplets.
• Imported data from Relational databases, Legacy Systems, XML files and Flat files to Oracle database using Informatica Power Connect.
• Worked on IDQ Mapping Designer, Mapplet Designer, Transformation developer Designer, Workflow Manager and Repository.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Sequence generator, Union and Update Strategy transformations.
• Created Parameter files and validation scripts, Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Designed multi-dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Created UNIX KSH shell scripts to kick off Informatica workflow in batch mode.
• Invoked Informatica using "pmcmd" utility from the UNIX script.
• Done the end to end testing with the source system.

Environment: Informatica Power Center 8.6.1, Power Exchange, Informatica Data Quality (IDQ), Informatica Power Connect, Oracle 10g, SAP BW Flat Files, Teradata, UNIX.