Abhijith Hegde

About Abhijith Hegde

Advanced SQL coding, tuning and query optimizationKnowledge of database internals as it relates to query and system performance and tuningUnderstanding of overall system architecture, scalability, reliability, and performance in a database environmentExperience designing and leading database performance benchmarks.Hands-on experience in scripting test-automation and execution frameworkExperience in diagnosing and trouble-shooting complex, production softwareHands-on experience in testing open source databases (MySQL, Postgres)Ability to drive tasks to completion and take ownership of projectsAbility to work in a fast paced and agile development environmentMigration of Application using Licensed softwares to Open Source DBReducing cost of application by migrating from existing licensed Databases to Open Source DB Migrating from DB to Open Source DB like PostGreSQL and MYSQL. Performance tuning on high scale Oracle DB environments using. Knowledge of cloud services like AWS EC2,S3,SNS,SES,SQS. Knowledge of migrating data to AWS DB instances from on- premise DB instances.Python scripting,Shell scripting for Automation of Support Activities.

Experience

1. Senior Data Specialist

   Tata Consultancy Services

   Jul 2023 — Present · Bengaluru, IN

   Led End‑to‑End Migration of Master Data from IBM MDM to Reltio- Drove the full lifecycle of migrating Aviva Insurance’s enterprise MDM platform from IBM MDM to Reltio Cloud MDM- Collaborated with business, architecture, and data governance teams to ensure alignment with enterprise data standards and Reltio best practices.2. Designed and Delivered the Reltio Data Model Mapping- Analyzed the existing IBM MDM data structures, entities, relationships, and survivorship rules- Created comprehensive modelling and requirement‑mapping documents translating legacy MDM entities into the Reltio data model- Defined entity types, crosswalks, relationships, attributes, match/merge rules, and survivorship logic for the new platform.3. Led Entity & Relationship Migration for Aviva Insurance- Owned the design and execution of entity‑level and relationship‑level migration strategy- Ensured accurate transformation of customer, policy, product, and interaction data into Reltio’s canonical model- Worked closely with Reltio architects to validate model alignment, match rules, and golden‑record creation.4. Data Validation & Quality Assurance- Partnered with the testing and QA teams to validate migrated data across completeness, accuracy, and referential integrity- Investigated and resolved data load issues, mismatches, and transformation defects during SIT/UAT cycles- Implemented data quality checks and reconciliation logic to ensure a clean cutover to the new MDM system.5. Built Scalable ETL Pipelines for Migration- Designed and developed robust ETL pipelines for data extraction, transformation, and loading into Reltio using- Python- Apache Airflow- Amazon S3- Amazon Redshift

Education

• Vivekananda college of engineering

  Bachelor of Engineering (B.E.), Electrical, Electronics and Communications Engineering

  2005 — 2009

Skills

• Javascript
• Unix Shell Scripting
• Pl/Sql
• Sql
• Core Java
• Finacle
• Oracle
• Requirements Analysis
• Unix
• Java
• Eclipse
• Jsp
• Xml
• Programming