Ayush Khatri

SnowPro Core Certified Senior Data Engineer with 6.7 years of IT experience at Amdocs, including over 3 years of hands-on experience with Snowflake and Azure Storage, and 4 years in data warehousing (Vertica and Teradata).

• Expertise in designing and managing Snowflake components — warehouses, databases, schemas, roles, and users — to ensure seamless and secure data operations.
• Proficient in writing complex SQL queries, using statistical and analytical functions, for large-scale ETL data validation and testing.
• Hands-on experience with bulk data loading/unloading using COPY, PUT, GET, and INSERT commands from internal and external stages.
• Strong knowledge of Snowflake architecture, including Query Profiler, caching strategies, and virtual warehouse auto-scaling for optimized performance.
• Skilled in using SnowSQL and Snowpipe for continuous, real-time data ingestion pipelines.
• Solid understanding of ETL processes, data warehousing concepts, and best practices for building scalable, maintainable solutions.
• Adept at collaborating with data analysts and business stakeholders to gather requirements, develop high-quality solutions, and resolve data processing issues.
• Experienced across all phases of the project lifecycle: Requirement Analysis, Design, Development, Testing, and Deployment.

• Received multiple appreciation for quality delivery on time.
• Client Appreciations (Star of the Sprints) in 2024.
• Amdocs shoot the star award winner

Amdocs project: Teradata to Snowflake migration project: Promo modernization (QST rewrite into Snowflake)

Senior Data Engineer
January 2019 – Present

Overview: part of a strategic cloud migration initiative involving the end-to-end transition of enterprise-scale workloads from on-premise Teradata to Snowflake

Key Responsibilities:

• Designed and managed critical Snowflake components, including warehouses, databases, schemas, roles, and users, ensuring optimized performance and security
• Developed reusable scripts to automate Teradata SQL to Snowflake SnowSQL conversions
• Led historical data migration with a focus on data consistency, performance, and integrity
• Created automation wrappers for BAU load file transfer and ingestion into Snowflake
• Collaborated with product owners to gather requirements, implement business logic, and ensure functional accuracy
• Authored robust test cases and performed detailed ETL validations to support seamless data transformation
• Extensively used Postman (NiFi) and curl to transfer files from on-premises to Azure Data Lake Storage (ADLS)
• Implemented scheduling and monitoring of Linux scripts for load orchestration and reliability
• Developed GitHub automation scripts for CI/CD integration, including push and pull automation
• Participated in Agile delivery ceremonies and managed a team of five as project lead
• Delivered multiple user stories with zero post-production defects, and provided ongoing KT (knowledge transfer) to new team members

Overview: Project: Promo Modernization (QST rewrite into Snowflake)

led a critical re-engineering project replacing the legacy QST-based system with a modern Snowflake-based architecture, enhancing scalability, performance, and data accuracy

Key Contributions:

• Fully redesigned legacy logic in Snowflake, avoiding lift-and-shift, and leveraging cloud-native design best practices
• Integrated data from multiple sources (AVT, DVC, TRDIN, Installments) and built scalable pipelines to perform eligibility checks, compliance validations, and prioritization logic
• Enhanced match rates and reduced data mismatches through rigorous data profiling and logic refinement
• Built and tested a highly accurate promotion engine that selects the best offer for each user scenario
• Improved end-user trust and business alignment by minimizing over-enrollment and boosting matching precision
• Appreciated by clients for uncovering complex edge-case issues and providing reliable, scalable solutions
• Contributed equally to development and ETL testing, ensuring robust QA coverage across scenarios

Snow Pro Certified Senior Data engineer

Certification id :- S82006-250712-COF

Declaration: I hereby declare that the above-mentioned information is true and correct to the best of my knowledge.