SUMMARY

• Over 7 years of professional experience in IT Industry with expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing applications.
• Proficient knowledge in Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Informatica PowerCenter (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union,Update Strategy, Stored Procedure and Sequence Generator etc.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient interms of session performance.
• Worked on Slowly Changing Dimensions (SCD's) and its implementation to keep track of historical data.
• Expertise in Data Extraction from Flat Files (fixed width, delimited), XML files using Power Center.
• Experienced in automating the Informatica jobs, also experienced in Informatica scheduler (Tidal, Control-M) Autosys.
• Experience in UNIX working environment, writing UNIX shell scripts to automate ETL Process and also for Informatica pre & post session operations.
• Good understanding of PL/SQL procedures, functions, triggers and other database components. Experience in converting PL/SQL procedures to ETL Interfaces.
• Experienced in Oracle PL/SQL programming including development and tuning of packages, stored procedures, functions, triggers and Unix/Linux Shell scripting.
• Created reusable oracle Packages and Stored procedures for different applications.
• Worked with query tools like Toad, SQL*Plus, PL/SQL Developer.
• Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.
• Excellent soft skills, team building skills. Have played Technical Lead / Sr Software Developer roles for various projects and handled team as big as 5-7 team members.
• Experience in implementing Update-Strategies, incremental loads, Informatica B2B data transformation and change Data capture.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Sound knowledge on all testing processes, have worked on unit testing,system testing,integration testing,regression testing and UAT.
• Experience as an SME assisting the development teams with requirement gathering, system analysis, finalizing technical and functional specifications.
• Familiar with Teradata Database Platform.
• Have fair knowledge on Health Insurance, Finance and Investment banking domain.
• Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn the new cutting edge technologies.
• Handled training sessions on Informatica to the team. Participated in Recruitment drives for Informatica positions.

TECHNICAL SKILLS

Tools: Informatica Power Center 8.6 and 9.0.1,9.5 Toad, PL/SQL Developer, WinSCP, Putty, Subversion (version control),Tidal, Control-M(Scheduler Tools)

Databases: SQL, PL/SQL and Oracle 9i,10g

Scripting: UNIX shell Scripting.

Reporting: Cognos Report Studio

Testing: Unit testing, System Integration tests and User Acceptance Tests.

Operating Systems: Windows XP, Windows 7/8 and UNIX

PROFESSIONAL EXPERIENCE

Confidential

Consultant

Environment: Informatica 9.5, Oracle 11g, 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.
• Designed Technical design document based on the business requirements.
• Worked closely with Business Analyst and involved in Data Analysis to identify the business rules.
• Involved in Design review, code review, Performance analysis.
• Developed mappings/reusable objects/ transformations by using mapping designer and transformation developer in Informatica Power Center.
• Created deployment groups to deploy objects
• Created Tidal jobs to schedule the Informatica workflows.
• Involved in optimization to identify the bottlenecks for the existing jobs.
• Developed Reusable Transformations and Reusable Mapplets.
• Migrated objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Optimizing the mappings by changing the logic to reduce run time.
• Provided production support for Business Users and documented problems and solutions for running the workflows.
• Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data.
• Developed reusable stored procedures using PL/SQL to handle data maintenance activities (truncate table data/partition, drop table indexes, recreate indexes, process data by group) for all the ODS tables.
• Created reusable functions for performing data purge with different business rules(60 days,5 years)
• Tuned stored procedures identified for better performance.
• Involved in created views for loading Provider xwalk data into ODS schema.
• Involved in converting PL/SQL procedures to ETL Interfaces.
• Discuss with business users, BA's and Architects to finalize requirements and scope of the project.
• Maintain SVN repository, deploy code base to SIT, QA, UAT as required.

Confidential

Sr.Informatica Developer

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

Responsibilities:

• Actively involved in creating design specifications and ETL design documents
• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files.
• Created scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control auditing of different processes.
• Developed workflows with Worklet, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Involved extensively in Unit testing, integration testing and UAT.
• Developed Reusable Transformations and Reusable Mapplets.
• Created PL/SQL packages to load data clearing data from one source schema to another schema required to handle clearing service platform.
• Created database links and triggers for performing above activity and also involved in performing tuning wherever required for the packages created.
• Tuned long running queries using explain plan.
• Involved in debugging, troubleshooting procedures, functions, packages, customizing the existing PL/SQL packages.
• Responsible for entire team deliverables - Prioritizing, Assigning work and Tracking.
• Handled all the project activities, documentation required and communicating with Cross Functional teams.
• Manage the entire team, status meetings, project activities and metrics.

Confidential

Sr.Informatica Developer

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

Responsibilities:

• Actively involved in creating design specifications and ETL design documents
• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Created scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control auditing of different processes.
• Developed workflows with Worklet, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Involved extensively in Unit testing, integration testing and UAT.
• Developed Reusable Transformations and Reusable Mapplets.
• Used DBMS UTIL to create a package which help to display the email content in different languages(English,Japan,German,French,Italian).
• Involved in debugging, troubleshooting procedures, functions, packages, customizing the existing PL/SQL packages.
• Involved in creating required stage tables using Oracle scripts.
• Knowledge Transition and resolving day-to-day production issues.
• Manage the entire team, status meetings, project activities and metrics.

Confidential

Sr.Informatica Developer

Environment: Informatica 8.6, Cognos Report Studio,Oracle 11g, Toad, PL/SQL, Windows NT, UNIX Shell Scripting.

Responsibilities:

• Documented the user requirements, translated requirements into technical specification for the development of end user reports (Cognos reports) and developed implementation plan and schedule.
• Developed Slowly Changing Dimension Mappings using Type 1 SCD and Type 2 SCD.
• Created scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Developed workflows with Worklet, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Developed Cognos reports using Report Studio and cosmetic changes required to the existing reports.
• Involved extensively in Unit testing, integration testing and UAT.
• Developed Reusable Transformations and Reusable Mapplets.
• Handled all the project activities, documentation required and communicating with Cross Functional teams.

Confidential

Informatica Developer

Environment: Informatica 8.6, Cognos Report Studio,Oracle 11g, Toad, PL/SQL, Windows NT, UNIX Shell Scripting.

Responsibilities:

• Developed various mappings for extracting the data from different source systems using Informatica, PL/SQL stored procedures.
• Developed mappings for extracting data from legacy and Oracle Applications into our data warehouse.
• Created Mapplets for implementing the incremental logic, in identifying the fiscal quarter of the transaction and in calculating various requirements of business processes.
• Created scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Developed workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Developed Cognos reports using Report Studio.
• Involved extensively in Unit testing, integration testing and UAT.
• Developed Reusable Transformations and Reusable Mapplets.

Confidential

Informatica Developer

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

Responsibilities:

• Involved in Analysis of BRD’s provided by Client.
• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Extensively used almost all the transformations, which includes (Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Stored Procedure, Joiner, Normalizer, XML Source Qualifier).
• Used Mapplets, Reusable transformations, Parameters and Variables to implement OO (object orientation) techniques and to facilitate the reusability of Code.
• Developed Cognos reports using Report Studio.
• Involved extensively in Unit testing, integration testing and UAT.
• Developed Reusable Transformations and Reusable Mapplets.

Confidential

Informatica Developer

Environment: Business Objects Data Integrator 11.5,Oracle 9i,PL/SQL

Responsibilities:

• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Extensively used all the transformations, which includes (Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Stored Procedure, Joiner, Normalizer, XML Source Qualifier).
• Involved extensively in Unit testing, integration testing and UAT.