SUMMARY:

• Good knowledge in Incident management, Change Management, Problem Management processes.
• Solid expertise in using ETL Scheduling tools and experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Extensively worked with Stored Procedures, functions, Triggers, Cursors, Indexes and having Strong Knowledge in optimizing database performance.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in Installation and configuration, Creation of repositories with user groups and security implementation. Good Experience in Informatica upgrades and installations.
• 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.
• 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.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows in all versions of Informatica.
• 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 .
• Extensive knowledge of Data warehouse concepts and principles - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Involved in Development of Data Warehouse, Business intelligence applications such as Informatica with strong business understanding knowledge of Retail Services and Health Care domains.
• 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.
• 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

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.
• 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.
• 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.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
• Involved in optimization and performance tuning of Informatica objects and database objects to achieve better performance.
• Testing the mapping and fixing the bugs using debuggers and session/workflow logs.
• Modified the existing worklets and workflows to accommodate for these new sessions and mappings.
• Experience in using mapping parameter and variables and assigning the parameter file globally/session/workflow and folder level in a mapping.
• 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.
• Extracted data from various heterogeneous sources systems like Oracle, SQL Server, Fixed Width and Delimited Flat Files and loaded into relational data warehouse.
• Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer to populate the data into the target Schema.
• Created, updated and maintained ETL technical documentation for Production Migration.

Confidential

Informatica developer

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.
• Delivered projects working in Onsite-Offshore model. Directly responsible for deliverables.
• Wrote Oracle PL/SQL procedures and functions whenever needed.
• 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.
• 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.
• Responsible for analyzing Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Responsible for Monitoring all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings which are failed.
• 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 creating complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner Transformations.
• Responsible for creating tasks, worklets, workflows, Used Workflow manager to schedule, execute and monitor the session.
• Worked Extensively on Informatica modules -Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• 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.

Confidential

Informatica Developer

Environment: Informatica 8.1.1, Oracle 10g, Toad, PL/SQL, Putty, Windows NT, UNIX.

Responsibilities:

• Understanding the Functional Team requirements specifications.
• Tuning of the mappings to enhance the performance.
• Monitor the Sessions and Batches for data load.
• Preparing test scripts and reviewing the test results.
• Developing complex Slowly Changing Dimensions Type-2 Processes.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Develop debugging and testing mechanism for the data flow mappings.
• 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.
• Complex Business Rules are implemented to identify error records.
• 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.