Manoj Korangi
Senior Informatica PowerCenter Developer
Hyderabad,Telangana
Summary
Have 10 years of total IT experience working with clients in Insurance, Healthcare & Banking Industries. Strong client handling and interpersonal skills. Skilled in managing, delegating and working on complex projects. Proficient in Informatica PowerCenter tools. Experienced in designing and developing complex mappings. Understanding of Data Warehouse Methodologies and RDBMS concepts. Have working experience in Snowflake Cloud data warehouse. Trained in IICS CDI (Cloud Data Integration).
Overview
10
10
years of professional experience
4
4
years of post-secondary education
Work History
Senior Consultant, Team Leader
Deloitte Consulting LLP
Hyderabad, Telangana
08.2019 - Current
- Client: Insurance company that primarily provides financial insurance and investment management
- Project Description: To maintain and support data warehouse in DB2 for the use of downstream applications
- Project Activities: Primarily responsible for all the production support activities from offshore. Production defect fixes, enhancements, incorporating new data flows, decommissioning obsolete systems and automations.
- Technical Environments: Informatica Power Center, IBM DB2
Senior Consultant, Team Leader
Deloitte Consulting LLP
Hyderabad, Telangana
08.2018 - 08.2019
- Client: E-Commerce company that primarily serves customers with their
- Project Description: To create a data warehouse in cloud for the use of downstream applications
- Project Activities: Primarily responsible for leading the team in analysis and developing Informatica components which load data into Snowflake data warehouse. Gatekeeper for the code migrations to higher environments. Acted as Scrum master and responsible for review of work done be team members.
- Products: Informatica Power Center and Snowflake
Consultant, Team Member
Deloitte Consulting LLP
Hyderabad, Telangana
08.2013 - 08.2018
- Client: Insurance company that primarily provides various types of health care products
- Project Description: To support and maintain the data warehouse which is used for reporting to DOL (Department of Labour)
- Project Activities: Primarily responsible for analysis and developing/modifying the UNIX scripts, BTEQ scripts and Informatica components, integration of the audit tool Infogix to the ETL components, monitoring the ETL flow and troubleshooting the issues. decommission legacy source systems.
- Technical Environments: Informatica Power Center, Teradata, Infogix
Systems Engineer, Team Member
Tata Consultancy Services
Hyderabad, Telangana
08.2011 - 08.2013
- Client: Multinational bank that primarily deals with different sectors of banking like Investment banking, Retail banking etc.
- Project Description: The scope of this project was to build a data warehouse to ensure compliance with BASEL II
- Project Activities: Primarily responsible for analysis and developing of ETL components using Informatica PowerCenter. Monitoring the ETL flows and troubleshooting the issues.
- Technical Environments: Informatica PowerCenter, Oracle
Education
Bachelor of Engineering - Electronics and Communication
Andhra University
Visakhapatnam 06.2006 - 05.2010
Skills
Informatica PowerCenter
SQL
Unix
Snowflake
IICS CDI (Training Experience)
Timeline
Senior Consultant, Team Leader
Deloitte Consulting LLP
08.2019 - Current
Senior Consultant, Team Leader
Deloitte Consulting LLP
08.2018 - 08.2019
Consultant, Team Member
Deloitte Consulting LLP
08.2013 - 08.2018
Systems Engineer, Team Member
Tata Consultancy Services
08.2011 - 08.2013
Bachelor of Engineering - Electronics and Communication
Andhra University
06.2006 - 05.2010