Summary
Overview
Work History
Education
Skills
Certification
Awards
Timeline
Generic

Amit Kumar Tripathy

Bangalore

Summary

Accomplished Sr Staff Software Engineer at Intuit, specializing in data processing and cloud architecture. Expert in performance optimization and stakeholder management, driving impactful data mesh implementations. Proven track record in designing scalable systems and ensuring compliance with security standards, enhancing operational excellence in data engineering initiatives.

Overview

20
20
years of professional experience
1
1
Certification

Work History

Sr Staff Software Engineer

Intuit
01.2012 - Current
  • Data Processing: Spark, Hive, Hadoop
  • MPP: Redshift, Bigquery, Vertica, Cassandra
  • RDBMS: MSSQL, MySQL
  • Replication: Transacional, Merge, Oracle Golden Gate
  • Data modelling: Star, Snoflake, ER Studio, Kimball Matrix
  • Cloud: AWS, GCP
  • Programming: SQL, Python, TSQL
  • GenAI: LLM Prompt Engineering,RAG and Agentic AI(ReACT) implementation
  • Transforming business requirements to data needs and design/review the data model using correct tech stack.
  • Design and review of architecture while adhering to security and financial audit requirements to comply with SOX, CCPA, GDPR while responsible for performance optimization cost reduction and Operational excellence.
  • Design of scalable, cost effective and efficient data models with minimal operational overhead using tools Idera ER Studio.
  • Stakeholder management and working as multiplier in delivering impact as data engineering team.
  • Defining and implementing Data Mesh (Data product) principle.
  • Driving multiload initiative of GCP along with AWS.
  • Prioritization and scoping of project and resourcing yearly and quarterly planning.
  • Security review and approval of 7216 and PII data at rest and at move.
  • Large scale data migration from inhouse hosted to cloud.
  • LLM based code conversion and orchestration.
  • Design of high available and scalable dbms systems.

Senior Data Warehouse Administrator

Mcafee
10.2010 - 01.2012
  • Company Overview: Intel Company
  • Intel Company

Database Administrator II

Royal Bank Of Scotland Group
02.2007 - 09.2009
  • Company Overview: Royal Bank Of Scotland
  • Transactional replication
  • Setup and maintenance of Logshipping
  • Weekly rebuild index and compression
  • Performance tuning and query optimisation
  • Dead lock/blocking
  • Backup / Recovery/ High availability and Disaster recovery
  • Database patching/upgradation
  • Database security
  • Royal Bank Of Scotland

Database Engineer

Infosys
10.2005 - 12.2007
  • Database Administrator of ERP DB.
  • Data Replication
  • Data compaction and vacuuming.
  • Change Management
  • Access Control
  • Indexing and performance Tuning

Education

Microsoft Certified professional -

01.2012

Bachelor of Technology - Electronics and Telecom

KITS
Bhubaneswar
01.2005

Skills

  • Data processing(ETL)
  • Data modeling
  • High availability design
  • Performance optimization
  • Database management
  • Distributed Syatem
  • Applied AI,LLM,RAG,Langraph Agentic AI
  • Data mesh implementation
  • Stakeholder management
  • Big Data
  • Problem solving
  • Effective communication
  • Team leadership
  • System security compliance
  • Cloud architecture
  • Troubleshooting and resolution
  • Distributed computing
  • System administration
  • SQL

Certification

Microsoft Certified Professional, 2012

Patent filed for AI base code conversion Tool

Awards

  • PD leadership award
  • 5 times star of quarter
  • Performance tuning and query optimisation
  • Coveting business logic to store procedure
  • Backup / Recovery/ High availability and Disaster recovery
  • Change management process and implementation CICD
  • Data modelling
  • Operational excellence
  • Developer in-house tool for monitoring of over 700 database instances.
  • Hands-on SSIS and SSRS integration and reporting service.
  • Hosting HP Polyserv clusters
  • Transactional / Merge and snapshot replication
  • Database clustering
  • Setup and maintenance of Logshipping
  • CDC capture using Oracle Goldengate
  • HA and DR setup
  • Database upgradation
  • Database/user access and security
  • Database resource optimisation
  • Recovering page level data corruption

Timeline

Sr Staff Software Engineer

Intuit
01.2012 - Current

Senior Data Warehouse Administrator

Mcafee
10.2010 - 01.2012

Database Administrator II

Royal Bank Of Scotland Group
02.2007 - 09.2009

Database Engineer

Infosys
10.2005 - 12.2007

Microsoft Certified professional -

Bachelor of Technology - Electronics and Telecom

KITS

Similar Profiles

CREATE PROFILE
Amit Kumar Tripathy