SUMMARY:

• Over6years of IT experience with extensive Data Warehousing implementations across healthcare, Financial, Pharmaceutical and Product based Industries usingInformatica Power Center 9.x/8.x/7.x/6.x and Oracle Database.
• 4+ years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center with client tools like Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer), Repository Manager, Workflow Manager and Workflow Monitor.
• Experience in all the phases of Data warehouse life cycle involving Requirement gathering, Implementation & Design, Development, Testing and Deployment.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Designed complex ETL mappings like slowly changing dimensions, performed critical performance tweaking stages with partitioning, persistent cache and extensive use of mapplets.
• Strong knowledge of Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables.
• Experience in integration of various relational and non-relational data sources like Oracle, SQL Server, and Flat Files into staging area.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Event Wait, Event Raise, Timer etc).
• Expert knowledge in Performance Tuning, identifying and resolving performance bottlenecks in various levels such as source, mapping, target and sessions to provide maximum efficiency and performance.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Experience in writing, testing and implementation of the PL/SQL packages, triggers, stored procedures and functions.
• Good understanding of Relational Database Management Systems (RDBMS) like Oracle 8i/9i/10g/11g.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Involved in Unit testing, Integration testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by attending meetings with the clients in Requirements gathering phase.
• Coordinated and provided technical oversight to onshore and offshore team to implement the project.
• Excellent analytical/ communication skills and good team player.

TECHNICAL SKILLS:

Informatica Power Center 9.x/8.x/7.x/6.x

Languages

SQL, PL/SQL, HTML, XML, C

Databases

Oracle11g/10g/9i/8i/7i, MS SQL Server 2008/2005/2000

Operating System

Windows 9x/NT/2000/XP, UNIX, Linux, MS-DOS

Tools/Utilities

SQL*plus, SQL Developer, Toad 5.x/6.x/7.x/8.x/9.x

Scripting

UNIX Shell Script

PROFESSIONAL EXPERIENCE:

Confidential,NY Aug’11 – Till date

Role: ETL Developer

Responsibilities:

• My main responsibility was to resolve issues related to data warehouse, Stored procedures and analyzed, design and developed ETL strategies.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Worked with heterogeneous source to Extracted data fromOracle database, XMLand flat files and loaded to a relational Oracle warehouse.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Performed tuning of+ SQL queries for speedy extraction of data to resolve and troubleshoot issues in SIT environment.
• Trouble shooting of long running sessions and fixing the issues.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Involved in the development of PL/SQL stored procedures and functions to process business data.
• Worked with the testing team to resolve bugs related to ETL mappings that our team created.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.

Environment:Informatica PowerCenter 9.1.0, Oracle 11g, XML, PL/SQL, SQL Developer

Confidential,GA Aug’09 – July’11
Role: ETL Developer

Responsibilities:

• Involved in all the phases of project (gathering requirements, preparation of detail design, development, testing and production support).
• Partnered with the Information Architect to translate the Dimensional Data Model to the ETL Code (mapping, mapplets, workflows) using the Informatica PowerCenter and optimize ETL data load jobs to improve performance.
• Identified ETL specifications based on Business Requirements/Mapping Document.
• Extracted source data fromOracle database, XMLand flat files and loaded to a relational Oracle warehouse.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Used Workflow Managerto create connections,sessions, tasks, workflows and createdEvent wait, Event Raise, Timer and Control Eventsin a single master workflow according to the business requirements.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Implemented slowly changing dimensions both (Type 1 and Type 2).
• Creating/building and running/scheduling workflows and worklets using the Workflow Manager.
• Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Worked with BI team to Develop Reports / Dashboards with different Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Web.
• Performed tuning of SQL queries for speedy extraction of data to resolve and troubleshoot production Issues.
• Involved in the development of PL/SQL stored procedures and functions to process business data.
• Used Toad to debug the SQL queries to identify duplicate rows in the warehouse tables, and to debug SQL queries issued during report execution.
• Closely interacted with the testing team to resolve bugs.
• Co-ordinate with onshore and offshore development team to implement the project.
• Involved in meetings with production team for issues related to maintenance, future enhancements, backup and crisis management of DW.
• Used UNIX shell scripts to automate repetitive database processes, file transfers and job scheduling.

Environment:Informatica PowerCenter 8.6.0, Oracle 11g, OBIEE 10.1.3.2, XML, PL/SQL, Toad 8.1, Unix shell scripts.

Confidential,AL Jan’07-Jun’09
Role: Informatica Developer
Responsibilities:
Informatica Power Center was used to extract, transform and load data from different operational data sources like Oracle, SQL server, DB2, Flat files in to Data staging area (Oracle).

• Developed complex mappings with various Informatica transformations like Aggregator, Lookup (Connected, Unconnected), Source Qualifier, Update Strategy, Router, Joiner, Filter and Expression.
• Involved in admin tasks like analyzing Table Space requirement, load balancing and Performance
• Wrote the complex SQL queries to retrieve the data from different sources to validate.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
• Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning, Push down optimization technique and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks.
• Extracting Incremental data (Change Data Capture) from Source Systems using Informatica Power Exchange.
• Experienced with Dimensional Data Modeling Techniques like Star Schema, Snowflake Schema, Surrogate Keys, Conformed dimensions and slowly Changing dimensions modeling design.
• Used Informatica Tool, Business Objects Data Integrator to integrate Data from Excel files, UDB, Legacy Data providers and third party vendors for the large volumes of data.
• Wrote UNIX (IBM-AIX) shell scripts and ran as Pre-Session, Post-Session scripts.
• Developed Business Objects Universe, Reports for various Balance Scorecards, Reports for monthly, Quarterly, Yearly, Charts, Bar Graphs, Drill Down reports and Trend Reports.
• Prepared test data for data driven tests for testing the application dynamically.
• Reviewed computer logs (UNIX logs & Shell Scripts), reported program-processing errors.
• Used Autosys to schedule the jobs.
• Assisted in updating the logical model with all related entities, attributes and relationship with each entities based on the rules provided by the business manager using Erwin 4.0.

Environment: Informatica Power Center 8.0/7.1.3, Erwin 4.0, Power exchange, CDC, Windows 2000, Oracle 9i/8i, SQL Server 2000,PL/SQL, Sybase 11.x, Mainframes, DB2, Flat file, Erwin, TOAD, AIX, Autosys, Unix, Linux

Confidential,CA July’06-Dec’06
Role: ETL Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Read\\Wrote XML Messages from\\to MQ Series Queues and worked extensively with XML Parser (XSD) and XML Generator Transformations.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
• Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Validation of Informatica mappings for source compatibility due to version changes at the source.
• Trouble shooting of long running sessions and fixing the issues.
• Implemented daily and weekly audit process for the Claims subject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
• Involved in writing SQL scripts, stored procedures and functions and debugging them.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them. Helped them in creating canned reports.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica PowerCenter 8.6.1,PowerExchange 8.1, Oracle 10g/11g, SQL Server 2005, DB2, Mainframe, XML, Unix, Erwin.