SUMMARY:

• Over 6 years of strong Data Warehousing experience using Informatica Power Center 9.x/8.x/7.x(Source Analyzer, Mapping Designer, Mapplet Designer, Transformation developer) with Oracle, DB2, Teradata and MS SQL databases.
• Extensive experience in Extraction, Transformation and Loading(ETL) of data using Informatica from heterogeneous sources.
• Experience in Designing and developing the complex mappings from various Transformations like Source Qualifier, Joiner, Aggregator, Router, Filter, Expression, Lookup, Sequence Generator, Java, Update Strategy and etc.
• Extensive experience in Banking, Insurance, Health and Retail domains.
• Knowledge on Installation, Configuration, and Administration of Informatica Power Center Client/Server.
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment.
• Extensively worked with SCD Type - I and Type-II dimensions and data warehousing Change Data Capture (CDC).
• Expertise in Health care domain like Medicare, Medicaid and Insurances compliance with in HIPAA regulation and requirement.
• Extensively worked with SQL Stored Procedures, Triggers, packages, and functions and also involved in Query Optimization in Oracle.
• Good exposure to Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
• Knowledge on Business intelligence tools like Business objects, SQL BI, Crystal Reports, OBIEE.
• Created UNIX Shell scripts for Informatica post and pre session operations.
• Excellent communication and interpersonal skills. Ability to work effectively while working as a team member as well as individually.
• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams .

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x, Power Exchange, Informatica Data Quality, IDE, B2B Data Transformation Studio.

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008, MS-Access, DB2 UDB, Teradata

BI Reporting Tools: Oracle Business Intelligence (OBIEE 10.x), Dashboards, BI Publisher, BI Administration.

Languages: SQL, PL/SQL, Java, C, JavaScript, HTML, UNIX Shell Script, Visual Basic 6.0

Data Modeling Tools: MS Office Suite, MS Visio, Erwin Data Modeler 4.1, UML.

Web: Oracle Apex, Microsoft Front-page, HTML and XML.

Operating Systems: Windows 7/8/10, UNIX, Linux.

Scheduling Tools: Autosys 11, Crontab, Tivoli, Tidal

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Informatica ETL Developer

Responsibilities:

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extracted the data from the flat files and other RDBMS databases into staging area, integration area and populated onto Data warehouse.
• Created mapping documents to outline data flow from sources to targets for Transformed Medicaid Statistical Information System (TMSIS) and Management Administrative Reporting Subsystem (MARS) .
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, lookups and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Used Debugger to test the mappings and fixed the bugs.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Timer and Scheduling of the workflow.

Environment: Informatica Power Center 9.6, Oracle, Unix.

Confidential, Raleigh, NC

Informatica ETL Developer

Responsibilities:

• Monitored day to day Loads, addressed and resolved production issues in an abrupt and timely manner and provided support for the ETL jobs running in production .
• Worked on Autosys to automate running of Informatica Workflows on a daily Batch Jobs.
• Coordinated and interacted with other teams to maintain integrity in performing the tasks and execution of the loads appropriately in a timely manner.
• Maintained repositories and performed Admin level tasks such as creating Folders, Users, Connections & assigning proper roles and privileges.
• Involved in Data Extraction from Oracle and Flat Files and developed mappings using Informatica Power Center.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Created the test cases and captured unit test results.
• Involved in Creation of SQL, Packages, Functions, Procedures, Views, and Database Triggers.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database.
• Developed and tested all the informatica mappings, sessions and workflows involving several tasks.

Environment: Informatica Power Center 9.6, Teradata 13x,DB2,PL/SQL,Oracle, ERwin r7.x,Autosys,PL SQL, UNIX, Metadata.

Confidential, Raleigh, NC

Informatica ETL Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created and monitored Batches and Sessions using Informatica PowerCenter Server.
• Tuned the mappings to increase its efficiency and performance.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Mappings were developed in Informatica employing transformations like Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Involved in production support which also includes trouble shooting of connectivity issues
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Environment: Informatica PowerCenter 8.5, Oracle 10g,DB2 UDB, SQL, PL/SQL, Shell Scripts, UNIX (AIX).

Confidential

Informatica ETL Developer

Responsibilities:

• Developing the mappings, sessions and workflows with by considering all dependencies and maintaining all project standard.
• Performing Unit Test and preparing the Test Cases for all possible scenarios.
• Actively participating in weekly status meeting and answering all question asked by client.
• Responsible for Deployments of all developed code and providing on call support along with WebEx meeting while deploying the code.
• Responsible for performance tuning at various levels like mapping level, session level and database level
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Environment: Informatica Power Center 6.2.1, Oracle 9i, Windows.