Recommended expert
Siddharth Nautiyal-Principal Consultant
Check rate
Experience
Jul 2021 - Present
4 years 10 monthsPrincipal Consultant
StatusNeo Consulting
Position Summary
Principal Consultant at StatusNeo Consulting
Industries
Banking and Finance
Retail
Tourism
Business Areas
Business Intelligence
Information Technology
Strategy
- Consulted with CXO-level stakeholders on data strategy, architecture reviews, and modernization roadmaps across Hospitality, Finance, Retail, Sports, and Telecom
- Led an 8-member Data, Analytics & AI team delivering large-scale data engineering and warehousing solutions, mentoring juniors, and collaborating with cross-functional teams for seamless delivery
- Designed and delivered an end-to-end Medallion Architecture on Microsoft Fabric integrating Opera APIs, ReviewPro, SFTP, and on-prem sources
- Implemented Direct Lake models in Power BI, reducing dashboard load times from over 1 minute to under 10 seconds
- Launched an AI-powered Data Agent enabling conversational queries for CXOs
- Enforced role-based access control, governance, and lineage to ensure compliance and security
- Migrated pipelines from Azure Data Factory to Databricks, orchestrating transformations with dbt and Delta Lake
- Integrated Salesforce and RDBMS sources using reusable ETL frameworks with SCD1 and SCD2 handling
- Applied DataOps practices including CI/CD, monitoring, and quality checks for reliability
- Decommissioned the legacy Data Warehouse, cutting daily costs from 250 to 50 USD, achieving $75K annual savings
- Automated P&L reporting with Alteryx workflows and Power BI dashboards, cutting manual effort by 80%
- Designed advanced transformations with Crew Macros, improving reporting accuracy
- Established DataOps pipelines for automated validation and CI/CD
- Built a real-time Cricket Data Analytics Platform ingesting high-frequency JS events into Cassandra
- Developed Flask and OpenAPI microservices deployed on AKS with Docker and Kubernetes for web and mobile APIs
- Delivered real-time streaming and batch processing pipelines balancing low latency and scalability
- Enabled instant match and event updates via FCM push notifications with SSL pinning and parameterized queries for security
- Built preprocessing pipelines for catalog data, establishing Elasticsearch indexes and a Redis serving layer
- Developed FastAPI suggest APIs for high-performance search and deployed them as microservices on AKS with CI/CD
Nov 2020 - Jul 2021
9 monthsConsultant
Deloitte USI
Position Summary
Consultant at Deloitte USI
Industries
Information Technology
Professional Services
Business Areas
Business Intelligence
Information Technology
- Designed and deployed scalable ETL pipelines using Azure Data Factory and Databricks, reducing ETL runtime by 50%
- Built reusable dimension and fact frameworks with SCD1 and SCD2 handling on Delta Lake, improving maintainability and historical accuracy
- Implemented dynamic data masking in Azure Synapse to protect PII and ensure regulatory compliance
- Partnered with cross-functional business teams to translate requirements into scalable technical solutions, improving reporting efficiency and data trust
Jan 2020 - Nov 2020
11 monthsBig Data Engineer
Reddoorz
Position Summary
Big Data Engineer at Reddoorz
Industries
Tourism
Business Areas
Business Intelligence
Information Technology
- Built AWS ETL pipelines with Apache NiFi, Step Functions, and Redshift, optimizing SQL queries and reducing load times by 40%
- Developed Python-based validation and SCD frameworks for Redshift with monitoring and orchestration automated via CloudWatch and Lambda
- Replaced legacy reporting tool Holistic by implementing automated pipelines, reducing CXO report generation from hours to minutes
- Improved data quality and consistency across pipeline outputs, ensuring reliable executive-level reporting
Jul 2017 - Dec 2019
2 years 6 monthsTechnical Associate
Genpact India Pvt. Ltd.
Position Summary
Technical Associate at Genpact India Pvt. Ltd.
Industries
Information Technology
Business Areas
Business Intelligence
Information Technology
- Developed reusable ETL and validation frameworks in Python and Spark with SCD1 and SCD2 logic, improving data consistency across ingestion jobs
- Automated large-scale batch processing pipelines exceeding 100 TB using AWS Data Pipeline, Step Functions, Lambda, CloudWatch, and EMR, reducing manual oversight and improving reliability
- Optimized Amazon Redshift schema design and queries, improving performance and reducing storage and compute costs
- Implemented monitoring and alerting using CloudWatch and integrated workflows with CloudFormation for better orchestration
- Partnered with onshore and offshore teams to deliver data migration and modernization projects under strict SLAs
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Tourism, Banking and Finance, Retail, Information Technology, and Professional Services.
Tourism
Banking and Finance
Retail
Information Technology
Professional Services
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, and Strategy.
Business Intelligence
Information Technology
Strategy
Summary
Accomplished Data Architect with 8+ years of experience helping organizations transform their data into a strategic asset. Proven ability to bridge business and technology by consulting with stakeholders, shaping enterprise architectures, and delivering modern cloud-native platforms. Skilled at leading high-performing teams and guiding clients across industries including hospitality, finance, telecom, sports, power & energy and retail. Hands-on with AWS, Azure, Microsoft Fabric, and GCP, bringing a holistic approach to data engineering, governance, and analytics that drives innovation and competitive advantage.
Skills
- Programming Languages: Python, Sql, Scala
- Rdbms: Mysql, Sql Server, Oracle, Postgresql
- Nosql: Apache Cassandra, Elasticsearch, Redis
- Cloud Platforms – Aws: Redshift, S3, Lambda, Athena, Data Pipeline, Dms, Step Functions, Cloudwatch, Cloudformation, Emr
- Cloud Platforms – Azure: Data Factory, Adls Gen 2, Synapse, Databricks, Devops, Azure Kubernetes Service
- Cloud Platforms – Gcp: Google Cloud Storage, Data Proc, Google Kubernetes Engine (Gke), Bigquery, Fcm For Push Notifications
- Cloud Platforms – Microsoft Fabric: Data Pipelines, Data Flows, Notebooks, Onelake, Data Agent, Deployment Pipelines
- Big Data: Spark, Pyspark
- Backend: Flask, Openapi, Fastapi
- Ci/cd: Docker, Kubernetes, Jenkins
- Advanced Concepts: Scd Type 1 & 2, Incremental Loads, Data Quality, Master Data Management (Mdm), Dataops, Data Migration (100tb+), Real-time Streaming, Batch Processing, Microservices, Data Warehouse
- Data Engineering Tools: Apache Nifi, Informatica Cloud, Alteryx
- Version Control: Git, Bitbucket, Azure Devops
Languages
Hindi
NativeEnglish
AdvancedGerman
ElementaryEducation
Oct 2013 - Jun 2017
AKTU
B.Tech, Computer Science Engineering · Computer Science Engineering · Lucknow, India
Statistics
Experience
Total positions 4
Experience in Tourism 5.5 y
Avg length 2 y 2 m
Longest experience 4 y 9 m
Expertise
Recent roles Principal Consultant, Consultant, Big Data Engineer
Main industries Tourism, Banking and Finance, Retail
Main business areas Business Intelligence, Information Technology, Strategy
Qualifications
Highest degree Bachelor
Profile
Created
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Siddharth based?
Siddharth is based in New Delhi, India and can operate in on-site, hybrid, and remote work models.
What languages does Siddharth speak?
Siddharth speaks the following languages: Hindi (Native), English (Advanced), German (Elementary).
How many years of experience does Siddharth have?
Siddharth has at least 9 years of experience. During this time, Siddharth has worked in at least 4 different roles and for 4 different companies. The average length of individual experience is 2 years and 2 months. Note that Siddharth may not have shared all experience and actually has more experience.
What roles would Siddharth be best suited for?
Based on recent experience, Siddharth would be well-suited for roles such as: Principal Consultant, Consultant, Big Data Engineer.
What is Siddharth's latest experience?
Siddharth's most recent position is Principal Consultant at StatusNeo Consulting.
What companies has Siddharth worked for in recent years?
In recent years, Siddharth has worked for StatusNeo Consulting and Deloitte USI.
Which industries is Siddharth most experienced in?
Siddharth is most experienced in industries like Tourism, Banking and Finance, and Retail. Siddharth also has some experience in Information Technology and Professional Services.
Which business areas is Siddharth most experienced in?
Siddharth is most experienced in business areas like Business Intelligence, Information Technology, and Strategy.
Which industries has Siddharth worked in recently?
Siddharth has recently worked in industries like Banking and Finance, Retail, and Tourism.
Which business areas has Siddharth worked in recently?
Siddharth has recently worked in business areas like Business Intelligence, Information Technology, and Strategy.
What is Siddharth's education?
Siddharth holds a Bachelor in Computer Science Engineering from AKTU.
What is the availability of Siddharth?
Siddharth is immediately available full-time for suitable projects.
What is the rate of Siddharth?
Siddharth's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.
How to hire Siddharth?
To hire Siddharth, click the Meet button on the profile to request a meeting and discuss your project needs.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
600
450
300
150
Market avg: 424-584 €
Market avg: 424-584 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar Freelancers
Discover other experts with similar qualifications and experience
Jorge Machado
View profile
Gerald Gastgeb
View profile
Serge Kalinin
View profile
Marek Werulik
View profile
David Klemme
View profile
Nikolay Tonev
View profile
Max Ritter
View profile
Nikolaus Jäger-grassl
View profile
Felix Bruckner
View profile
Thomas Hoefkens
View profile
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Principal Consultant
Simona Thrussell
AI/Fullstack developer and Architect
View Profile
Christian Schulz
Data-Scientist/AI Engineer
View Profile
Jorge Machado
Data Architect
View Profile
Serge Kalinin
MLOps (machine learning operations)
View Profile
Stephan Fröde
NLP/LLM Chatbot
View Profile
Ritika Solanki
Services Solution Architect
View Profile
Gerald Gastgeb
Data Warehouse Architect and Lead Data Modeler
View Profile
Niko Schmuck
Developing Architect, Technical Lead "gridlytics"
View Profile
Davide Imperati
Consultant – Lead Data Engineer
View Profile
Nikolay Tonev
Senior Cloud Data Architect
View Profile
Nikhil Gyamlani
Co-founder / Solution Architect
View Profile
Nearby freelancers
Professionals working in or nearby New Delhi, India
Dinmukhabet Anuarbekov
The Leading Specialist
View Profile
Sergey Filin
Backend Developer
View Profile
Hikmat Shirmammadov
Head of Accounting
View Profile
Roman Sayapin
Lead Information Technology Project Manager
View Profile
Emin Maharramli
BI Manager
View Profile
Nikolai Shkubelev
Senior Frontend Developer
View Profile
Nick Lelashvili
Senior CRM manager
View Profile
Marie-luise Heinbach
Homologation Engineer
View Profile
Lizi Shavadze
Lecturer in Electrical Engineering
View Profile
Tigran Melik-stepanyan
Full Stack Software Engineer
View Profile
Most recent projects
FRATCH works with many companies and recruitment agencies. Here you will find our recently posted projects and opportunities.
