SUMMARY:

• Certified Informatica ETL consultant with over 10 years of experience in IT industry with having extensively involved in Analysis and Design, Testing, Implementation, Maintenance and Production Support of ETL projects
• Experience in using Informatica PowerCenter with Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server Manager.
• Experience is in Banking, Healthcare domains.
• Sound knowledge in developing several complex mappings in Informatica, a variety of PowerCenter transformations, Mapping Variables & Parameter files in Mapping Designer using both the Informatica PowerCenter and IDQ.
• Proven experience with ETL the development, and implementation of Large-scale, Enterprise Data Warehouse and Reporting Solutions.
• Involved in Extracting, Scrubbing, and Transforming data from various sources like Oracle, SQL Server, DB2, Teradata, and Flat files and load the data into Oracle database using Informatica.
• Slowly Changing Dimensions Management including Type 1, 2, 3, De-normalization, Cleansing, Conversion, Aggregation, Performance Optimization.
• Design Source to Target Maps, Code Migration, Version Control, Scheduling Tools, Auditing, Shared Folders, Data Movement, and Naming in accordance with ETL Best Practices, Standards and Procedures.
• Responsibilities include scheduling and managing the deliverables and activities like UAT and coordinating with other groups like Data center, Production/ Change Management to implement various releases.
• Involved in Quality Assurance, Bug Fixing and Testing. Prepared user manuals and presentations.
• Strong Troubleshooting, Problem Solving, Analytical and Design skills.
• Experience in Dimensional Data Modeling using Star and Snowflake Schema.
• Extensively worked on ETL Informatica Transformations effectively including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings.
• Experience in integration of data sources like Oracle, SQL Server, and Flat Files.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, Triggers.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Deep knowledge in Master Data Management concepts, IDD and ability to apply this knowledge in building MDM solutions.
• Good exposure in configuration of Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter.
• Knowledge in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries and packages.
• Strong knowledge in configuring Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management.
• Knowledge on implementing User Exits using User Object Registry Module.
• Knowledge in integrating external business application with Informatica MDM hub using Batch processes, and the SIF.
• Effective communication, professional attitude, strong work ethic and interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Informatica Developer

Environment: Informatica 9.6, Informatica 10.2, Oracle, PL/SQL, Unix, Autosys

Responsibilities:

• Created mappings for extracting the data from various sources including flat files and relational databases.
• Involved in development of Informatica Mappings, Mapplets and Workflows for complex Business rules.
• Worked on boarding of new feeds of inflation swaps from Kapital.
• Worked on off boarding of supply ids from DAC and BOMAC context.
• Worked on new margin-pyramid equity and credit feeds and loaded them into the system (DAC).
• Worked on adding new attributes logic to the existing frameworks and performed functional and regression testing to validate the changes.
• Worked on User Defined Functions (UDF’s) to check generic validations and checks.
• Created shortcuts to reuse objects across folders without creating multiple objects in the repository
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to another Environment.
• Performed Unit Testing and verified the data using Informatica Debugger break points.

Confidential, Norfolk, VA

Sr. Informatica Developer

Environment: Informatica 9.5, Informatica 10.2, Oracle, PL/SQL SQL Server, VBScript, Tidal

Responsibilities:

• Created mappings for extracting the data from various sources including flat files and relational databases.
• Worked on creating a mapping to get all the vendor, fee paid claims in CCERT and look up in facets to get paid additional claims, and load into CCERT.
• Worked on cleanup of all PDF files from the Tgtfiles\letters folder and copied the missing files to the macces\prod folder.
• Worked on Forager claims load and RNF claims load for which the claims were getting loaded into CCERT application partially.
• Worked on creating a mapping to generate a report based on CCERT staging table
• Worked on creating a mapping to insert or delete or reject the rows based on source file and sent the acknowledgement file to the business in case of rejection.
• Created one time mapping to update both validated column and Facets adjusted column in claims and claims load tables
• Worked on modifying provider refund workflow to update the GL table for the newly added columns.
• Worked on modifying impacted workflows after increasing the column length in ACRH table.
• Worked on Creating a new workflow to sync offset restricted column from disb clove overpay table to ccert acpr detail table
• Worked on scenario where an email notification will be sent to DMS if there is no response from the DMS within 72 hours of load date.
• Worked on modifying A2A sync job to take the latest amt (i.e paid amt, deductible, coins,copay) and update in CCU A2A RECLAMATION CLAIM and CCU A2A REC CLAIMS LINE STG tables.
• Created a new mapping to a scenario where an email notification is sent once the 835 has been received (GS control date) and the paid amount is greater than 0 and if we have not received an RNF within 60 days.
• Created a nightly job to load all missing member information from facets for all missing member claims in CCERT.
• Created the new workflow where a report is generated for claims which are not lead approved. Once the report is generated the file is archived for future reference and an email is sent to business.
• Worked on informatica 10.2 upgradation project, which is the migration from 9.5 version.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Participated in daily Scrum meetings for the update on the daily basis and conducting internal and external reviews as well as formal.
• Used JIRA to access all the stories and worked on SVN to check in the code.
• Worked on scheduling the tidal jobs and link the tidal jobs to Informatica workflows.

Confidential, Jackson, MS

Sr. Informatica developer

Environment: Informatica 9.6.1 hotfix tool, UNIX, PL/SQL, Oracle, SQL Server, Autosys

Responsibilities:

• Understanding business model, Project architecture and customer requirements.
• Involved in developing of the ETL strategy to populate the Data Warehouse from various source systems using Informatica PowerCenter.
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Worked with various Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Integrate the data as per the requirement and build the data marts.
• Created Mapping, Transformations and Monitored Sessions using Informatica.
• Scheduled sessions by using Informatica scheduler to start Informatica Workflows.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Developed Mapplets and Worklets for reusability.
• Experienced in importing the source from Legacy systems and Operational systems by using Informatica Power Exchange by applying the concept of Changed Data Capture (CDC).
• Worked on Using Debugger to validate the mappings and gained troubleshooting information about data and error conditions.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in creating Sessions, Workflows and execution of Unit Test Conditions.
• Assisted Testing team in creating test plan and test cases.

Confidential, Tupelo, MS

Senior ETL Informatica developer

Environment: Informatica PowerCenter 9.1, Unix, PL/SQL, SQL Server, Autosys

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Developed mappings/sessions using Informatica PowerCenter 9.1 for data loading.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Write Shell script running workflows in UNIX environment.
• Used debugger in identifying bugs in existing mappings by analysing data flow, evaluating transformations.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks
• Reviewed and analysed functional requirements, mapping documents, problem solving and trouble shooting.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal
• Production Support has been done to resolve the on-going issues and troubleshoot the problems.

Confidential, Tupelo, MS

Informatica Developer

Environment: Informatica PowerCenter 9.1x, IDQ, Data modeling, Netezza, SQL, PL/SQL, Oracle 11g

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse.
• Worked on different tasks in Workflows like Sessions, Events raise, Event wait, Decision, e-mail, command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
• Created the repository manager, users, user groups and their access profiles.
• Extracted data from different sources like DB2, SQL server, flat files and loaded into DWH.
• Created complex mappings in PowerCenter Designer using Expression, Filter, and Sequence Generator.
• Data modeling and design of for data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Involved in Performance tuning for sources, targets, mappings, sessions and server.
• Handling Production Support Emergency issues.
• Used data miner to process raw data from flat files and also Loaded operational data from Oracle, SQL server, Excel Worksheets into various data marts
• Analyze any Autosys job failure and reschedule the jobs in UNIX.
• Created test cases and completed unit, integration and system tests for Data warehouse.

Confidential, St. Louis, MO

Informatica Developer

Environment: Informatica Power Center 8.6.1, Teradata, Oracle 9i, MS Visio, UNIX, Flat Files

Responsibilities:

• Studied and Analyzed the Business requirement and prepared scope document, ETL specification documents according to the business requirements.
• Designed Source to Target mapping using Informatica PowerCenter for their Claims, Health Care Department.
• Developed Complex mappings in Informatica load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Sequence Generator, Joiner, Union, Filter, Update Strategy, Rank and Router transformations.
• Created Informatica Mappings to load Member, Provider, Contract, Claims & Services data for State health plans
• Created Informatica Mappings to load data for Power Account Payments, Statements, and Claim Card Transaction for Indiana (HIP Members) there tables are used to generate monthly statements which will be sent to the member in the plan (Excluding Conditionally eligible members)
• Source and Target databases resided on Oracle.
• Worked on Informatica Power Exchange for Real-Time Processing.
• Conducted design review meetings with the senior architect for any new requirement to get the approval and designed the mappings according to the company standards.
• Responsible for Informatica Administration using Repository manager.
• Worked with Informatica Labels and Queries, Dynamic and Static Deployment groups.
• Created deploy components to TEST and PROD.
• Used JIRA to access all the CR's (Change Request's)
• Well versed with Informatica Team based development (Versioning)
• Used Informatica versioning to check in and check out the objects in designer and workflow manager.
• Performance tuning, bug fixing and error handling.