SUMMARY

• 7+ Years of experience in IT industry including expertise in design and development of Relational Database Systems, Design and Development of Data Warehousing using Informatica Power Center ETL tool.
• Extensively worked on data warehousing concepts using various ETL tools like Informatica and SSIS.
• Experience in ETL tool, INFORMATICA (V 7.x & V 8.x). Experience in Using Repository Manager, Designer and Workflow Manger, Workflow Monitor Tools in Informatica Power Center.
• Extensive understanding of Transactional and Dimensional Data Modeling, Data Ware house concepts and Designing Star schemas & Snowflake Schemas for OLAP Systems.
• Developed Slowly Changing Dimension mappings of Type1, Type2 and Type3 (version, flag and time).
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping, Session and System in ETL Process.
• Strong experience in developing complex mappings using transformations like Unconnected and Connected Lookups, Router, Aggregator, Sorter, Joiner, Transaction Control, Filter and Update Strategy.
• Expertise in data extraction from Flat Files (XML, excel, csv, fixed width, delimited, txt), and Oracle server.
• Good experience in handling terabytes of data and good at analyzing the data related issues.
• Extensively worked on oracle warehouse builder tool. Supported customizations and testing.
• Created various tasks like sessions, and workflows in the workflow manager to test the mapping during development.
• Hands on experience on SQL and PL SQL concepts. Working experience on oracle server.
• Extensively worked on performance tuning areas. Good knowledge on partitions, indexes, table space related issues.
• Good at analyzing AWR (Automatic Workload Repository) report and good in providing suggestions on SQL tuning techniques using explain plans.
• Worked with Teradata including loading targets, executing SQL and troubleshooting and optimization of ETL components.
• Good working experience on partition exchange load process (offline data loads) in oracle.
• Strong experience working with Microsoft business intelligence including SSIS, SSAS, SSRS.
• Good in suggesting the performance tuning techniques to increase the data load through put.
• Implement UNIX shell scripts for scheduling various tasks.
• Strong Knowledge in ETL design document and mapping sheet creation.
• Good in scheduling jobs and administration activities.
• Proficient in understanding Functional Requirements and Design documents.
• Good in creating HLD and other design documents as needed.
• Extensive expertise in designing, developing and executing test scenarios and test cases.
• Worked predominantly in billing systems.
• Possess good communication skills and effective client communication.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutionsleading to high customer satisfaction.
• Self - learner and highly self-motivated attitude.
• Knowledge of Change Data Capture (CDC) using Oracle 9i and Informatica Power Exchange.
• Followed effectively industry standards of HIPAA, ANSI837 and PHI concepts.
• XML source and target schema and object definitions.

TECHNICAL SKILLS

ETL/DW Tools: Informatica Power Center 9.5.1/9.1/9.0/8.6.1/8.6/8.5.1/8.1/ 7.1.3/7.1.1/6.2 (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor), SQL Server Integration services.

Data Modeling Tools and Reporting tools: TOAD, Rapid SQL, Teradata, SSRS, Tableau server, Crystal Reports 9.0/8.5.

DBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2008R2/2012/2014, Teradata.

Languages: SQL, PL/SQL, T-SQL, HTML, XML, C, C#, ASP.NET

Operating Systems: Windows Server 2003/2008/2012 , UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Springfield, Ohio

Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 8.6.1, Oracle 10g/ 9i, MS-SQL Server, Toad, HP Quality Center, Windows XP and MS Office Suite, SSIS

Confidential, Raleigh, North Carolina

Informatica Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Delimited Flat files.
• Development of ETL using Informatica 8.6.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Interaction with the offshore team on a daily basis on the development activities.

Environment: Informatica Power Center 8.1, Oracle 9i, MS-SQL Server, PL/SQL Developer, Windows XP,TOAD, MS Office and Delimited Flat files, SSRS

Confidential, Omaha, Nebraska

Informatica Developer

Responsibilities:

• Member of warehouse design team assisted in creating fact and dimension tables based on specifications provided by managers.
• Load operational data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Rank, Union, Normalizer, Sequence Generator, and Router Transformations
• Created complex mappings that involved implementation of Business Logic to load data in to staging area
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Building Reports according to user Requirement by using SSRS.
• Implemented effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Design complex mappings involving constraint based loading, target load order.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Worked on Informatica Schedulers to schedule the workflows.

Environment: Informatica Power Center 6.2, Oracle, Business Objects 6.x, Windows 2000, SQL Server 2000, Microsoft Excel, SQL * Plus, MS SQL, SSRS

Confidential

Informatica Developer

Responsibilities:

• Designed and developed the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling, system testing, performance tuning.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.
• Stored reformatted data from relational, flat file, XML files using Informatica (ETL).
• Worked on Dimensional modeling to design and develop STAR schemas using ER-win 4.0, Identifying Fact and Dimension Tables.
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Created post-session and pre-session shell scripts and mail-notifications
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Created Several Stored Procedures to update several tables and insert audit tables as part of the process.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• Written Unix Shell Scripts for getting data from various source systems to Data Warehouse.
• Performance tuningby optimizing the sources targets mappings and sessions.
• Tested mappings and sessions using various test cases in the test plans.

Environment: Informatica 6.2, Oracle 8i, TOAD, Windows NT and UNIX

Confidential

Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extensively used Informatica Client tools -PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata
• Developed complex mapping using Informatica PowerCenter tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformation, Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA)
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Environment: Informatica Power Center 9.1.0/8.6.1 , Flat Files, Mainframe Files, Oracle 11i, Quest Toad Central 9.1, Oracle 11, SQL Server 2008, Web services, Autosys