PROFESSIONAL SUMMARY:

• 8+ years of IT experience with multinational clients which includes 8+ years of development and testing of ETL processes using Informatica Power Center.
• Good knowledge of Data warehouse concepts and principles like Star Schema, Snowflake, SCD Types, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Netezza and Teradata and Worked on integrating data from XMLs. XSDs, flat files like fixed width and delimited, and COBOL mainframe sources, Message Queue sources and Web services.
• Experience in Creating PL/SQL specifications based on requirements and analysis of data.
• Strong Experience on writing SQL Queries, PL/SQL Procedures in Oracle Databases.
• Have extensively worked in developing ETL mappings for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Update Strategy, Unconnected / Connected Lookups, Aggregators, Java, Normalizer, Xml Generator/ Parser, web service consumer transformation etc.
• Worked extensively on SCD Type1 and SCD Type 2 mappings.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments. Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow, ETL source to target document for better maintenance and analyzing the process flow, ETL tailoring document, ETL migration document.
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Working experience on Talend for big data and data integration.
• Strong in UNIX Shell scripting. Developed UNIX scripts using PMCMD utility and scheduled and monitored ETL processes using utilities like Autosys, Control-M and CA7 Passport.
• Good knowledge of Informatica Data Quality and Informatica metadata manager for data profiling and impact analysis.
• Experience working in both waterfall and agile methodology.
• Migrating data mapping to higher environments using deployment groups as well as manually.
• Experience in monitoring, troubleshooting and restarting batch processes using Informatica Power Center and Control-M workload automation.
• Demonstrated ability to work and communicate effectively with both business and technical audiences.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6-10.2, Informatica Data Quality (IDQ) 10.x, Talend for Big Data

Databases: Oracle, SQL Server, DB2, Teradata, Netezza, WebSphere Message Queue, Mainframe

GUI Tools: Toad, SQL Navigator, SQL* PLUS, SQL Developer, SQL Assistant, SQL Server Management Studio, Aginity Workbench for Netezza, Teradata SQL Assistant

Scheduling Tools: Informatica Scheduler, Autosys, Control-M scheduler

Scripting Languages: UNIX/Linux Shell Scripting, Connect Direct (CD) Script

Operating Systems: Windows NT/2000/XP Professional/2003 Server / 2008 Server/ 2012 Server, LINUX, UNIX

Office Tools: Microsoft Office Suite

Oracle Tuning: Tuning, Explain Plan, Table Partitioning, Materialized views, Hints

PROFESSIONAL EXPERIENCE:

Sr Informatica Developer

Transamerica, Plano, TX

Responsibilities:

• Worked closely with the end users, business analysts, data architects and data modelers in writing the functional specifications based on the business needs and for understanding functional requirements.
• Prepared detailed technical design documents, data discovery document and testing documents based on functionality required and to incorporate/list all data sources/components in detailed manner.
• Designed ETL mappings to extract data from Oracle, DB2, Flat Files (Fixed Width and delimited) to staging databases and from staging to the target Data Warehouse database, which further loaded into sales force application.
• Designed ETL mappings to extract data from multiple databases like Oracle, DB2, Teradata, Flat Files, mainframe sources (COBOL copybooks), and XML files and loaded into database targets, XML file targets and flat file targets using the mapping designer.
• In multiple projects my Datawarehouse is build on top of Oracle, Netezza and Teradata databases.
• Designed ETL mappings to receive data from WebSphere MQ source and sending response back to WebSphere message queue targets using mapping designer.
• Worked extensively on XMLs and XSD Schema definitions, which also include streamlining and standardization of XSD schemas to be used for all Print systems.
• Imported and exported of XSDs in informatica power center, designed extensive ETL mappings to load data from oracle tables, flat files and COBOL Copybooks to xml targets and configured xml targets definitions.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, Sequence Generator, XML Generator and XML Parser and Web service Consumer transformation.
• Strong Experience on writing SQL Queries, PL/SQL Procedures in Oracle Databases.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Involved in setting workflow dependencies using event wait tasks and generating an event file (trigger file) by creating a command task in Informatica.
• Involved in unit testing, user acceptance testing to check weather data is loading into target as per business needs.
• Created ETL tailoring document to list all the Informatica components that needs to be tailored in all environments,
• Created ETL source to target document to show data flow between source and target warehouse,
• Created ETL migration documents to list all the necessary components and flow for migration to higher environments.
• Involved in error handling of informatica processes and workflows. Implemented the best practices for error handling of records in Informatica mappings and configured Informatica workflows to record and handle the errors as per business rules and user requirements.
• Involved in auditing processes. Created ETL flows to generate a file with audit records, this audit file was later feed into an audit database for audit processing.
• Used Debugger in troubleshooting the existing mappings and involved in identifying bugs by analyzing the dataflow, evaluating transformations and fixing the bugs so that they match to business needs.
• Developed UNIX shell scripts to control the process flow for Informatica workflows to handle high volume data.
• Created and scheduled Sessions, Jobs based on demand, run on time, run only once and run continuously using Workflow Manager.
• Configured Informatica sessions and workflows for real time job scheduling. Defined various session properties to schedule Informatica workflow to run continuously and process the user requests whenever needed without any time lag.
• Involved in migration of mappings and workflows to upper environments using repository manager.
• Involved in entire migration processes from Development, Test, Model and Production environments.
• Involved in submitting migration requests and taking high level approvals for migrating codes from Development environment to Test, Model and Production environments
• Provided production support and hyper care support after project go live.
• Worked as an informatica lead to guide team on technical front, capturing requirements and assisting with deliveries.
• Coordinated with on site and off shore and daily status calls with off shore.
• Worked on tracking and delivering milestones against project plan.
• Demonstrated ability to work, communicate effectively and coordinate between both onsite and offshore teams.
• Created detailed knowledge transfer documents and provided detailed overview of the tools/processes used in the new Mosaic and DLS flows.

Environment: Informatica Power Center version 9.6-10.2.x, Informatica Data Quality IDQ, Informatica Metadata Manager, Oracle 10g/9i, TOAD, SQL Server, PL/SQL, SQL Server Management Studio, Windows XP, Linux

Informatica Developer

Confidential, Pittsburgh PA

Responsibilities:

• Worked closely with the end users in writing the functional specifications based on the business needs.
• Responsible for gathering suit of business requirements, prepare Source to Target Mapping specifications and Transformation rules.
• Created Source to Target Mapping Specification Document.
• Involved in system study, analyze the requirements by meeting the client and designing the system.
• Developed mappings/reusable objects/ transformation mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Extracted data from different sources like SQL Server, Oracle, Flat files and loaded into ODS.
• Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact summary) data identified by dimensions using Informatica ETL tool.
• Used the Update Strategy Transformation to update the Target Dimension tables.
• Created connected and unconnected Lookup transformation to look up the data from the source and target tables.
• Involved in Performance tuning for sources, targets, mappings, sessions and server.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Ensured the Data Marts loads, runs on time accurately.
• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings on the development server.
• Created test cases and completed unit, integration and system tests for Data Warehouse.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Used SCD Type 2 to load historical data into the data warehouse.
• Involved in versioning the whole process and retiring the old records using the built-in’s DD UPDATE, DD DELETE, and DD INSERT
• Identified sources, targets, mappings and sessions and tuned them to improve performance.
• Used Debugger in troubleshooting the existing mappings
• Involved in the ETL Source to Target documents walkthrough process with QA team.
• Involved in creating the migration documents to deploy the code from one environment to another.

Environment: Informatica, Oracle 11g, Toad, SQL Developer, SQL Plus and UNIX, OLTP and OLAP Systems

Informatica Developer

Confidential, Cincinnati OH

Responsibilities:

• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Analyzed the data from various sources such as PeopleSoft, AVR, etc. to maintain consistency and performed validation.
• Involved in system study, analyze the requirements by meeting the client and designing the system.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Workflow Manager.
• Developed various mappings using Aggregator, Lookup and Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator.
• Created Complex Mappings which involved SCDs to implement Business Logic and capturing the deleted records in the source systems.
• Used SCD Type 2 to load historical data into the data warehouse.
• Involved in versioning the whole process and retiring the old records using the built-in’s DD UPDATE, DD DELETE, and DD INSERT
• Identified sources, targets, mappings and sessions and tuned them to improve performance.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
• Created PL/SQL packages and stored procedures to load data from various sources to staging area.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used SQL tools like SQL developer and Toad to run SQL queries and validate the data.
• Used CA7 Passport Scheduler and Informatica Scheduler for scheduling the jobs.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Wrote UNIX shell scripts to work with flat files to define parameter files and to create pre and post session commands.
• Used Debugger in troubleshooting the existing mappings.

Environment: Informatica, Oracle 11g, SQL developer, Toad, SQL Plus and UNIX, OLTP and OLAP Systems.

Informatica Developer

Confidential, Tulsa

Responsibilities:

• Responsible for design, development, and support of new and existing ETL processes utilizing best practices into Enterprise Data Warehouse.
• Help for support activities in the Accounts Payable, Manufacturing Execution, Inventory Management, and Production Planning functional areas.
• Analyzing the existing model and making the changes as per the Change Requests from the Client.
• Translated and designed maps for the requirements and codes for Informatica and performed the tasks.
• Prepare documentation on all aspects of ETL processes, definitions and mappings
• Performed tuning of SQL queries for extraction of data and Troubleshoot and resolved production Issues.
• Involved in creating Informatica Mapping / Sessions and Workflows.
• Effectively resolved production issues and taking responsibility for seeing those issues thru resolution.
• Supported ETL routines required for populating the Data Warehouse and Experience in loading high-volume data, Tuning and troubleshooting of mapping.
• Extensively worked on Informatica Designer, Workflow Manager, and Workflow Monitor.
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator etc.
• Used the Aggregator transformation to load the summarized data for Sales and Finance departments.
• Created Reusable Transformations and Mapplets to use the transformation logic in multiple mappings.
• Worked on Repository manager to create and manage user profiles and used Repository manager extensively while migration the code from development to production and compared both codes.
• Extensively worked on error handling.
• Worked on connected and unconnected lookups.
• Used the Informatica Workflow Manager to create and run the Workflows, Worklets and Sessions for loading the data using the logic from mappings.
• Create/Maintain database stored procedures, functions, views, types, tables.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table

Environment: Informatica Power center, UNIX, Oracle 11g, DB2, Netezza, TOAD, SQL Plus, MS Office.