SUMMARY

• Over 7+ years of IT experience with strong background in Application development, Maintenance, Analysis, Design, Enhancement, Implementation of Data warehousing in ETL process using Informatica Power Center 8.6, 7.1, Repository Manager, Designer, Datamart, OLAP.
• Extensive knowledge on Unix commands, FTP and shell scripts.
• Expertise in monitoring scheduled workflows as nightly batch cycle during the On - call support hours.
• Experience in debugging the production job failures in Informatica and resolving it on time.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively 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.
• Performance tuning, Indexing and partitioning techniques on Sources, Targets, Mappings and Workflows in Informatica.
• Involvement in tuning and troubleshooting the mappings to perform maximum efficiency and performance.
• Good knowledge in OLAP tools like Brio and Business objects.
• Extensively used PL/SQL in writing Stored Procedures, Functions and Packages.
• Optimizing the SQL queries in PL/SQL code.
• Experience on ITIL framework, Incident management and Change management.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual contributor.
• Quick at learning and mastering new software and application tools to apply their full range of capabilities.
• Agile methodology experience.
• Team handling experience and acted as Onsite co-ordinator. Have good working experience in onsite-offshore model.

TECHNICAL SKILLS

ETL Tools: Informatica 8.x/7.x (Power Center) (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Kalido DIW, Kalido MDM.

Databases: Oracle 10g/9i, MS SQL Server 2005/2000

OLAP Tools: Brio 6.1, 8, Business objects

Languages: SQL, PL/SQL, Unix Shell Script

Tools: Toad, SQL* Plus, SQL Navigator

Operating Systems: Windows 2003/2000/NT, Unix

Job Montioring Tools: Autosys, Control - M

Ticketing Tools (IM & CM): Remedy, Service Center (HP), PACE

PROFESSIONAL EXPERIENCE

Confidential, NY

ETL Lead

Responsibilities:

• Developing Informatica mappings, sessions and workflows.
• Used transformations such as the source qualifier, aggregators, connected & unconnected lookups, SQL,filters, sorter, stored procedures, router & sequence generator.
• Developed ETL procedures to translate business rules and functionality requirements into business logic, ensuring lack of redundancy and compliance with standards.
• Developed Reusable Mapplets and Transformations for standard business calculations.
• Extensively used Informatica client, repository server and Informatica server tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Extensively used various Performance tuning Techniques to improve the session performance. (Partitioning, configuring data & index cache, incremental aggregation, etc).
• Development of pre-session, post-session routines and batch execution routines using Informatica server to run Informatica sessions.
• Developed MDM tables using Kalido MDM 8.5
• Agile methodology, Daily scrum and sprint planning.
• Handled a team of Junior developers.

Environment: Power Center 8.6, Oracle 10g, Toad, PL/SQL, Windows XP/NT, UNIX, Kalido 8.5 (MDM & DIW).

Confidential, CT

ETL Team Lead

Responsibilities:

• Developed ETL procedures to translate business rules and functionality requirements into business logic, ensuring lack of redundancy and compliance with standards.
• Used transformations such as the source qualifier, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Developed Reusable Mapplets and Transformations for standard business calculations.
• Extensively used Informatica client, repository server and Informatica server tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Extensively used various Performance tuning Techniques to improve the session performance. (Partitioning, configuring data & index cache, incremental aggregation, etc).
• Development of pre-session, post-session routines and batch execution routines using Informatica server to run Informatica sessions.
• Improved workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
• Developed data mappings between source systems and warehouse components.
• Created and defined DDL’s for the tables at staging area.
• Created events, decision and tasks in the work flows using workflow manager.
• Implemented performance tuning by using lookup caches, using tables with fewer rows as the master table in joiner transformations, dropped indexes and re-created them after loading data to targets and increased the commit interval.
• Executed sessions, sequential and concurrent batches for proper execution of mappings.
• Executed Pre and Post session commands on Source and Target database using Shell Scripting.
• Assisted users in trouble shooting their reports.
• Worked as a team leader with a team of 5 people. Onsite-offshore model.
• Managed the team by having meetings and communicated with users.

Environment: Power Center 8.6, Oracle 9i, 10g, Toad, PL/SQL, SQL plus, Windows XP/NT, UNIX, Brio, Business objects, Autosys, Remedy, Kalido, Putty.

Confidential

ETL Developer / Support Analyst

Responsibilities:

• Designed and developed various mappings in Mapping Designer and sessions and workflows in Workflow Manager to extract data from flat files, Oracle and DB2.
• Developed Mappings as per the Design document to implement business logic.
• Created complex joiners, transformations such as connected/unconnected lookups/procedures to smoothly pass data through ETL maps.
• Worked extensively with Workflow manager to handle workflows and worklets.
• Involved in designing, documenting and developing mapplets, transformations and mappings to achieve best reusability and performance.
• Good experience in analyzing, understanding and creating source and target definitions.
• Used Performance Tuning Strategies when developing Mappings and Workflows to optimize performance.
• Extensive interaction with End users in consolidating requirement specifications.
• Used SQL tools like TOAD to run queries.
• Developed complex PL/SQL procedures.
• Monitored workflows using Workflow Monitor to see for completed or failed sessions.
• Monitored the batch jobs in Control - M

Environment: Oracle 9i, Flat Files, ETL-Informatica 7.1, Service Center (HP), Control -M, SQL, PL/SQL, Shell Scripts, Win NT, Toad, and Putty

Confidential

Oracle Developer

Responsibilities:

• Developed complex SQL queries and PL/SQL packages, including stored procedures & functions, to fetch data for reporting and to accomplish several computations.
• Developed PL/SQL procedures, functions.
• Query optimization.

Environment: Oracle 8i, SQL Navigator, Toad