ANKIT GOYAL
Assistant Consultant
Ghaziabad
Summary
Performance-driven Informatica Administrator with nearly 14 years of experience in Data Warehousing Architecture across the retail and pharmaceutical sectors. Skilled in administering Informatica platforms, including installation, upgrades, emergency bug fixes, and ensuring platform availability. Expertise in Informatica tools such as PC, IDQ, DEI, IDMC, and EDC/Axon, with experience in both administration and development, while collaborating with vendor teams to maintain system efficiency.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Informatica SME/Architect
Client: Leading Pharmaceutical Company
06.2020 - Current
- Led a team of 10 in executing over 10 proofs of concept (POCs) for new Informatica features and tools, including Azure Lift and Shift, PWX for Redshift, and Informatica CDI-PC.
- Analyzed business and technical requirements, identified and resolved issues, and effectively managed Informatica platform errors.
- Oversaw lifecycle management of various Informatica tools, including version upgrades and hotfixes, while spearheading platform modernization for cloud operations.
- Managed major change requests and resolved critical application issues, ensuring smooth platform operations.
- Provided training sessions to new team members, covering both business and technical aspects, fostering team development and expertise.
Offshore Lead
Client:Leading Pharmaceutical Company
05.2013 - 06.2020
- Led a team of 5 as the technical lead from an offshore location, overseeing project execution.
- Allocated tasks to team members and ensured deadlines were met.
- Analyzed business requirements based on functional and technical specifications, identifying issues and providing effective resolutions.
Managed critical responsibilities for the project, including domain installation, license renewal, and domain node setup. - Delivered ongoing support through the installation of hotfixes and emergency bug fixes.
- Oversaw project effort calculations and cost estimation, maintaining active engagement with customers.
- Executed the end-to-end Data Migration Process to ensure data integrity and performance.
- Conducted performance tuning activities related to ETL processes for optimal efficiency.
- Managed interactions with multiple teams to ensure smooth project implementation.
- Developed and modified Unix scripts to automate processes and enhance system functionality.
- Addressed major change requests and resolved critical issues encountered within the application.
- Conducted training sessions for new team members, sharing essential business and technical knowledge.
ETL-DATA Consultant/Developer/Support Analyst
Client:Leading Mobile Manufacturer
6 2010 - 4 2013
- Worked as an Informatica Administrator, overseeing all phases of implementation.
- Provided ongoing support, including new domain installation and license key renewal.
- Regularly maintained the Informatica Server for optimal performance.
Estimated project efforts and costs, collaborating closely with clients. - Mentored team members and managed multiple project teams effectively.
Accelerated end-to-end project deliverables by implementing efficient processes. - Designed the Data Model and developed Mapping Code Base for ETL processes using Informatica.
- Provided L1/L2/L3 support for applications, ensuring 24/7 system maintenance and availability.
Education
MCA - Computers - undefined
UPTU
B.Sc - Physics - undefined
M.J.P. Rohilkhand University
Skills
Informatica Data Quality
Data Integration
Iics
Informatica Admin
microsoft azure
cloud
python scripting
sql
oracle
hadoop
data warehousing
big data
service now
ms sql server
data modeling
unix shell scripting
pl/sql
data migration
shell scripting
Certification
Azure developer associate (az-204) by microsoft
Languages
English
Hindi
Work Experience
- Performance-driven Informatica Administrator and Developer with nearly 14 years of experience in Data Warehousing Architecture within the retail and pharmaceutical sectors.
- Hands-on expertise in upgrading and installing Informatica tools, including PC, IDQ, EDC, DEI, and Axon.
- Proficient in applying hotfixes and emergency bug fixes across multiple environments.
- Extensive experience in PowerCenter administration and development across versions 10.5.3, 10.4.1, 10.2.0, 9.6.1, 9.1.0, and 8.6.1.
- Skilled in IDMC/IICS, including secure agent installation, native/SSO setup, Cloud Data Integration (CDI), and Cloud Application Integration (CAI).
- Experienced with Informatica BDM (DEI), including HDP 3.5 and Cloudera 6.1 connectivity.
- Knowledgeable in setting up Kerberos connectivity for Informatica DEI with Hadoop clusters.
- Managed lifecycle of EDC/Axon, resolving complex issues efficiently. Currently working with EDC 10.5.3 and Axon 7.3.1.
- Strong communication skills, effectively engaging in client-facing roles.
Timeline
Informatica SME/Architect
Client: Leading Pharmaceutical Company
06.2020 - Current
Offshore Lead
Client:Leading Pharmaceutical Company
05.2013 - 06.2020
ETL-DATA Consultant/Developer/Support Analyst
Client:Leading Mobile Manufacturer
6 2010 - 4 2013
MCA - Computers - undefined
UPTU
B.Sc - Physics - undefined
M.J.P. Rohilkhand University
Azure developer associate (az-204) by microsoft
Similar Profiles
Nilesh KhunteNilesh Khunte
SENIOR MANAGER - OPERATIONS AND INSURANCE DOMAIN CONSULTANT at TATA CONSULTANCY SERVICES (CLIENT -LEADING EU INSURANCE COMPANY)SENIOR MANAGER - OPERATIONS AND INSURANCE DOMAIN CONSULTANT at TATA CONSULTANCY SERVICES (CLIENT -LEADING EU INSURANCE COMPANY)
Koushik JeevaKoushik Jeeva
Test Engineering Specialist at USA Based Leading Pharmaceutical OrganizationTest Engineering Specialist at USA Based Leading Pharmaceutical Organization
Manisha RahagudeManisha Rahagude
Project Manager at Tata Consultancy Services ( Pharmaceutical Client)Project Manager at Tata Consultancy Services ( Pharmaceutical Client)