SAI KRISHNA KANDIMALLA
Hyderabad,Telangana
Summary
Results-driven Informatica Support Engineer at NTT DATA with expertise in ETL processes and data integration. Proficient in Informatica PowerCenter and IICS, I excel in resolving complex data issues and optimizing workflows. Strong analytical skills and a collaborative approach ensure data integrity and enhance operational efficiency. Committed to delivering high-quality support and solutions.
Overview
2
2
years of professional experience
Work History
Informatica Support Engineer
NTT DATA
Hyderabad, India
12.2022 - Current
- Involved in the production support of the ETL process and resolving issues such as identifying data problems and connection problems in both PowerCenter and IICS environments.
- Responsible for managing schedules, connections, and daily monitoring of the workflows and deployment activities.
- Provided L2/L3 support for Informatica Cloud (IICS) Data Integration tasks, addressing failures, performance issues, and user queries.
- Provided production support for data warehouse systems, resolving ETL failures and performance issues in Informatica PowerCenter workflows, and IICS Taskflows.
- Coordinated with source system teams and data consumers to resolve data discrepancies, and ensure end-to-end data integrity.
- Collaborated with ETL developers and infrastructure teams to resolve integration issues and optimize task performance.
- Worked in ETL enhancements and production support. Recovering the failed sessions and batches.
- Having knowledge of admin-related work, such as managing access, bringing up services and servers, and performing upgrades and validations on both PowerCenter and IICS.
- Created and modified mapping tasks, task flows, and schedules as part of support enhancements and incident resolution.
- Assisted in onboarding and configuring secure agents, runtime environments, and connections for cloud and on-premises data sources.
- Worked with REST/SOAP APIs and file-based sources (SFTP, flat files) for data ingestion and extraction via Informatica Cloud.
- Involved in PowerCenter to cloud migration, and performed source-to-target data validation using SQL to ensure data accuracy post-ETL.
- Documented recurring issues, standard operating procedures, and runbooks to improve support efficiency and onboarding.
- Provided support for ETL jobs utilizing core Informatica transformations, such as Expression, Lookup, Joiner, Filter, Web Service, and Aggregator.
- Performed ad-hoc and scheduled data fixes in production databases using validated SQL scripts, while maintaining strict audit and approval processes, and supported data marts, and assisted in loading fact and dimension tables.
- Analyzed data discrepancies reported by business users, and implemented accurate data corrections in fact and dimension tables to ensure reporting consistency.
- Investigated and resolved data quality issues due to ETL failures or missing source data by applying controlled manual updates, or re-triggering specific workflows.
- Experience on the ServiceNow platform, handling production issues using ServiceNow incidents, tasks, and changes.
Education
Bachelor's Degree - Computer Science
SCSVMV University
Tamil Nadu, India08-2021
Skills
Informatica
- Informatica PowerCenter
- Informatica IICS
- ETL
- Informatica admin
- Informatica Data Services
- Power Exchange Navigator
- Informatica Master Data Management
Data warehousing
- Star schema
- Snowflake schema
- OLAP and OLTP
Database
- MS SQL Server
- Oracle SQL
Ticket tools: ServiceNow, Jira
Accomplishments
- Recognized by the client for contributing to the good work on the project
Strengths
- Problem Solving, Successfully troubleshooted and resolved multiple complex data issues, enhancing the overall efficiency of the data management process.
- Team Collaboration, Worked in cross-functional teams of 10+ members, coordinating effectively to deliver projects on time.
Timeline
Informatica Support Engineer
NTT DATA
12.2022 - Current
Bachelor's Degree - Computer Science
SCSVMV University
Similar Profiles
Pankaj NathPankaj Nath
Director - Cloud & Infrastructure Services at NTT DATA Services (Previously NTT/Netmagic)Director - Cloud & Infrastructure Services at NTT DATA Services (Previously NTT/Netmagic)
GAZI MAMOONUR ALAMGAZI MAMOONUR ALAM
SENIOR NETWORK ENGINEER at NTT GLOBAL PVT. LTD(NTT DATA)SENIOR NETWORK ENGINEER at NTT GLOBAL PVT. LTD(NTT DATA)
Yashika SureshbabuYashika Sureshbabu
Service Desk Analyst / Acting Shift Lead at NTT GDC India Private Limited / NTT DataService Desk Analyst / Acting Shift Lead at NTT GDC India Private Limited / NTT Data
Ruchi SharmaRuchi Sharma
QA Specialist Engineering TL at NTT Data (NTT cloud Com.)QA Specialist Engineering TL at NTT Data (NTT cloud Com.)
KIRAN B YKIRAN B Y
Creative Producer & Production Lead (Kannada/Telugu) at Pocket FMCreative Producer & Production Lead (Kannada/Telugu) at Pocket FM