SUMMARY

• Over all 8+ years of Data Warehousing experience using Informatica Power Center 7.1.3/8.6.1/8.1.1/9.1.0 , Oracle 10g/11g, SQL, PL/SQL, UNIX and DB2.
• Around 2 Years of Strong experience on Designing, testing, deploying, and documenting the data quality procedures and their outputs in Data Quality and Data Analysis using with Informatica IDQ/IDE 8.x/9.1/9.5
• Used IDQ (Informatica Data Quality) to extract, transform and load (ETL) rules and source - to-target mappings to derive additional business rules for data quality checks.
• Have good understanding on Latest Informatica Power Center 9.5 and its added features.
• Experience in Information Technology with strong business understanding into different domains like Banking, Insurance, Finance, Pharmaceuticals-Healthcare and Telecom Sectors..
• Experience in performing ETL procedures to load data from different sources like Oracle 9i/10g, DB2, XML Files, Flat Files, MS SQL Server and MS Access into Data marts, Data warehouse using Informatica Power Center.
• Experience using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g and Oracle BI Apps.
• Build custom profiles using IDQ to analyze the data and also run scorecards.
• Used different Data Quality transformations like Standardizer, parser, Match, etc. in the mappings.
• Proficient in performance tuning of Informatica Mappings, Transformations, and Sessions; experienced optimizing query performance.
• Experience in Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDE/CDC/ SCD (Type1/Type2/Type3) loads.
• Experience in writing PL/SQL functions using PL/SQL developer.
• Database experience using Oracle 10g/9i/8.x/7.x, MS SQL Server 2000 and MS Access.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse
• Proficient in Performance Tuning of Informatica Mappings, Transformations, Sessions and experienced optimizing query performance.
• Used complex Informatica transformation like Normalizer, Transaction control, UDF’s and SCD’s (Type 1, Type 2 and Type 3).
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML, and Mainframe into Warehouse.
• Implementation and Support of various OLTP, Data Warehousing, and OLAP applications
• Experience working in Oracle8i/9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, and indexes.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center (Source Analyzer, Repository Manager, Data warehousing designer, Mapping Designer, Mapplets, Transformations, Work flow Manager, Task Manager).

Reporting Tools: Business Objects, BO Web Intelligence, Xcelsius 2008.

Databases: Oracle 10g,8i,9i

Languages: SQL, PL/SQL, MS-Excel, Unix Shell Scripting.

GUI Tools: SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Boston

Senior Informatica IDQ

Responsibilities:

• Created Profile report used IDQ to know weakness and strengths of source data and also created Scorecards.
• AppliedInformaticaData Quality standards, guidelines and best practices on the various sources.
• Developed (mappings, workflows, Logical data object, Profiling, Scorecards), and automated entire process.
• Understand existing DQ landscape to provide key insights on the scope and magnitude of DQ issues and supporting Processes and procedures.
• Involved inconceptual, logical and physical datamodeling and used star schema in designing the data warehouse
• Identified key data sources that are in-scope, validating/defining critical data elements and business rules.
• Optimized theperformance of the Informatica power center mappingsby various tests on sources, targets and transformations. Identified theBottlenecks, Removed the Bottlenecksandimplemented performance tuning logicon targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Exported the valid and invalid documents to data stewards and business analyst to understand the data.
• Applied the Completeness, Conformity, Integrity, Timeliness, Synchronization/Consistency to Create the Scorecards, trend charts.
• Identified data quality issues, anomalies, patterns, based on defined business rules and created metrics and scoreCards by IDQ Profiling.
• Applied data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities in IDQ(Informatica data quality)
• Applied all the created rules in IDQ profile to get scorecards to analyze the business users and data stewards.
• Cleansed, standardized, labeled and fix the data gaps in IDQ where it checks with reference tables to fix major business issues.
• Performed tuning of Informatica Mappings and sessions for optimum performance.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
• Developed and worked with SQL and PL/SQL scripts, UNIX script in coordination with pmcmd to start/stop workflows.

Environment: Informatica Power Center 9.5.1.0, IDQ, IBM AIX/Linux, Oracle 10g/11g, MS SQL Server 2005/ 2008, Mainframe, Autosys, Crystal Enterprise, Data Vault Methodolgy.

Confidential, Dublin, OH

Informatica/ETL Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Analysis of production issues and designed the detailed solution.
• Performed performance tuning at functional and map level for better production performance.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables and relational connections.
• Used Debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.
• Used various transformations like expression, transaction control, aggregator, Router, Unconnected Lookup, Filter, and Sorter.
• Worked on slowly changing dimensions.
• Created new mapping design using various tools in Informatica designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Involved in extracting the data from flat files and relational databases into staging area.
• Prepared Technical design documents and test cases and also performed unit testing.
• Used Teradata as source system.
• Extensively worked on SQL server and developed complex T-SQL Queries
• Implementation of Scrum methodologies/ SDLC framework to support the efficient development of project.

Environment: Informatica Power Center 8.6, UNIX (Sun Solaris 2.6), Windows NT, LINUX, Teradata v12, Oracle 10g, DB2 9.5, PL/SQL, Toad, Business Object 5.1, Autosys.

Confidential, Birmingham, Alabama

ETL Developer

Responsibilities:

• Actively involved in understanding business requirements, analysis and design of the ETL process.
• Used Informatica Power Center to extract, transform and load data from various source systems to staging and target Data warehouse.
• Used Power Center Workflow Manager for session management, database connection management and scheduling of jobs to be done in batch process.
• Created fact and dimension tables based on specifications provided by managers using Star Schema.
• Designed and created complex source to target mappings using various transformations like Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• 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.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail of the workflow.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Written UNIX scripts to transfer the data from operational data sources to the target warehouse.
• Developed PL/SQL procedures, functions, triggers for processing business logic in the database. Wrote optimized SQL queries for data retrieval from the source database.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the shells scripts.
• Monitoring the session logs to check the progress of the data load.
• Working with an Agile, Scrum methodologies to ensure the delivery of high quality work.
• Involved in different Team review meetings.

Environment: Informatica 8.1.1, (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Teradata 12, Erwin, Oracle 10g, Windows XP, Sun solaris UNIX, DB

Confidential, Reston, VA

ETL Developer

Responsibilities:

• Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL Architecture using Informatica.
• Interacted with Source system SME’s to analyze how various business processes have been tracked across the source tables.
• Designed Data warehouse target tables by using Dimensional Modeling Techniques - Star and Snowflake Schemas. Created Dimensions and Fact tables using Erwin.
• Extracted data from various data sources such as Oracle, Flat file, XML, DB2 and transformed and loaded into targets using Informatica.
• Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Designed and developed initial and incremental data loads using Informatica.
• Designed and Developed several mapplets and worklets for reusability.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Developed sessions using different types of partitioning techniques like round robin, hash key portioning for better performance.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Created Shell scripts with PMCMD command and scheduled using Maestroscheduler for nightly batch processing.
• Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Provided Nightly batch loads support and implemented solutions to correct the data issues raised by end user during production support phase of the project.

Environment: Informatica Power Center 8.1, Oracle SQL, Pl/SQL 10g, Toad, Unix Maestro, XML, Flat file, Erwin, AS 400 DB2, Windows XP, UNIX, Shell Scripting.

Confidential, CT

ETL Developer

Responsibilities:

• Worked Extensively on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from SQL Server and load to Oracle database.
• Involved in Data modeling and Design of star schema with confirmed and granular dimensions and FACT tables.
• Extracted Erwin physical models into repository manager using Informatica.
• Extensively used transformations such as Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Look up (Target as well as Source), Update Strategy, Source Qualifier, Stored Procedure and Joiner.
• Responsible for using the capabilities of Power Center namely list files, pmcmd, pmrep, Target override, Connected and Unconnected look up, Persistence lookup, Dynamic & Static lookup.
• Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• Involved in fixing repository related, Reader process and External procedure problems.
• Identified and tracked the slowly changing dimensions(SCD), heterogeneous Sources and determined the hierarchies in dimensions.
• Developed Informatica Mappings, Re-usable Transformations, re-usable mappings and Mapplets for data load to data warehouse and database (oracle)
• Set up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Involved in writing Triggers on the source to attain Power center change data capture(CDC).
• Extensive use of SQL commands with TOAD environment to create Target tables.
• Perform review of Session log files to trace causes of bottlenecks.
• Created Unit Test plans and involved in primary unit testing of mappings
• Designed and developed a strategy for a specific and vital reporting need. Emphasis was on a design to support current and historic reporting. Data loading mappings were developed in Informatica.

Environment: Informatica Power center 7.1.2(Source Analyzer, warehouse designer, Mapping Designer, Mapplet, Transformations, Repository Manager, Work Flow Manager, Workflow Monitor, Oracle Power Connect), UNIX, Oracle 9i (SQL Plus, PL/SQL), SQL Assist 6.1, Win NT

Confidential

ETL/Oracle Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using stored procedures into the database. Involved in Logical and Physical modeling of the drugs database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL*Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Oracle 8i, SQL, PL/SQL, Windows 2000.