SUMMARY:

• Over 8 years of IT experience in designing, implementation, development and maintenance of Data Warehouse Systems, Data Marts and large-scale client/server applications with extensive experience in ETL Process using Informatica Power Center 9.x.x/8.6.1/8.1.1/7.x.
• Involved in Development of Data Warehouse, Business intelligence applications such as Informatica with strong business understanding knowledge of Retail Services and Health Care domains.
• Extensive knowledge of Data warehouse concepts and principles - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Strong Data Warehousing and Data Integration experience in using Informatica Power Center different versions Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer .
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows in all versions of Informatica.
• Extensive Experience with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators. Strong experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow Worklet Designer.
• Created xml soap request for web service calls using Java and Http Transformations, Working with Informatica Power Exchange to extract data from AS/400 Application. Implemented Informatica Change Data Capture on Oracle database.
• Experience in Installation and configuration, Creation of repositories with user groups and security implementation. Good Experience in Informatica upgrades and installations.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Extensively worked with Stored Procedures, functions, Triggers, Cursors, Indexes and having Strong Knowledge in optimizing database performance.
• Solid expertise in using ETL Scheduling tools and experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Good knowledge in Incident management, Change Management, Problem Management processes.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
• Excellent soft skills such as leadership, communication, organization, time management, crisis management, multi-tasking, and people-management.

SKILLS:

ETL Tools: Informatica Power Center 9.x.x/8.6.1/8.1.1/7.x, Pentaho 2.4

Operating Systems: Windows 98, NT/2000, UNIX

Databases: Oracle10g/11g, Sybase, Teradata, SQL Server, MySQL, Db2

Query Tools: TOAD, Aseisql, SQL Developer

Languages: SQL, PL/SQL, UNIX Shell Scripting

Source Control: Sub version SVN , SRLWEB

Scheduling Tools: Job Scheduler, Austosys, Control M

Professional Experience:

Confidential

Sr Informatica Developer

Health Insurance Data

Environment: Informatica 9.1, Oracle 10g, Toad, PL/SQL, Windows NT, UNIX Shell Scripting.

Responsibilities:

• Responsible for understanding the business requirements and Functional Specifications document and prepared the Source to Target Mapping document.
• Worked closely with Business Analyst and involved in Data Analysis to identify the business rules.
• Developed mappings/reusable objects/ transformations by using mapping designer and transformation developer in Informatica Power Center.
• Analyzing the issues and providing the solutions to dev and test teams.
• Involved in optimization to identify the bottlenecks for the existing jobs.
• Complex Business Rules are implemented to identify error records.
• Develop debugging and testing mechanism for the data flow mappings.
• Developing complex SCD-2 dimension processes.
• Preparing test scripts and reviewing the test results.
• Monitor the Sessions and Batches for data load.
• Tuning of the mappings to enhance the performance.
• Optimizing the mappings by changing the logic to reduce run time.
• Handling issues raised by clients in Production Support environment.
• Good experience running the workflows by using PMCMD commands.
• Good experience to work with different task such as Session, Command, Event wait, Event Raise, Timer, Assignment etc.
• Performed Unit testing and Performance Tuning testing.

Confidential

Sr Informatica Developer

Environment: Informatica Power center 9.0.1, Oracle 10g, Toad, Erwin 7.2,Sql server 2008 r2, PL/SQL, Windows NT, UNIX Shell Scripting, Control-M, Business Objects XIR2.

Responsibilities:

• Involved in gathering and analysis business requirements and identify data sources and targets, create data mapping sheet, Low Level Design Document as per business requirements.
• Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer to populate the data into the target Schema.
• Extracted data from various heterogeneous sources systems like Oracle, SQL Server, Fixed Width and Delimited Flat Files and loaded into relational data warehouse.
• Designed and developed active and passive transformations in complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, aggregator, Joiner, Update Strategy, Stored Procedure.
• Experience in using mapping parameter and variables and assigning the parameter file globally/session/workflow and folder level in a mapping.
• Modified the existing worklets and workflows to accommodate for these new sessions and mappings.
• Testing the mapping and fixing the bugs using debuggers and session/workflow logs.
• Involved in optimization and performance tuning of Informatica objects and database objects to achieve better performance.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
• Responsible for resolving major Production incidents escalated to development team using Session Logs, and Workflow Logs and also Responsible for determining the bottlenecks in existing code and fixing the bottlenecks with performance tuning.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements. Created different jobs using UNIX shell scripting to call the workflow. Created the schedule using Autosys and ran the jobs.
• Created, updated and maintained ETL technical documentation for Production Migration.

Confidential

Channel Data Integration

Environment: Informatica 8.6, Pentaho 2.4, Oracle 10g, Toad, PL/SQL, Flat Files, XML Files,

Responsibilities:

• Responsible for understanding the business requirements and Functional Specifications document and prepared the Source to Target Mapping document.
• Worked Extensively on Informatica modules -Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Responsible for creating tasks, worklets, workflows, Used Workflow manager to schedule, execute and monitor the session.
• Responsible for creating complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner Transformations.
• Responsible for Production Support level 3 and Issue Resolutions using Session Logs, and Workflow Logs and also Responsible for determining the bottlenecks in existing code and fixing the bottlenecks with performance tuning.
• Responsible for Monitoring all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings which are failed.
• Responsible for analyzing Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Responsible for creating and using Debugger sessions to debug sessions and created breakpoints for better analysis of mappings. Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problem trouble shooting.
• Developed UNIX Shell scripts for calling the Informatica mappings and running the tasks on a daily basis. Created automated UNIX scripts to run sessions on desired date time for imports.
• Wrote Oracle PL/SQL procedures and functions whenever needed.
• Delivered projects working in Onsite-Offshore model. Directly responsible for deliverables.
• Work with L2 and business team for critical production issues for sev3 major and above .
• Responsible for addressing Problem management review, weekly calls with calls with L2 team and client.
• Client: MHEC, NY, US Oct 07 Jun 09
• Informatica Developer
• Environment: Informatica 8.1.1, Oracle 10g, Toad, PL/SQL, Putty, Windows NT, UNIX.
• MHEC is a material handling engineering and distribution firm. They used to receive pricing updates from their equipment vendors each month, but all in uniquely different data formats. The company sought a methodology to ensure their equipment vendors' monthly pricing data could be uploaded into their Data Warehouse and into the correct set of tables. The Application provides Business Intelligence Services for the management of MHEC. Data from various sources in form of flat files and Oracle tables are selectively extracted, mapped, transformed and loaded into the Data Mart using Informatica. The transformed data from the data warehouse is loaded into an OLAP server to provide the Business Intelligence.
• Responsibilities:
• Understanding the Functional Team requirements specifications.
• Complex Business Rules are implemented to identify error records.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Develop debugging and testing mechanism for the data flow mappings.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Developing complex Slowly Changing Dimensions Type-2 Processes.
• Preparing test scripts and reviewing the test results.
• Monitor the Sessions and Batches for data load.
• Tuning of the mappings to enhance the performance.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Confidential

Informatica Developer

Environment: Informatica 7.x, Oracle 10g, Toad 10, SQL/PLSQL, WinSCP, Putty, Windows NT, UNIX.

Responsibilities:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer Mapplet, and Transformation Developer.
• Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with heterogeneous sources including relational sources and flat files.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Extensively involved in monitoring the jobs in order to detect and fix unknown bugs and track performance.