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.
• 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 Developer

Responsibilities:

• Design, develop and test complex ETL code as per user requirement/ stories.
• Develop Technical Design Documents as per Enterprise DataWarehouse requirements.
• Assist Data Architect during design phase and ensure data model meets ETL and Business Requirements.
• Ensure schema supports the ETL jobs and meets performance and Data Capacity requirements.
• Create ETL architecture documents for entire project team.
• Provide guidance to testing team for creating test scripts.
• Schedule jobs as per requirement using Autosys and Control-M.
• Manage end user Business Intelligence needs.
• Assist the team in creating DDL and patch requests across environments.
• Provide implementation support and creating of environments.
• Improved the Query Performance by applying new techniques and removing wasteful processing of data by identifying and removing dormant and redundant data throughout the Data Warehouse.
• Provide inputs to project manager on timeline of deliverables.
• Break down entire project into sprints and provide assistance to the Project Manager on planning.
• Develop support document for proper transition of jobs to support teams.
• Assist in code migration using Repository Manager.
• Manage conflicting requirements and identify priority of work

Environment: Informatica Power Center 9.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:

• Involved with the Business analysts in requirements gathering, and business analysis
• Created Profile report used IDQ to know weakness and strengths of source data and also created Scorecards.
• Understand existing DQ landscape to provide key insights on the scope and magnitude of DQ issues and supporting Processes and procedures
• Assist in the design of an efficient reliable ETL mechanism for updating the data warehouse, data marts and downstream systems.
• Involved in preparing the Design Specifications for ETL Coding and mapping standards.
• Analyzed various Source Systems for Implementation.
• Worked Extensively on Informatica tools Repository Manager, Designer and Workflow Manager and Workflow Monitor.
• Identified data quality issues, anomalies, patterns, based on defined business rules and created metrics and score Cards by IDQ Profiling.
• Designed Source to Target mappings to extract data from heterogeneous sources such as Oracle, Flat files, DB2 as source and load it to the target tables.
• Involved in creating the backup of the repository.
• Worked with various transformations such as Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator, Rank.
• Configured and used the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• 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.
• Extensively performed unit testing and coordinate for system testing and functional testing.
• Helped to generate Report using Business Object.

Environment: Informatica Power Center 8.6, IDQ, 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:

• Used Informatica Power Center 8.1.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads
• Worked with slowly changing dimension Type1, Type2, and Type3.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created reusable transformations and mapplets and used them in mappings.
• Extracted data from flat file, RDMS, Legacy AS400, and VSAM files.
• Implemented Informatica recommendations, methodologies and best practices
• Created sessions, workflows and worklets using workflow manager.
• Worked on Informatica Designer to modify mappings to update the existing code resulting from review comments.
• Used Expression, Normalizer, Update strategy transformations.
• Worked on Lookup, Router, Unoin, Joiner Transformations.
• Involved in Unit testing, and running workflows.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Worked extensively with the business intelligence team to in corporate any changes that they need in the delivered files.

Environment: Informatica 8.1.1, (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), 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.