SUMMARY

• 7 years of diversified experience in the field of Information Technology with an emphasis on Data warehousing using Informatica PowerCenter 9.x,8.x,7.xTarget Databases and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism - using Informatica.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Strong work experience in Data Mart life cycle development, performed ETL procedure to load data from different sources like SQL Server (2008/2012), Oracle, Teradata, and flat files into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor
• Involved in developing mappings and mapplets using Informatica Source Analyzer, Warehouse designer, Mapping Designer & Transformation Developer.
• Used various Transformationssuch as Expressions, Filters, and Aggregators, Lookups, Routers, Normalizer, and Sequence Generator etc. to load data into different Oracle, SQL, Teradata databases.
• Experienced in PL/SQL.
• Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Autosys.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Familiar with health care domain like Medicare, Medicaid and commercial insurances in HIPAA ANSI X12 formats including 997, 837, 835, 277, 276, 271, 270, NDC, NSF and NCPDP format.
• Comprehensive knowledge in HIPAA Compliance, Healthcare Information Technology (HIT), National Health Information Network (NHIN), Healthcare Common Procedure Coding System (HCPCS) process, ICD-9, ICD-10, Facets, EDI and ITS processing.
• Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout the entire SDLC.
• Worked on data analysis and data validations and preparing Unit Test Cases.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Experienced Informatica Data Quality (IDQ)

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager,IDQ

Databases: Oracle 10g, 11g, MS SQL Server 2008/2012, Teradata, Netezza

Environment: UNIX, Windows, Linux

Tools: Toad 9.1, SQL developer, ERWIN

Languages: UNIX shell Script, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

ETL/Informatica Developer

Responsibilities:

• Collaborated with users, Business Analysts to understand the overall system dataflow, gather and document requirements and translated the Functional Specification to Technical Specification for Informatica mappings
• Involved in analyzing different modules of facetssystem and EDIinterfaces to understand the source system and source data.
• Worked with Business Analyst in performing GAPAnalysis for HIPPA upgradation and coordinated with multiple teams like QA, Vendors to ensure timely project delivery.
• Helped BA and QA on technical aspects of General Equivalence Mapping (GEM) in the mapping process of ICD 9 and ICD 10 codes.
• Extracted and processed ourEDI andPaper Claims in order to submit the Inpatient, Outpatient and Medical claims to the State as part of encounter process.
• Coordinated with Data Analyst, Data Modeler and Data Warehouse team to analyze source data coming from various source system like Oracle, DB2, Flat Files and Teradata in designing logical and physical Dimensional Data Models and created Star Schema using ERWIN 7.3
• Created Source and Target Definitions in the repository using Informatica SourceAnalyzer and WarehouseDesigner.
• Designed and developed complex Informatica mappings, Slowly Changing Dimension (Type-I, Type-II and Type III) mappings to Extract, Transform and Load data from multiple sources into data warehouse and other databases using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router, Stored Procedure, XML, SQL transformations etc.
• Created Sessions and executing them to load the data from various source systems using Informatica Workflow Manager.
• Worked with incremental loading using Variables, Parameters andParameter Files.
• Extensively worked in the performance tuning of Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Designed and developed SQL queries. Created Cursors, functions, stored procedures, packages, Triggers,views,materialized views using PL/SQL Programming.
• Extensively worked in Oracle Performance Tuning. Used Oracle partitioning (range/hash/list), indexes (bitmap, B-tree, reverse key, etc.) and various join types (hash joins, sort merge, nested iterationjoin) to improve performance and analyzed DBMSstats, explain plan, SQL trace, SQL hints and TKPROF to tune SQL queries
• Documented Data Mappings/Transformations, and sessions as per the business requirement.
• Performed error checking, testing and debugging of various ETL objects and mappings using Informatica session logs to identify and rectify coding errors in process data-flow.
• Tested the data and data integrity among various sources and targets.
• Planned and coordinated testing across multiple teams, tracked and reported status, created test case and testcycle plan, troubleshoot data issues, validated result sets, recommended and implemented process improvements.
• Developed UNIXshellscripts to run the pmcmdcommands for scheduling workflows, collecting the session statistics and task detail and to interact with Informatica server in command mode.
• Responsible for PowerCenter upgrade from 9.1 to 9.5, Migrated ETL code from Informatica 9.1 to 9.5. Integrated and managed workload of Power Exchange CDC.
• Used Repository Manager to migrate workflows, mapping and shared object between development, testing and production environments.
• Involved in complete Software Development Life Cycle (SDLC) including Envisioning, Planning, Design, Development, User Acceptance Testing and Deployment.
• Coordinatedwith onsite and offshore ETL teams to meet the scheduled project deadlines.
• Provided 24/7 on call support in Testing and Production environment.

Environment: Informatica Power Center 9.5/9.1/8.6.1/8.1.1 SP3, Oracle 10g/9i, Teradata, IBM DB2, Flat Files Teradata SQL Assistant 7.1, ERWIN Data Modeler 7.3, PL/SQL, UNIX Shell Programming, SQL*Loader.

Confidential, Chevy Chase, MD

ETL/Informatica Developer

Responsibilities:

• Involved in designing the process for getting the data from all systems to Data Warehousing system.
• Performed major role in understanding the business requirements and designing and loading data into data warehouse (ETL).
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 9.1 Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Collection of data source information from all the legacy systems and existing data stores.
• Involved in Data Extraction, Transformation and Loading from source systems to ODS.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Used various transformations like Unconnected /Connected Lookup, Aggregator, Expression Joiner, Sequence Generator, Router etc.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Extensively used mapping debugger to find out errors in mapping. Also involved in troubleshooting existing ETL debugs.
• Parameterized the mapping and increased reusability.
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Extensively used Dynamic lookup to implement the type 2 changes.
• Experienced working in Informatica version based environment and used deployment groups to migrate the objects.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy using the concepts of Change Data Capture (CDC).
• Utilized Mload, FastLoad utility of the Teradata to load data in the Teradata Enterprise Data Warehouse (EDW).
• Used PMCMD commands of Informatica in UNIX scripts to schedule sessions and jobs.
• Experienced in Informatica Data Quality (IDQ).

Environment: Informatica Power Center 9.1, Windows, SQL Server 2012/2008, Oracle 11g, Perl, PL/SQL, Toad, Erwin

Confidential, New York, NY

ETL/Informatica Developer

Responsibilities:

• Responsible for requirements gathering, analysis and end user Meetings.
• Design, development, deployment, and production support.
• Extracted Data from different source systems like Oracle, Flat files, Teradata, Netezza.
• Worked with PL/SQL to create complex queries and procedures.
• Worked with various transformations in Informatica power center like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, and Update Strategy transformations.
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, TO DATE, Decode, and IIF functions in Expression Transformation.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join In the Joiner transformation.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Reviewed and tested Informatica ETL code and wrote test plans.
• Responsible for 24/7 Informatica production support.
• Involved in various meetings, seminars, presentations and group discussions.
• Worked with Informatica Data Quality (IDQ)

Environment: Informatica Power Center 9.1, Oracle 11g, Pl/SQL, Perl, TOAD, Erwin, SQL Server, Shell Scripts.3

Confidential, Kansas City, MO

ETL/Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification.
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development.
• Used PL/SQL procedures for Informatica mapping for truncating the data in target tables at runtime.
• Worked on Informatica PowerCenter 9.1 tool -Source Analyzer, Data warehousing designer, Mapping Designer &Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Extensively used Informatica PowerCenter to load data into different databases: SQL Server, oracle, Teradata
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations.
• Implemented effective date range mapping (slowly changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Worked with Variables and Parameters in the mappings.
• Worked in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions. Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing
• DevelopedUNIX Shell Scriptsfor scheduling the sessions in Informatica.
• Involved inPerformance tuningfor sources, targets, mappings and sessions.
• Used breakpoints and various test conditions with Debugger tool to test the logic and the validity of the data moving through the mappings.
• Created logical and physical data models and maintained relationships between tables using Erwin.
• Created deployment groups, migrated the code into different environments.
• Experience with Application ILM, Data Quality and Data Governance.
• Worked closely with reporting team to generate various reports.
• Experienced in Informatica Data Quality (IDQ)

Environment: Informatica PowerCenter 9.1, PL/Sql, Teradata, TOAD, Oracle 10g, SQL Server, Teradata, UNIX Shell Scripts, Erwin.

Confidential, Philadelphia, PA

Informatica Developer

Responsibilities:

• Extracted data from relational databases Oracle, Flat Files, and Teradata.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and Load data into Enterprise Data Warehouse (EDW) and Operational Data store (ODS).
• Developed data Mappings, Transformations between source systems and warehouse
• Performed Type 2 mappings.
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Performed Data Validations using Microsoft SQL Server Management Studio 2008.
• Worked closely with BA, and DBA team.
• Preparation of test cases/scenarios and execution.
• Recording, tracking and closing of defects/bugs in a systematic manner into a Defect Tracking System and preparation of bug report with bug severity and bug priority.
• Used debugger to test the mapping and fixed the bugs.
• Created sessions, sequential and concurrent sessions for proper execution of mappings in workflow manager.
• Used Power Center Data Masking Options (Random Masking, Blurring, SSN, and Credit Card) in mappings.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data).
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Access, Flat files, UNIX shellscripting, Windows XP, CA Autosys