Summary:

• Engineering Professional with * years 5 months of experience in ETL - Informatica Power

Centre with strong background in Design, Development, Implementation, and support of ETL Processes

• Good knowledge of Data Warehousing concepts like Star Schema, Snowflake, Schema Dimensions and Fact Tables.

• Currently working as Informatica Developer at Tata Consultancy Services.

• Experience as Data Specialist at IBM India Pvt. Ltd.

• Hands on experience in TOAD, Microsoft SQL Server Management Studio 18, SQL Developer & PLSQL Developer.

• Good knowledge on Informatica Power Centre, Informatica Power Connect and Power Exchange.

• Excellent Analytical, Problem-solving skills and motivated team player with good communication and productive interpersonal skills. Educational Qualifications:

Bachelor of Engineering in Information Science from Shree Devi Institute of Technology

(VTU), Mangalore, Karnataka

Higher Secondary (10+2) from Canara PU College, Mangalore, Karnataka

Secondary (10th) from VKR Acharya Memorial School, Kundapur, Karnataka Experience Summary:

Tata Consultancy Services from Feb-2020 to Current.

IBM India Pvt. Ltd from Feb - 2016 to July - 2019 Core Skills:

Hands on experience in SQL

RDBMS: Oracle 10g, SQL Server

Application: Informatica Powercenter 9.5; Informatica Data Quality 9.5.1; Informatica PowerConnect (Informatica SAP Intergration)

Database Management: TOAD, SQL Developer & PL/SQL Developer

Operating System : Linux, Windows

Phone: +1-734-***-****

Email: ad4hhy@r.postjobfree.com

ANMOL HEGDE Location: Northville, Michigan

PROJECT PROFILE

Project Name: Manpower Group

Organization: Tata Consultancy Services

Duration: February 2020 – March 2024

Role: Informatica Developer

Technology: ETL (Informatica PowerCenter)

Description: ManpowerGroup provides administrative & support services, professional services, and business services through its four primary brands: Manpower (contingent staffing & permanent recruitment), Experis (professional resourcing and based solutions), Right Management (career management, workforce consulting, and training & development), and ManpowerGroup Solutions (managed services and outsourcing). Responsibilities in project:

- Understanding existing business model.

- Involved in Requirements Analysis and Technical discussions with end customer.

- Create Data flow diagram from customer requirements.

- Design various mappings for extracting data from different sources involving relational tables and flat files.

- Extensively worked with mapping parameters, variables, and session parameters.

- Review of overall mappings before migration to production environment.

- Preparing TDD, FDD, BRD and Unit Test Case documents.

- Responsible for monitoring and defect fixes of Production Jobs.

- Raising internal Change requests for Go-live and representing weekly customer calls. Achievements: Was awarded On-the-spot award & Special achievement award Project Name: BP NIKE US & Mexico

Client: British Petroleum

Organization: IBM India Private Limited

Duration: February 2016 – July 2019

Role: Data Migration Consultant

Technology: ETL (Informatica PowerCenter)

Description: Nike US & Mexico project is a part of Chemical & Petroleum Downstream segment. This project involves migration of data from different legacy systems like JDE DB2 to SAP BW and SAP R3 systems using Informatica PowerCenter tool. The entire project scope comprises of two waves. Wave 1 involves migration of Industrial customer related data and Wave 2 involves migration of Auto customer related data. It also includes migration of Customer Master, Vendor Master, Material Master, Supply Chain Planning Data. Responsibilities in project:

- Understanding existing business model

- Understanding Customer Master related Data Migration Documents

- Developing Informatica mappings for combination of different account groups and Customer Master modules like General Data, Sales Data, Company Code and Bank data

- Preparing Unit Test Documents

- Resolution of complex issues

- Working on Error Logging Mechanism in Informatica PowerCenter

- Mentoring new team members and creating healthy environment within team

- Understanding Customer pain points and resolving them. Personal Details

Full Name : Anmol Hegde

Date of Birth : 5th September 1993

Gender : Female

Languages Known : English, Hindi, Kannada, Tulu

Marital Status : Married

Northville, MI (Anmol Hegde)

Contact this candidate