PROFESSIONAL SUMMARY:

• Informatica Senior Developer with over 9+ years experience within the Healthcare, Pharmaceutical and Consulting Industries.
• Over 3+ years of experience with Informatica MDM and Informatica IDQ.
• Extensive ETL experience using Informatica Power Center 9.x/8.x/7. x. with expertise in upgrade. Experience in Creating Repository, Target Databases and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism - using Informatica, Pentaho, OWB, Tableau.
• Expertise in implementing Business rules by creating complex Informatica mappings/mapplets, shortcuts, reusable transformations, tasks, sessions, workflows/worklets using Designer and Workflow Manager.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator, Union and Stored Procedure transformations.
• Extensively used BMC Control-M to schedule the jobs. Wrote UNIX shell Script for processing/cleansing incoming text files and for the Data flow and Control flow order.
• Exposure to the entire process of Software Development Life Cycle (SDLC) including Requirement Analysis, Requirement Gathering, Cost Estimation, Project Management, Design, Development, Implementation, Testing and Maintenance.
• Experience working with Agile Scrum and Waterfall methodologies.
• Expertise in Relational Database Systems and Data warehousing like Oracle, DB2, Teradata, MS Access, SQL Server.
• Experience working with Microsoft tools like SSIS, SSRS, SSAS.
• Experienced in Data Modeling in Enterprise Data Model (EDM), Star/ Snowflake schema modeling, Fact and Dimension Tables, Physical and Logical data modeling.
• Comprehensive experience in UNIX scripting and basic Perl scripting for the optimal process flow.
• Knowledge in Java and pearl.
• Worked with Member Eligibility & Claims Billing application areas.
• Worked with HIPAA industry standards for ANSI834/837 Source processing.
• Worked with FACET model for Claims Submission, Adjudication, and Reconciliation process.
• Create notification UNIX shell scripts for maintaining Informatica box.
• Excellent oral & written communication skills.

TECHNICAL EXPERTISE:

ETL: ETL Informatica Power Center 10.1/9.5/8.x/7.x/6.x, MDM, Informatica IDQ, Tableau, OWB 10g, Pentaho Kettle PDI.

DATABASES: Oracle 12c/11g/10g/9i, DB2, SQL Server 2014 / 2012 / 2008 , Teradata, MySql, Netezza.

REPORTING TOOLS: Crystal Reports, SSRS, SSAS, Business Objects XI, CSV reports to read in MS Excel

DATABASE TOOLS: Oracle tools Toad, SQL Developer, SSMS, phpMyAdmin and Squirrel SQL Client Version 3.2.1

SCHEDULING TOOLS: Tivoli Work Scheduler (TWS), BMC Control M, Informatica Scheduler

SCRIPTING: UNIX, PERL, PYTHON, JAVA.

PROGRAMMING: .Net Framework(C#), Java, PL/SQL, TSQL.

ENVIRONMENT: UNIX, AIX Windows XP/2000/NT, Windows Vista, Window 7, 8, 10 and LINUX.

OTHERS: MICROSOFT Word, Microsoft Excel and Microsoft Access, EDM, Erwin, JIRA.

PROFESSIONAL EXPERIENCE:

Confidential, Texas

Sr. Informatica ETL Developer

Responsibilities:

• Created Complex mappings for delivering the incremental comparative reports. These extracts contain changes after the comparison between the MDM EPIC data brought into MDM.
• Developed Complex Mappings for creating match-merge reports.
• Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
• Worked on data cleansing using the cleanse functions in Informatica MDM.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation.
• Identified and eliminated duplicates in datasets thorough IDQ components.
• Integrated Informatica Data Quality (IDQ) with Informatica Power Center and Created POC data quality mappings in Informatica Data Quality tool and imported them into Informatica power center as mappings, mapplets.
• Worked on Informatica IDD with the data quality management team.
• Designed and developed data quality procedures using IDQ.
• Created events and tasks in the work flows using workflow manager.
• Tuned performance of Outbound ETL. Performed CDC based on MDM last update date, which is indexed and maintained by MDM. Used the parameterization template mapping/session for each base object, and had that as first task in the Workflow.
• Tuned performance of Informatica session to optimize the EMPI data load to landing process. Created Pre-Landing tables in Oracle and bulk loaded them. Used SQL Transformation in Informatica Designer to populate the data from Pre-Landing tables to actual Landing tables.
• Created mappings for loading data files received from different Sources like ECHO, and CLARITY etc. Worked with different kinds of input files like CSV, XML, Tab delimited files etc.
• Worked on FACET claim processing system.
• Used PL SQL stored procedures as part of mappings to improve performance.
• Created Mapplet for Address Validation and used it in various Mappings.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them

Environment: Informatica Power Center 10.1, 9.6, 9.5.1, Informatica MDM 9.7, informatica IDQ, Oracle 12c/11g, SQL Developer.

Confidential, Miami, Florida

Sr. Informatica Developer

Responsibilities:

• Worked on a project, where we are sourcing the data from the MDM tables and bringing in to the Netezza dB and creating dimension and fact mappings based on the business logic for the reporting team.
• The objective of the project was to design and develop a new data ware house which will replace the current Enterprise Data Warehouse. The ETL Process involved extraction and migration of the data from SQL server, sales force and Flat files, implementing the business logic and populating the data into the target data mart (Netezza). This project consists of three stages - staging, dimensional and fact. 
• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracting data from flat file, Excel files, DB2, sql server and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Working with various sources such as Flatfiles, Relational, XML and WebServices as part of Informatica Mappings.
• Designed and developed Technical and Business Data Quality rules in IDQ (Informatica Developer) and created the Score Card to present it to the Business users for a trending analysis (Informatica Analyst).
• Worked with Generator, Matcher, Associator, Consolidator for analysis in IDQ.
• Developed unix shell scripts to manage file handling process.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Extracting data from XML, MS SQL and performed Delta mechanism using Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Used SSMS to develop and debug procedures and packages.
• Excellent understanding of Star Schema Data Models; Type 1 and Type 2 Dimensions.
• Created pre sql and post sql scripts which need to be run at Informatica level..
• Knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems, OLTP and OLAP systems. Experience in FACT & Dimensions tables (SCD), Physical & logical data modeling with normalization process.
• Developed workflow dependency in Informatica using event wait task, command wait and control task.

Environment: Informatica Power Center 9.5.1, Informatica Data Quality (IDQ), Informatica MDM 9,Netezza 7.2, MS Access, MS SQL Server 2012, TSQL, IBM DB2, OBIEE 10.1.3.x,, Unix,, SSMS, Web Services Hub.

Confidential, IL

ETL Developer

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• 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 reusable Transformations in Informatica power centre.
• Worked with SSIS for creating packages in SQL server, SSRS and SSAS for reporting.
• Analyzed business process workflows and assisted in the development of ETL packages for moving data from source to target systems.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Worked on with Informatica power centre
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the TSQL stored procedures, packages for the ETL processes.
• Involved in the process design documentation of the DW Dimensional Upgrades.

Environment: Informatica Power Center 8.6.1/7.0/6.2 , T-SQL, Visual Studio(SSIS)TOAD, Erwin 4.0, SQL server 2008,TSQL.

Confidential, NY

ETL Developer

Responsibilities:

• Involved in requirements gathering, functional/technical specification, Designing and development of end-to-end ETL process for Sales Data Warehouse.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator) in a
• Mapplet and created new mappings using Designer module of Informatica.
• Modeled the data warehousing data marts in Star join schema.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Extensively worked on the performance tuning of the Mappings as well as the sessions.
• Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Informatica Power Center 7.1, Oracle 9i, PL/SQL, Erwin 3.5, TOAD, SQL Navigator

Confidential

Programmer Analyst

Responsibilities:

• Involved in analysis of Extraction, Transformation and Loading process. Involved in creation of the mappings between sources and target tables.
• Used different transformation like Expression, Aggregator, Source Qualifier, Sequence Generator, Filter, Router, Update strategy and Lookup Transformations.
• Created reusable transformations. Involved in unit testing as well as Functional testing. Created the sessions and Batches using Server Manager.
• Involved in debugging mappings and tuned for better performance. Created staging Tables, Indexes, Sequences, Views and performance tuning like analyzing tables, proper indexing.
• Identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.

Environment: Informatica 5.1, Business objects, Oracle 8i, Windows NT