PROFESSIONAL SUMMARY:

• 8+ years of experience in using ETL methodologies for supporting ETL data integration, DWH, Migration, ETL Architecture using Informatica Power Centre, Power Exchange, Tera Data, SSIS, Pentaho Kettle.
• Developed Reconciliation process for control tables.
• Mentor the team members.
• Responsible for handling various projects belong to offshore and onshore .
• Good understanding of Dimensional Modelling using Star schema methodology and Snow Flake schema methodology.
• Strong Experience in building Mapping Template by using the Visio.
• Hands on Experience in Dimensional Modeling .
• Strong experience in Different Domains like Health Care , Banking , Finance and Insurance .
• Strong experience in Providing ETL Design and ETL Solutions for moving the data from Data Marts to newly designed Dimensional Model.
• Hands of Experience in writing the script in order to automation the process for Dynamic Files
• Involved in building the logical and Physical model.
• Hands on Experience in scheduling the ETL jobs of Dimensional Models and Data marts by using Informatica Scheduler.
• Developed Reconciliation process in ETL Mappings.
• Hands on experience in preparing DMS/ Column Mapping Sheet for Dimensional modeling and Data marts Sources
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, DB2, and COBOL files, Copy Book Files, XML files and Worked on integrating data from flat files like fixed width and delimited.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer, Mapping Template.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregator s.
• Have experience in developing ETL mappings and testing them with various created test plan docs, test results and the code migration documents for SIT and PROD environment.
• 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.
• Experience in writing few shell scripting for various ETL needs.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance tuning of sources, targets, transformations and sessions.
• Prepared the Code Review Checklist, Standards document and Reusable components to be used across multiple projects.

TECHNICAL SKILLS:

ETL Tool: Informatica 9.x/8.x (Power Center/ /Power Exchange/SSIS, )

Languages: SQL, PL/SQL.

Databases: Oracle, SQL Server, DB2, Teradata, Tera Data Utilities, Cobalt, Copy book

SQL Tools: SQL Developer, TOAD, Management Studio

Office Tools: MSOffice, MS Project.

Operating Systems: Windows, UNIX, Linux, Sun Solaris. Main Frame, SharePoint, Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, Tulsa, OK

Responsibilities:

• Making Data Mapping Sheet for newly built Dimensional modes for each subject area.
• Responsible for making DG group for the deployment of code.
• Co-ordination with from the stakeholders.
• Weekly status meeting with the client to communicate the development progress and any issues arising during Design, Development and Testing phases.
• Developed ETL technical specs, ETL execution plan, Test cases, Test scripts etc.
• Designing, Development of Mapping Template using Visio.
• Converting the Main Frame files into flat files by defining the structure.
• Developed Reconciliation process for control tables.
• Performed Testing - unit testing, integration testing & performance testing.
• Building of Standardization documents and project time line.
• Mentor the Team Members.
• Worked with project managers, design and solution architect to achieve business and functional requirements.
• Analyze the requirements and accordingly plan, develop, design, test and implement the functionality and procedure.
• Review existing systems to determine compatibility of existing systems and impact analyses for downstream applications.
• Formulating the ETL mappings to implement the business logic. Used transformations like lookup, update strategy, expression, filter, router, aggregate, sequence generator. Implemented Performance tuning at mapping, session level. Extensively used look up cache and persistent cache to make the performance fast. Use sorter transformation to remove the duplicate record before aggregator.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.

Environment: Windows, Mainframe, UNIX, Oracle 11g, SQL Server, Informatica Power Center 9.6, IDQ, Power Exchange, Tera Data, HMS, SAP, Team Foundation Server, Visio for Informatica Mapping Templates

Confidential, Rock Ville, MD

Sr. Informatica Developer

Responsibilities:

• Making Data Mapping Sheet for newly built Dimensional modes for each subject area.
• Co-ordination with from the stakeholders.
• Prepared the Code Review Checklist, Standards document and Reusable components to be used across multiple projects.
• Developed complex mappings in INFORMATICA.
• Making the complex analyses using IDQ and building the reports on top of it
• Developed Reconciliation process for the Control tables.
• Building of Standardization documents and project time line.
• Provide the ETL solutions for Complex Data marts and Dimensional modeling projects.
• Co-ordinated with the Documents team during the analysis and design phase.
• Development of ETL mapping using Pushdown Optimization.
• Weekly status call for update on all the integration.
• Write shell script to automate the process.
• Co-Ordination with the off-Shore Team
• Write shell script for Dynamic files.
• Built ETL process using SSIS and provide the views for Reporting Systems.

Environment: Informatica Power Center 8.6, 9.1, SSIS, Oracle, Power Exchange, SQL server 2012, Teradata files, SQL Developer, Pentaho Kettle, XML, Main Frame Cobalt Files, Visio for Informatica Mapping Templates

Confidential, CT

Informatica Developer

Responsibilities:

• Actively involved in all the phases of project (Client Interaction, gathering requirements from Business users, Preparation of detail design, Development, Unit Testing and Production support)
• Used Informatica Power Center for migrating data from various OLTP databases to the data mart
• Sourced Teradata and DB2 data to staging table before loading to EDW. Used Power Exchange utility to read DB2 files in order to load customer table.
• Building the SAP connections.
• Extracted data from Sales department to flat files and load the data to the target Oracle database
• Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Data mart
• Created various Informatica mappings and Mapplet to load the data mart. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator
• Monitored and cleansed prescription and sales data using Informatica Data Quality (IDQ) - source data profiling using Informatica Analyst, and creating mappings in Informatica Developer to apply cleansing and business rules.
• Utilized name matching transformation to cleanse drug names based on results of data profiling. Created and scheduled application to run the mapping using Infacmd commands.
• Configured the mappings to handle the updates to preserve the existing records (Slowly changing dimensions) using Update Strategy Transformation (SCD Type-2)
• Used Debugger to identify the errors in the mappings and fix them
• Performed unit testing to validate mappings and populate the database
• Used TOAD and SQL Plus to write queries and interact with Oracle database
• Implemented several different tasks (Session, Assignment, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control) in the workflow

Environment: Informatica Power Center 8.1.1, 9.0, Main Frame, Linux, Oracle, Power Exchange, SQL server , Teradata , SQL Developer, Main Frame Cobalt Files, XML

Confidential, Madison, WI

Informatica Developer

Responsibilities:

• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Assisted in adding Physical conceptual data model using Erwin 4.0.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Involved in the process design documentation of the DW Dimensional Upgrades.
• Installed, and Documented the Informatica Power Center setup on multiple environments.

Environment: Informatica Power Center 7.1.1, DB2 UDB, Oracle 8i, SQL Server 2005, SQL, PL/SQL, Erwin, SQL*Loader, UNIX Shell Script, Business Objects 6.2

Confidential, Pittsburg, PA

Mid-Level ETL Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development.
• Involved in creating the views.
• Interacted with the source system to gather the requirements.
• Gathered requirement and prepared mapping documents and the data flow documents.
• Extensively used Informatica Transformation like Source Qualifier, Rank, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Involved in writing T-SQL Procedures Using SQL Server.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Developed Reusable Transformations and Reusable Maplets.
• Involved in Performance tuning for sources, targets, mappings, and sessions.
• Responsible for writing scripts
• Expertise in using Power Exchange in conversion of files and creating data maps.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Involved in Production Support.

Environment: Informatica Power Center 7.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, TOAD, Erwin 4.0, PL/SQL, UNIX (Sun Solaris).