PRABHAKARAN SUNDARRAJAN
Bengaluru
Summary
Highly accomplished manager and Informatica IDMC consultant with over 4 years of leadership experience and a proven track record of successfully delivering two end-to-end, multi-domain MDM programs utilizing the full IDMC stack. Expert in driving enterprise-level data strategy, leading technical teams, and ensuring robust data quality (CDQ) and data integration (CDI). Deep functional and technical knowledge in Business 360, Multidomain MDM, and Cloud Application Integration (CAI), specializing in translating strategic business needs (e.g., centralized data repository, cloud migration) into high-impact cloud data solutions.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Manger -IDMC consultant
VIATRIS
01.2022 - Current
- Managed end-to-end migration of on-premises MDM solution to Informatica Cloud MDM, ensuring seamless transition.
- Led architectural design for centralized MDM repository, integrating seven source systems to create a single source of truth.
- Drove technical delivery across projects, utilizing full IDMC stack for optimal performance.
- Defined and implemented 15 data quality rules, enhancing data integrity within MDM hub.
- Designed resilient ETL/ELT pipelines for efficient high-volume data ingestion and distribution.
- Developed event-driven processes and real-time APIs for seamless business application integration with MDM hub.
- Steered technical and functional team of six members to complete two major programs on time.
- Applied expertise in Business 360 & Multidomain MDM to structure data model, aligning with organizational objectives.
Senior Project Engineer
Wipro
09.2019 - 12.2021
- Implemented and developed the data integration flow with informatica IICS.
Senior Associate
Cognizant Technologies Solutions
08.2018 - 09.2019
- Overall 7.4 years and 6+ years of work experience in Data Warehousing application using Informatica Power Center 8.6.9.5.1.10.1., Informatica Data Quality 9.1, 9.6, 10.1, 10.2 Informatica BDE (Big Data Edition) Oracle 11G, TOAD, Hadoop, Hive, Tableau and UNIX Platform.
Data Quality Analyst
Thomson Reuters
08.2015 - 08.2018
- Designed, developed, implemented and maintained Informatica Power Center and IDQ 9.1 application for matching and merging process.
- Utilized of Informatica IDQ 9.1&9.6 to complete initial data profiling and matching/removing duplicate data.
- Designed, coded, tested, debug and documented those programs.
- Handling live data with two major projects.
- To find the duplicates by using IDQ & using the business requirement to find those case and submit to the data jobs for merge the duplicates.
- Strong knowledge on SQL query scripting to handing five databases.
- Setup data quality and reporting capabilities.
- Strong Knowledge on Sales force & Siebel.
- Involving the migration projects to support technically.
- Designing & documenting the functional specs and preparing the technical design.
- Proactively monitor data quality levels.
- Use existing and new tool sets to deliver adhoc reports to support business process and change.
- Design and adhere to Master Data principles and other relevant policies as defined by the BDM and data stewards.
- Maintaining expert knowledge on the data quality tools and processes.
Informatica Developer & Reporter
AXISCADES
06.2013 - 07.2015
- Understand the business requirement specifications provided by the client and translate them into ETL design specification, load the data into target database.
- Involved in the creation of Low-level design documents and test plans.
- Involved in discussing Requirement Clarifications with multiple technical and Business teams.
- Designed and developed mappings using Informatica Power Center 8.6.
- Developed mappings with different kind of transformations for loading data to target tables.
- Most of the transformations were used like the Source qualifier, expressions, and joiner, Aggregators, Lookups, Filter, Rank and Update Strategy.
- Developed workflows using different kind of tasks and sessions.
- Worked on change requests and enhancements to the already existed mappings.
- Performed error checking and testing of ETL procedures and programs in session log to ensure successful completion.
- Handling post Go-Live production support.
- AXISCADES Engineering Technologies Limited is one of India’s leading technology solutions provider, catering to the futuristic needs of Aerospace, Defense, Heavy Engineering, Automotive and Industrial Production sectors.
- Client: AIRBUS (Aircraft Manufacturing Company)
ETL Developer & Data Analyst
Tesco HSC
01.2013 - 04.2013
- Prepared Jobs Flow Diagram(JFD) and test specification for Informatica jobs.
- Involved in job development.
- Created mapping document.
- Migrate the data from multiple sources to Sql database.
- Cleansing some unwanted information from the existing OLTP database.
- Implement the Star schema and apply SCD I and SCDII depends upon the requirement.
- Do some sample testing after completion of transformation.
- Understand requirements, design formats, deploy formats, follow up with Business development Team, Client Services Department, and Quality team and validate data.
- Prepare Quality dashboards to report progress made through quality initiatives and report overall quality level in the organization.
- Mapping of Data to provide trend analysis and make notes regarding consistency in performance and information collected.
- Day-to-Day Analysis of MIS Reports. Prepare various reports such as Forecast vs. Actual response and so on related to various departments within the organization.
- Handling online Employee stratification report on Poland Thailand Ireland & Tesco HSC.
- Tesco Hindustan Service Centre (HSC) located in Bangalore, India is the operations and technology center for Tesco worldwide.
Developer & MIS Reporter
AMALGAMATED BEAN COFFEE TRADING COMPANY LIMITED
07.2011 - 01.2013
- Responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications.
- Involved in business analysis, technical design sessions with business and technical staff to develop requirements document and data modeling with design of Data Warehouse, data marts.
- Developed standard and re-usable mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy, etc.
- Data quality checking and interacting with the business analysts.
- Communication with the client for weekly status report.
- Created the unit test cases for mappings developed and verified the data.
- Conducted the peer review and debugging for mappings developed and tested.
- Cafe Coffee Day is India's favourite coffee shop for the young and the young at heart. We're part of India's largest coffee conglomerate, Amalgamated Bean Coffee Trading Company Limited (ABCTCL).
Education
B.Tech/B.E. -
Anna University
01.2011
12th -
Tamil Nadu01.2007
10th -
Tamil Nadu01.2005
Skills
- Data management and quality
- Informatica Cloud IDMC
- Team leadership
- System architecture
- Data quality rules
- ETL development
- Vendor onboarding
- Technical documentation
- Vendor management
- UNIX operating system
- Power BI analytics
Certification
- Informatica Business 360 foundation
- Advance Excel in smart sheet
- Informatica MDM SaaS Foundation Certification
- Informatica CDI PC
- Informatica Cloud Data Governance & Catalog Foundation Series
- Data Governance Champion
- Informatica foundation level certification- IICS
Languages
- Tamil
- English
Timeline
Manger -IDMC consultant
VIATRIS
01.2022 - Current
Senior Project Engineer
Wipro
09.2019 - 12.2021
Senior Associate
Cognizant Technologies Solutions
08.2018 - 09.2019
Data Quality Analyst
Thomson Reuters
08.2015 - 08.2018
Informatica Developer & Reporter
AXISCADES
06.2013 - 07.2015
ETL Developer & Data Analyst
Tesco HSC
01.2013 - 04.2013
Developer & MIS Reporter
AMALGAMATED BEAN COFFEE TRADING COMPANY LIMITED
07.2011 - 01.2013
B.Tech/B.E. -
Anna University