Professional summary:

• Around 2 years of focused experience in Information Technology with a strong background in Data warehousing and ETL process using Informatica PowerCenter 8.6 and aware on Informatica 9.x features.
• Proficiency in using Informatica PowerCenter tool to design data conversions from wide variety of source systems.
• Worked on Informatica Power Center tool for data conversion from variety of source systems, dealt with various transformation logic like Lookup, Aggregator, Joiner, Source Qualifier, Expression, Update Strategy and more while designing and developing complex mappings and mapplets.
• Good experience with performance tuning techniques at mapping, session and workflow level.
• Extensive hands on experience with ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Exposure to OLAP, OLTP, data warehouse development, and data modeling.
• Good in understanding data quality, metadata, and data lineage issues and best practices.
• Proficient in evaluating, analyzing, designing and implementing solutions based on technical requirements.
• Actively participated in all stages of Software Development Life Cycle.
• Extensive experience in all transformations and execution of test plans for loading the data successfully into the targets.
• Involved in offshore co-ordination for the tasks that have been developed from offshore.
• A Team Player with excellent communication, analytical, verbal and writing skills.

Skill Sets 

ETL Tools : Informatica 

OS : Windows, Linux 

RDBMS  : Oracle 11g 

Languages : SQL, PL/SQL, C, C++, HTML 

Version Control Tools : Starteam, Visual Source Safe 

Issue Tracking Tools : HP Quality Center, PVCS Tracker

 Database Frontend Tools : Toad, SQL Developer

Work Experience

• Working as a Software Consultant for Confidential, LLC from Jun’12 to till date.
• Worked as a Software Engineer for Confidential, from Dec’10 to Jan’12.

Education

• Bachelor of Technology in Information Technology from Confidential Institute.

Projects Profile 1. Matter and Document Management System

Client:Confidential, Delaware

Organization:Matrix Technologies

Environment:

Tools: Informatica 8.6

Database:Oracle 11g

Description: This unified, web-based platform is the perfect solution for the safe storage, retrieval, and management of all documents and associated data. CSC Matter Management is the key to timely, precise handling of any number of critical tasks. This project enables multiple departments to collaborate and customize their workflow templates according to their specific requirements. Through user permissions, client can control access to sensitive data and allow unlimited users to access and update contents at any time, from anywhere. CSC Matter Management helps integrate your organization\'s contract management processes with your many other legal and administrative functions, from Service of Process receipt to litigation management, E-billing to due diligence for mergers & acquisitions. Platform gives you a reliable, direct way to track and monitor the status of multiple lawsuits from beginning to end. It brings together all the functions you need to stay ahead of due dates, save and retrieve critical documents, store relevant data, and reduce the budgetary impacts of any legal action.

Responsibilities:

• Understanding the Business Requirements by participating in all discussions.
• Having knowledge on preparing documents like use case, technical design document, test case, knowledge transfer document.
• Implementing the transformation logic using Informatica Designer to build business rules to load data.
• Responsible to design ETL’s by using Informatica performance tuning techniques to avoid long running jobs.
• Able to Lead, Design, Develop and Deploy the ETL processes for the Data Warehouse team.
• Responsible for collaborating with the Data Warehouse team to design and develop required ETL processes, performance tune ETL programs/scripts.
• Maintain and enhance ETL code, work with the QA and DBA team to fix performance issues.
• Troubleshooting and supporting ETL systems in a Production environment including resolving issues and deploying bug fixes in a timely manner
• Extensively used Informatica Power center for loading the data from various source involving flat files and oracle tables.
• Used the existing Mapplets to reduce the development time and complexity of mappings and better maintenance.
• Involving in deployment and issue resolution during the release/migration.
• Providing the 24hrs Oncall support when required for the issues from production.
• Involved in QA handshake meeting to handover the requirements to QA team along with business team.
• Actively involving in bug fixing, testing and deployment process on production issues.
• Responsible to prioritize the tasks/issues based on criticality to meet SLA’s.
• Identifying the dependencies to schedule jobs as part of end of day processing.
• Providing support in all phases of testing like component, integration, system and user acceptance testing.

2. Financial System Renewal (FSR) Frame Work

Client:Confidential

Organization:Confidential

Environment:

Tools:Informatica 8.6

Database:Oracle 11g

Description: Financial Systems Renewal means up gradation of information systems of the financial institution. Deutsche Bank being our customer has the requirement for FSR in various countries in the Asia Pacific region. FSR Frame Work uses database driven change control mechanism, where in business users enter the request on set of predefined tables and raise a change request via share point, which will be communicated to ETL Team. Upon receiving the communication and approval of change request, CR co-coordinator analyzes the requirement and perform synch of the requirement from work area to live area, then notify the ETL development team about the new request. This project is having a highly flexible dynamically –configurable process architecture for loading data into the SAP/R3 GGL (Global General Ledger), SAP/BW (Reporting) and other target systems from a number of various source interfaces. One Central Informatica repository is used for the DB Feeds implementation. The core template build is common across all regions and locations that will use the ETL gateway for processing. 

Responsibilities: 

• Used Informatica as an ETL tool to extract data from multiple source systems by creating mappings using various transformations.
• Developed and tested mappings, sessions, worklets and workflows.
• Developing and modifying changes in mappings according to business logic and also tuned them for better performance.
• Creating and running workflows using Workflow Manager to load data into the Target Database.
• Configured the sessions to handle the updates to preserve the existing records.
• Created Unit test scripts, checklist for Informatica Objects mappings, sessions, worklets and workflows as a part of Unit testing.
• Scheduling of sessions and batches using workflow manager to load the data into target table.