• 8 years of Experience in analysis, design, development, implementation and troubleshooting of Data Mart / Data Warehouse applications using ETL tools like Informatica PowerCenter9.x/ 8.x/7.x/6.x.
• Experienced in Implementing and Delivering project using industry best practice and exposed to Software Development Methodologies like Software Development Life Cycle SDLC .
• Experience in working with Business Users to understand and analyze project requirements and to co-ordinate work efforts with multiple teams.
• Expertise in using methodologies for data extraction, transformations and loading processing in corporate-wide ETL solutions using Informatica Power Center 9.x/8.x/7.x/6.x. on UNIX and Windows platform.
• Experience in Integration of various data feeds from sources like Oracle, SQL Server, Flat Files and XML Files.
• Adept in writing UNIX shell scripts and Windows Batch Scripts
• Extensive experience in all phases of Data Warehouse project life cycle.
• Proficient in the development of ETL Extract, Transform, Load processes with a good understanding of source to target data mapping, ability to define, capture meta data and business rules.
• Experienced in designing, developing, testing, and performance tuning and debugging of existing ETL processes.
• Extensively developed real time and near real time BI systems using the informatica ETL tool and OLAP reporting tools.
• Experience in working with reporting tools like Cognos, Business Objects and OBIEE.
• .Working knowledge and understanding of Dimensional Data Modeling using Star Schema, Snowflake modeling, FACT Dimensions tables, Physical logical data modeling using ERWIN 4.x.
• Knowledge about Kimball and Bill Inmon modeling approaches.
• Experience in Implementation of slowly changing dimensions methodology to keep track of historical data.
• Experience in implementing complex business rules by creating optimized and efficient mappings with appropriate transformations.
• Knowledge in creating database objects like procedures, views, packages, functions and triggers using PL/SQL.
• Proficient with TOAD 9.6.1, SQL assistant queryman TTU 8.0, Oracle SQL Developer 2.1.1.64 Win Unix interface.
• Developed scheduling charts and scheduled shell scripts, Informatica ETL mappings and reports using Autosys. Provided integration and post production support for ETL and reporting systems.
• Experience in creating the label and Migration of code to different environments.
• Experience in ETL implementation and Production Support.

TECHNICAL SKILLS

• Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2
• Data Warehousing: Informatica Power Center 9.1.0,8.6.1/8.5/8.1.1/7.1.3/7.1.1/7.0, ETL, Datamart, OLAP, OLTP
• Databases: Oracle11g/10g/9i/8i, IBM DB2 UDB 8.0/7.0,MS SQL Server2005/2000/7.0/6.0,
• Scheduling Tools: AutoSys, Control M, TIDAL,
• Others: Java, C, XML, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus, ODBC, Quest TOAD

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

• Create ETL mappings and database objects to load source data in to PINIA Power Information Network Integrated Analytics warehouse and PIN Explorer datamart.
• Co-ordinate with source teams from ADVENT, CTSOFT, DATA CONSULTANTS, DEALER TRACK and REYNOLDS for any data inconsistencies, transfer/FTP issues.
• Write adhoc SQL queries to generate data from tables based on requirements.
• Modify existing mappings and workflows to accommodate changes as suggested by business.
• Informatica transformations like lookup, Joiner, Update Strategy along with others were used for data processing.
• Understand and develop resolutions for any data cleansing or code issues that could hinder the DSS efficiency.
• Created extensive mapping/mapplets, reusable transformations using all the transformations like Normalizer, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.
• Ability to work on performance issues by accessing both Informatica and Oracle logs to increase process efficiency.
• Experience using Metadata Manager and Data Analyzer to generate ETL run reports which were used to understand the process performance and overall job schedules.
• Create scheduling jobs using TIDAL scheduler to start data processing and to send success/failure notification alerts.
• Co-ordinate weekly QA and production release activities.
• Raise CCB tickets using e-help portal for data refresh and other maintenance requests.
• FTP and encryption experience.

Environment: Informatica 9.1.0., Oracle 10g, UNIX, Oracle Data Integrator, Oracle 11g, SQL, TOAD 8.6, Erwin

Confidential

ETL Developer

• Worked on the maintenance and enhancements for VMware Entitlements related data mart.
• Co-ordinated monthly roadmap releases to push enhanced/new informatica code to production.
• Developed and maintained ETL Data Extraction, Transformation and Loading mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
• Created mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache
• Performed Impact Analysis of the changes done to the existing mappings and provided the feedback
• Create mappings using reusable components like worklets, mapplets using other reusable transformations.
• Participated in providing the project estimates for development team efforts for the off shore as well as on-site. Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project

• Worked on Informatica Source Analyzer, Mapping Designer Mapplet, and Transformations.

Environment: Informatica 9.1.0., Oracle 10g, UNIX, Oracle Data Integrator, Oracle 11g, SQL, TOAD 8.6, Erwin

Confidential

ETL Developer

Responsibilities:

• Design and develop Informatica mappings to address business requirements to bring in the SOR data in to the customer data ware house using flat files from different LOB's.
• Developed mapping to bring in new attributes to existing data load, and to set up a completely new data feeds load.
• Managed application support along with off-shore technical team.
• Inbound Inproc Indone Outbound kind of architecture.
• Prepare and update SIA documents required for new and existing feeds.

• Co-ordinate and validate the upgrade of all CUSTDW database environments from Oracle 10g to 11g.
• Testing of database packages developed using PL/SQL.
• Develop and deploy autosys jil code to all environments.
• Work on the existing issues and any development efforts queued in the CUSTDW share point website.
• Maintain and manage share point site for CUSTDW
• Co-ordinate efforts for CUSTDW BCP Cassie Hill exit project, which include partner notifications and providing any technical solutions required for smooth transmission.
• Provide weekly status updates to both business and technical teams.
• Raise work requests/change requests to move Informatica, autosys code from lower environments to Production and BCP.
• Provide technical reports to manager on any Informatica related production runs using Data Analyzer.
• Notify and follow up with all the partners to use common domain names service for CUSTDW so that the failover and any other database changes are transparent and require less effort in the future.
• Co-ordinate and support annual BCP failover activity for CUSTDW production database.
• Pager support on any production failures and emergencies.

Environment: Informatica 9.1.5., Oracle 11g, UNIX, TOAD 8.6, Erwin, Pac 2000, Autosys 4.5

Confidential

Sr ETL Developer

Responsibilities:

• Involved in designing the mapping logics to access data from various source systems, like EBS, ELOQUA, SFDC, UCM and DNB.
• Used ERWIN to design the Logical/Physical Data Models, forward/reverse engineering.
• Applied Dynamic Parameter file concept to implement incremental logic to extract from sources and load to Datamarts.
• Worked on user interfaces like VMDash and Webflash designed for VMware using OBIEE
• Prepared ETL Design specification documents with the help of Data modeling team. ETL Design specifications were further used by the ETL Development team to create Informatica mappings
• Experience using Data warehouse Administration Console DAC to schedule and monitor the jobs.
• Informatica set-up on grid environment was used for efficient processing.
• Analyzed session log files in case the session failed to resolve errors in mapping or session configurations
• Worked directly with Informatica Global Support to raise SR's to understand and resolve the Master Thread issue.
• Oracle warehouse builder OWB was used to monitor and maintain few ETL jobs.

• Co-ordinated with multiple teams for resolving data and environmental set up issues.
• Worked extensively with off shore development and support teams to address any code issues.

Environment: Informatica 9.1.0., Oracle 11g, Oracle 10g, SQL, UNIX, Oracle Data Integrator, Oracle DAC, TOAD 8.6 ,Erwin

Confidential

ETL Developer

Major Responsibilities

• Created documents when user raise a problem on existing production application, provided best solution to resolve the problem in short time and with better performance.
• Responsible for Production Applications giving support 24/7 once in every four weeks.
• Involved in using Informatica slowly changing dimensions concept to maintain historic information.
• Debugging and performance tuning of the mappings.
• Created and updated parameter files.
• Created sessions using mappings to start the load process on time basis. Configured email notification.
• Extensively used Informatica PowerCenter to extract/load data from/into Oracle tables/SQL Server to Oracle/flat files.
• Extract and load in to tables from both Star and Snow Flake Schemas.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner transformations.
• Involved in creation and updates of several SQL packages and Procedures.
• Tuned SQL Query for optimization in Oracle stored packages using Explain plan and Auto trace.
• Involved in weekly change control meetings, explain about the problems, enhancements done to the existing application, giving idea about the impact of these changes on other applications.
• Analysis of new projects, estimation, programming and testing of programs.
• Involved in gathering user requirements and preparing functional and technical documents.

Environment: Informatica 8.6.1, Oracle 10g, HP-Unix, PL/SQL, App Worx, Citrix

Confidential

ETL Developer

Responsibilities:

• Created sessions using mappings to start the load process on time basis. Configured email notification.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Server manager.
• Generated completion messages and status reports using Server manager.
• Involved in creation and updates of several SQL packages and Procedures.
• Clear Case, PVCS are used for version control. Interacting with business users to get form, reports, package, procedure, and function requirements.
• Tuned SQL Query for optimization in Oracle stored packages using Explain plan and Auto trace.
• Extensively used Informatica to analyze the Source, to design a Data Warehouse project.
• Mapping designer was used to create the mapplets, map tables from source to target.

Environment: Informatica 8.5, Oracle 10g/9i, PL/SQL, UNIX, Korn Shell, Toad PL/SQL tool

Confidential

Data Warehouse Developer

Responsibilities

• Worked on Informatica Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, and Transformations.
• Involved in the development of Informatica mappings and also tuned them for better performance
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Worked on migration, validation, massaging procedures while migrating data from MS-Access to Oracle Database.
• Using Toads Explain Plan features found the weak SQL queries.

• Used most of the transformations such as the Source qualifier, Aggregators, lookups, Filters Sequence.
• Extensively used ETL techniques to load data from MS SQL Server 7.0, Oracle 8i and flat files to Oracle Database. Created Views Schemas for the Application as a part of data modeling.
• Worked on database procedures, functions and packages

Environment: Oracle 8.0, Designer 2000, Informatica 7.1, XML, PL/SQL, UNIX