Amarendhar Adavelli
Informatica Consultant | IDMC | IICS |CDI | CAI | API |Mass Ingestion (MI)|SaaS MDM | MDM | B360 | C360 | R360 | P360 | RDM | CDQ | IDQ | EDC | ETL | PC | Snowflake| Web FOCUS
- Role
- Informatica Consultant at Conduent
- Location
- Tallahassee, US
- LinkedIn followers
- 500 followers
About Amarendhar Adavelli
Over 8+ years of dedicated experience as an Informatica consultant in Data Integration…
Experience
Informatica Consultant
Apr 2023 — Present · GA, US
Administered and supported the core EIM technology stack including Informatica (PowerCenter, IICS suite, MDM, IDQ, EDC), SAP BODI, DB2, and Talend across Dev/QA/Prod environments. Worked closely with stakeholders on business rules, perform gap analysis, requirement gathering and deliverables for Phase-I and Phase-II.Collaborated with stakeholders to gather requirements and perform gap analysis for Phases I & II, accelerating project onboarding and reducing scope changes by 25%.• Developed Snowflake data warehouse models to support analytics and reporting, improving business user access to KPIs by 50%.• Integrated CDM with external APIs via CAI using Swagger/Postman, streamlining entity resolution and reducing duplicate records by 40%.• Implemented Delta Load strategies to capture changes from source systems, minimizing full loads and cutting compute costs by 30%.• Configured CDC in IICS for insert/update/delete tracking, ensuring near real-time replication accuracy across transactional systems.• Designed XML-generating ETL flows using Hierarchical Builder in IICS-CDI to support downstream API integrations, increasing data compatibility.• Mentored peers on ETL and Snowflake architecture best practices, contributing to a 20% improvement in overall team delivery velocity.• Defined matching rules and configured CDM match models for entity resolution, increasing golden record accuracy by 30% in R360.• Authored architecture and ETL standards documentation for Informatica implementations, ensuring consistency across all project lifecycles.• Designed, developed, and deployed secure and scalable APIs using Apigee Edge for enterprise applications.• Implement end to end error handling framework for CDC, ETL objects and automate the error report process to respective team during infrastructure or data sync failures.• Developed UNIX shell Scripts and PMCMD commands to auto start and stop Informatica CDC, ETL sessions.
Education
Jawaharlal Nehru Technological University
Bachelor's degree
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.