Pothurai Thirumaleswar Reddy
Bangalore
Summary
- Having 4+ years of hands-on experience in Data and Analytics with expertise in Informatica IDMC/IICS, Informatica MDM SaaS (Customer 360 & Reference 360), CAI,CDQ, CDI, Snowflake, Oracle, SQL, Unix, and Data Governance.
- Strong knowledge of Master Data Management (MDM) concepts, with a proven track record of delivering robust and scalable MDM solutions. Creating Informatica mappings for the different plans using various transformations.
- Hands-on experience in implementing Customer 360 and Reference 360 solutions including match & merge rules, survivorship, golden record creation, hierarchies, and reference data management Proficient in Informatica Data Quality (IDQ) on IICS, and well-versed in Data Warehousing principles and methodologies.
- Solid understanding of end-to-end business processes, with practical experience in development and solution implementation.
- Demonstrated ability to effectively interact with clients and stakeholders, gathering and translating requirements into technical solutions.
- Skilled in coding, testing, debugging, documentation, and deployment of complex data integration and MDM programs.
- Performed data stewardship activities, including reviewing, approving, and resolving data issues. Fast learner and self-motivated, with a keen interest in staying current with emerging technologies and industry trends.
- Strong background in MDM architecture, data modeling, match & merge rules, survivorship, hierarchies, and reference data management, with extensive experience in Informatica Data Quality (IDQ)
- Integrated Snowflake with cloud and on-prem applications using REST APIs
- Built reusable integration processes with robust error handling and logging
- Implemented scheduling, monitoring, and alerting for integrations
- Ensured secure integrations using authentication and encryption standards.
- Performed data profiling to identify data inconsistencies before Snowflake loads. Integrated CDQ processes within CDI pipelines.
- Generated data quality metrics and reports for business users Done extensive testing and wrote queries in SQL to ensure the loading of the data. Worked on different types of Windows functions, SQL Commands, Indexes, Aggregate Functions, Joins and Set Operators
- Designed various Mappings for extracting data from various sources involving relational tables and flat files.
- Created Re-Usable objects like Mapplets & Re-usable transformations for business logic Created different transformations for loading the data into the Oracle database, like Unconnected and Connected lookups, Joiner Transformation, Router, Filter, Expression, Sequence Generator, Aggregator, Joiner, Update Strategy, etc.
- Experience on Workflow Manager Tools - Task Developer, Worklet & Workflow Designer.
- Experience in Performance tuning of targets, sources, mappings and sessions.
- Involved in improving the performance of the Server Sessions by identifying and eliminating the
Overview
4
4
years of professional experience
Work History
Informatica Developer
KPMG
Banglalore
03.2022 - 04.2026
- Delivered a cloud-based Financial Reference Data Management solution for an Investment Services firm using Informatica IDMC MDM SaaS, establishing a single authoritative source of truth for reference data consumed by trading, risk, regulatory, and reporting platforms.
- Architected the solution leveraging MDM SaaS business entities, cross-reference management, and source system lineage to consolidate data from internal systems and external providers.
- Designed and implemented reference and master data business entities in Informatica MDM SaaS (IDMC) to manage financial instruments, securities, counterparties, and market reference data.
- Established golden records by configuring cross-reference management and source system lineage across multiple internal and external data sources.
- Defined and implemented survivorship rules based on source trust, data completeness, and recency to ensure authoritative reference attributes.
- Integrated Informatica Cloud Data Quality (CDQ) with Reference 360 for data profiling, validation, standardization, and enrichment rules.
- Implemented reference data and code set management for standardizing currencies, exchange codes, instrument types, and market identifiers.
- Informatica Cloud Data Quality (CDQ) for validation, standardization, profiling, and enrichment prior to mastering.
- Implemented real-time and batch integrations using IICS CDI/CAI, REST/SOAP APIs, and Secure Agent.
- Designed configurable match, merge, and survivorship strategies based on source trust, completeness, and recency to create high-quality golden records.
- Integrated Enabled reference data and code set standardization, auditability, history, and versioning to meet regulatory compliance.
- Deployed the solution on a scalable cloud architecture, using AWS S3 for staging and Snowflake for analytics and enterprise reporting.
- Built real-time and batch integrations using Informatica IICS (CDI/CAI) to ingest and publish reference data across Snowflake, Oracle, SQL Server, and downstream applications.
- Integrated external market data providers using REST and SOAP APIs through Secure Agent.
- Configured audit, history, and versioning features within MDM SaaS to support data governance, traceability, and regulatory compliance.
- Leveraged AWS S3 for staging, archival, and intermediate data processing and Snowflake for analytics and reporting consumption.
- Scheduled, monitored, and managed batch workflows using Control-M, ensuring reliable and timely data processing.
Skills
- Informatica Intelligent Cloud Services
- MDM
- Saas
- IDMC
- CAI
- CDI
- Data Quality
- Snowflake
- SQL
- P360
- C360
Education
B Tech -
Jawaharlal Nehru Technological University
Prakasam, Andhra06-2018
Timeline
Informatica Developer
KPMG
03.2022 - 04.2026
B Tech -
Jawaharlal Nehru Technological University