PROFESSIONAL SUMMARY

• 7.5 years of Information Technology Experience with specialization in building Data Marts and Data Warehousing with Expertise in ETL tools Informatica Power Center.
• Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas and Snow flake Schemas.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using ETL
• Member of Code review team in multiple projects.
• Working experience in using Oracle 9i/10g/11i , Teradata
• Extensively used PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Expertise in UNIX shell scripting, job scheduling, communicating with server using pmcmd. FTP and file management in various UNIX environments.
• Hands on experience on various scheduling tools: Informatica Scheduler, Autosys,
• Excellent knowledge and experience of Project Planning, Architecture and Development.
• Supported Production environment and configured new utilities and helped tuning workflows and mapping in order to tune the environment for better performance.
• Streamlined process and created procedure to handle different task, incident/trouble tickets and help desk tickets and provided the SLA's and resolved them
• Strong working experience using agile methodology to manage Minor Enhancements, Projects releases.
• Exposure on Data Modeling using tools like ER Studio, ER-Win, MS Visio
• Exposure to Informatica-MDM Data stewardship Console
• Excellent communication and interpersonal skills. Ability to work effectively while working as a team member as well as individually.
• Exposure in preparing Estimations, PDs, POCs for new project Initiatives.

TECHNICAL SKILLS

• Operating Systems UNIX, Linux, Windows NT/2000/XP
• DBMS Oracle11i/10g/9i, Teradata, DB2
• Data modeling tool Erwin, Microsoft Visio, and ER Studio 9.1
• Data Base Tools SQL Loader, TOAD, PL/SQL Developer, SQL Developer
• ETL Informatica Power Mart/ Power Center 8.6/9.1
• MDM tool Siperian Informatica MDM
• Languages C, PL/SQL, UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead

Responsibilities:

• Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Involved in gathering information for various scenario for Change Data Capture.
• Closely worked with DBA to set up the DEV and QA environment and various users and roles
• Involved in Performance tuning which included creating indexes and modifying tables, collecting stats with the help of the explain plan utility.
• Prepared User Manual, Technical Support Manual and Test Plans for various modules.
• Designed and developed complex mappings using various transformations in Designer to load data from Flat Files, SFDC, Oracle 10g, DB2 into the target Data warehouse and Analytics Datamart.
• Developed parameter file templates and used parameters, variables to make mappings more flexible, also developed shell scripts to automate the process.
• Automated the GENIUS data extract process to run on specific days in a fiscal month.
• Prepared the release notes, Impact Analysis, Cut-Over Plan, Development Production move checklist and code review reports for support central team for detailed code migrations.
• Involved in complete release management for UNIX, DB ETL Migration of GENIUS Application to Production Environment.
• Closely worked with the production support team and data team to recover from issues and various defects that encounter while running the jobs and analyzing the data. Always been a primary call on support to handle the unexpected failures occur at run time
• Involved with Business Analyst to build Views and MVs as required to the USER and provide different level of accesses to different set of users.

Environment: Informatica Power Center 9.1 HF3, Oracle 10g, MS Visio, PL/SQL, Informatica Scheduler, TOAD, SQL Developer, PL/SQL Developer, UNIX, JIRA Dashboard.

Confidential

Sr Informatica Developer

Responsibilities:

• Involved in requirements gathering process and assisting the business analysts in understanding the functional specifications.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Used the Type 2 Dimension/Effective Date Range mapping to update slowly changing dimension tables to keep a full history of dimension data in the table.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Used pipeline partitioning by specifying partitioning information for the source pipelines in mappings.
• Used pmcmd commands to communicate with the PowerCenter server for starting and stopping workflows and tasks.
• Involved in unit testing of mappings, mapplets also involved in integration testing and user acceptance testing.

Environment: Informatica Power Center 9.1 HF3, Oracle 10g, MS Visio, PL/SQL, Informatica Scheduler, TOAD, SQL Developer, PL/SQL Developer, UNIX.

Confidential

ETL/Informatica Developer

Responsibilities:

• Involved in requirements gathering process and assisting the business analysts in understanding the functional specifications.
• Involved in data modeling and design of schema for the data marts using ERwin.
• Designed the ETL processes using Informatica tool to load data from Oracle 10g, Flat Files into the target oracle 10g/Teradata Data warehouse.
• Wrote stored procedures for cleaning up data and providing underlying structure for reporting using SQL.
• Prepared ER Diagram to get DB Governance Approvals from DBAs to create new set of DB Structures and relations.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Created mapplets for reusing transformation logic in multiple mappings.
• Wrote the PL/SQL procedures for data extraction, transformation and loading.
• Used the Type 2 Dimension/Effective Date Range mapping to update slowly changing dimension tables to keep a full history of dimension data in the table.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Involved in fine tuning SQL overrides for performance Enhancements.
• Involved in performance tuning for better performance by identifying the different performance bottlenecks.
• Used pipeline partitioning by specifying partitioning information for the source pipelines in mappings.
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Used pmcmd commands to communicate with the PowerCenter server for starting and stopping workflows and tasks.
• Involved in unit testing of mappings, mapplets also involved in integration testing and user acceptance testing.
• Involved in Data Stewardship Activity to cleanse Customer Dataset coming from different source system.

Environment: Informatica PowerCenter 8.6, PL/SQL, Oracle 9i/10g, Teradata, UNIX, Autosys, Toad, MDM, Erwin, Team Track.

Confidential

Project Trainee

Responsibilities:

• Completed training on Informatica, Business Objects , Oracle Database ,Unix and database modeling
• Involved in designing logical data model physical data model using Erwin tool
• Designed the ETL processes using Informatica tool to load data from Oracle 10g, Flat Files into the target oracle 10g/Teradata Data warehouse.
• Involved in preparing use case diagram and process flow diagram using MS Visio.
• Prepared ER Diagram to get DB Governance Approvals from DBAs to create new set of DB Structures and relations.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Created mapplets for reusing transformation logic in multiple mappings.
• Created UTC and Impact analysis , Release Notes, Migration list to co-ordinate with Admins to deploy the code in Production