SUMMARY

• Around 8 years of IT industry experience in Analysis, Design, Development and Maintenance.
• Experienced in Data Warehouse applications using Informatica, Oracle, DB2, MS SQL server on Windows, IBM and UNIX platforms.
• Highly involved in designing and developing complex mappings using ETL tools, Informatica PowerCenter 9.6.1/9.5.1/9.1/9.0/8.6/8.1/7.1.
• Informatica MDM Hub Console developer experience with versions 9.5x.
• Excellent knowledge and experience in data warehouse development life cycle, requirements analysis, dimensional modeling, Repository management and administration, implementation of STAR, Snowflake schemas, Incremental loads/Change Data Capture and slowly changing dimensions.
• Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), stored procedures, and shell scripting to run pre session and post session commands.
• Experience in business requirements gathering, define and capture metadata for business rules, creating physical infrastructure, system analysis, design, development and user training associated with the ETL processes.
• Expertise in trouble - shooting production issues by root cause analysis to identify the problem, impact analysis to determine the dependencies and providing the resolution.
• Experience working with Oracle, Sql Server, Netezza & Teradata.
• Strong SDLC skills including the ability to work through the entire development cycle from gathering requirements through implementation including documentation.
• Having real time experience on Data Profiling, Address Validation and developing mappings using different transformations in informatica Developer (IDQ) and also in making scorecards Analyst.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Well versed in developing thecomplex SQL queries, unions and multiple table joins and experience with Views.
• Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica.
• Worked with different Mappings, Transformation Strategies, Stored Procedures, Sessions, Importing and Exporting of data sources.
• Highly motivated and hardworking individual with penchant for learning new technologies.
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.

TECHNICAL SKILLS

ETL Tools: InformaticaPowerCenter 9.6.1/9.5.1/9.1/9.0/8.6/8.1/7.1 Informatica Data Quality, Data Stage 6.0, Informatica MDM

Database: Toad, Oracle (12c/11g/10g/9), MS SQL Server 2008/2005, MySQL, DB2,Netezza, Teradata V2R6/V13, Oracle EBS.

Operating Systems: Windows XP/2003/2000, Windows 2K/2003 Server, UNIX.

Programming Languages: SQL, PL/SQL, Perl Scripting, HTML,Unix

DB Tools: Oracle SQL Developer, SQL*Loader, Putty, Toad, SQL*Plus, MS visual studio, Autosys and Eclipse IDE.

BI Tools: SQL, Tableau, SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS)SQL Server Analytical Services (SSAS) Data Transformation Services (DTS), Visual Studio, BIDS, Power BI, Informatica

PROFESSIONAL EXPERIENCE

Confidential, IL

Informatica Consultant

Responsibilities:

• Extensively involved in requirements gathering, writing ETL Specifications and preparing design documents.
• Created complex mappings to extract transform and load data into data warehouse.
• Developed and executed various SQL Scripts for unit testing and system testing.
• Involved in Performance tuning of sessions and mappings for better performance.
• Created complex Informatica mappings by using transformations such as the Source qualifier, Expressions, Aggregators, Connected, Normalizer, Filters & Sequence generators.
• Implemented SCD methodology including Type 1 and Type 2 changes.
• Involved in complete SDLC ETL process from development to testing and production environments.
• Experienced in developing and executing complex SQL queries to validate the data in the back end.
• Created dashboards with charts, graphs that convey meaningful data and insights using Power View.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for Error handling the packages.
• Extensively used SSIS Data Profiler Task to profile target source systems (tables & views) prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing the table structures.
• Used pmcmd to run workflows and created Cronjobs to automate scheduling of sessions.
• Created Mappings to extract the data from different data source like Flat files, Sql Server, Oracle 11g.
• Experience working in power Exchange for Netezza and Informatica Pushdown Optimization, Data Analysis.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Working as Informatica Administrator, scheduling regular backups and security.
• Worked on extracting the data from third party databases like Soft lab, Confidential, Radnet and Morrissey systems.
• Worked on EPIC’s Inpatient, Ambulatory, Hospital billing, and Professional billing and optime models.
• Worked on parameters, variables, procedures, scheduling and pre/post session shell scripts.

Environment: Informatica9.6/8.6/7.1, Oracle11g/10g/9,Unix Shell scripting, Sqlserver 2005, Mainframes, Power Connect, Cognos 8/10.2, Metadata Reporter.

Confidential, Mansifiled, MA

Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Created complex mapping.
• Created a view to handle multiple packages in the XML.
• Maintained day to day report on the errors and successful ACK3 from FDA and prepared Excel charts.
• Implemented SCD methodology including Type 1 and Type 2 changes.
• Involved in ETL process from development to testing and production environments.
• Unique Device Identification (UDI) Program for Medical Devices in Global instance that meet regulatory.
• Used pmcmd to run workflows and created Cronjobs to automate scheduling of sessions.
• Involved in writing batch scripts to pull the required information from ACK3 xml files.
• Ack3 are loaded into database Tables usingInformatica power center.
• Generated Xmls usingInformatica power center to send FDASIA Skus to FDA through GHX using PTC Windchill Tool.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Created new mappings and updating old mappings according to changes in Business logic.
• Actively Involved into Informatica code migrations and monitoring according to our client's standards.
• Involved in the documentation of the ETL process with information about the various mappings, the order of execution for them and the dependencies.
• Involved inPerformance Tuningat various levels including Target, Source, and Mapping.
• Prepared unit test cases to meet the business requirements and performed unit testing of mappings.
• Perform ETL Informatica Administration functions such as user access accounts, roles, and setting standards.
• Create and manage users, groups and folders. Ensure appropriate privileges are assigned to the different users.
• Involved in integration testing at various levels including Target, Source, and Mapping.
• Perform ETL Informatica Administration functions such as user access accounts, roles, and setting standards.

Environment: Informatica Powercenter9.6/9.1/8.1, WindowsXP,TOAD,OracleSQL,PL/SQL, Oracle11g/9 and SQL Server, Skybot.

Confidential, Seattle, WA

ETL Informatica Developer

Responsibilities:

• Extracted data from different data sources and loaded them into Oracle using Informatica Powercenter 7.1.
• Extensively used Informatica to create and manipulate source and target definitions, mappings, transformations (re-usable).
• Responsible for creating staging areas through Informatica Power Center.
• Implemented SCD methodology including Type 1 and Type 2 changes.
• Created Data Flow Mappings in DQ tool using business mapping sheet.
• Performed Data Profiling using informatica Data Quality Tool.
• Understand the data quality rules defined by the business/functional teams and propose the optimization of these rules if applicable, then design and develop these rules with IDQ,including thorough unit test planning and performing.
• Informatica ETL Power Center mapping processes.
• MDM data mappings were developed for loading stage tables which is merged and consolidated and base objects is created, updated and published.
• Involved in ETL process from development to testing and production environments.
• Wrote shell scripting to create pre-session and post-session commands.
• Used pmcmd to run workflows and created Cronjobs to automate scheduling of sessions.
• Involved in performance tuning of Sources, Targets, Mappings and Sessions.
• Designed extensive sample business Reports to cater the needs, which can meet their future demands on behavioral, trend analysis.

Environment: Informatica Power Center7.1,MDM 8.6.1 Oracle 9, MS SQL Server2000, SQL*Plus, PL/SQL, ERWin, SQL*Loader, UNIX (Sun Solaris), Windows NT, Cognos.

Confidential

Sr.ETL/Informatica Developer

RESPONSIBILITIES:

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Responsibilities included designing and developing complex Informatica mappings including Type-I, Type-II slowly changing dimensions.
• Produced detailed MDM design specifications consistent with the high-level MDM design specifications.
• Migration of objects across various environments
• Had developed and tested the warehouse application according to functional specifications using Teradata utilities, UNIX.
• Closely worked with Data steward team for designing, Documenting and configuring Informatica Data Director for supporting management of MDM data.
• Creation of Unit Test Cases.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue. Preparing the documents for test data loading.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level. Developing, Testing and debugging the mappings in Informatica.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor

Environment: Informatica Powercenter9.1.0, Informatica MDM,TOAD,OracleSQL,PL/SQL and Oracle11g/9i, Sybase and Control - M.

Confidential

ETL Informatica Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using Informatica into the database. Involved in Logical and Physical modeling of the drugs database.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files to target Oracle Data Warehouse database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table.
• Implemented SCD methodology including Type 1 and Type 2 changes.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Used pmcmd to run workflows and created Cronjobs to automate scheduling of sessions.
• Involved in ETL process from development to testing and production environments.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Informatica Power Center7.1, Oracle 9, SQL Server 2005, XML, SQL, PL/SQL, UNIX Shell Scripts.