A

Amiya Rout

Data Engineer

Noida, Uttar Pradesh, India5 yrs 6 mos experience

Key Highlights

  • Over 4 years of experience in data engineering.
  • Expert in building scalable data pipelines on Azure.
  • Achieved Snowflake SnowPro Core Certification.
Stackforce AI infers this person is a Data Engineer with expertise in Fintech and cloud data solutions.

Contact

Skills

Core Skills

Data EngineeringAzure DatabricksData AnalyticsEtlJava DevelopmentMicroservices

Other Skills

AlgorithmsAndroid DevelopmentAndroid StudioApache KafkaAzure Data FactoryBloggingC (Programming Language)C++Camunda BPMData MigrationData ScienceData StructuresDatabase Management System (DBMS)Delta LakeExtract

About

Amiya Rout is a Data Engineer with over 4 years of experience specializing in building scalable data pipelines and delivering Lakehouse solutions on the Azure platform. In his most recent assignment, he was responsible for implementing a Banking Risk Data Lakehouse, leveraging Azure Data Factory, Azure Databricks, ADLS Gen2, and PySpark to transform raw data into actionable insights for analytics and regulatory reporting. His role included designing and optimizing Delta Lake tables, automating workflows, and improving data processing performance through PySpark and SQL. Recently achieved Snowflake SnowPro Core Certification with a strong score, validating expertise in Snowflake cloud data platform. Prior to his current role, Amiya worked on large-scale big data ecosystem projects involving Apache Spark for both batch and real-time data processing. He has strong expertise in writing Spark applications in PySpark, performance tuning, and applying Delta Lake optimizations. Before moving into the banking domain, Amiya contributed to projects in e-commerce, where he worked extensively with Java, Spring Boot, Microservices, Kafka, and CI/CD pipelines in OpenShift. He holds solid experience in Agile software development and is known for meeting tight deadlines while maintaining high-quality deliverables. šŸ”¹ Skilled in: - Python, SQL, SAS, PySpark - Azure Data Factory, Azure Databricks, Snowflake - Data Warehousing, ETL Pipelines - Cloud Data Engineering (Azure)

Experience

5 yrs 6 mos
Total Experience
1 yr 2 mos
Average Tenure
10 mos
Current Experience

Publicis sapient

Senior Data Engineer

Aug 2025 – Present Ā· 10 mos Ā· Noida, Uttar Pradesh, India Ā· Hybrid

  • - Achieved the Databricks Certified Data Engineer Associate and Snowflake SnowPro Core certifications.
SnowflakeAzure DatabricksSQLPySparkAzure Data FactoryPython (Programming Language)+1

Ey

2 roles

Senior Data Engineer

Promoted

Oct 2024 – Aug 2025 Ā· 10 mos Ā· Bengaluru, Karnataka, India Ā· On-site

  • Project: Banking Risk Data Lakehouse Implementation
  • Designed, developed, and optimized large-scale data processing pipelines using PySpark on Azure Databricks to handle terabytes of data efficiently.
  • Leveraged Delta Lake for building reliable, scalable, and high-performance data lakes, ensuring ACID transactions and schema enforcement.
  • Performed performance tuning and optimization of Spark jobs by implementing techniques such as partitioning, caching, broadcast joins, and resource allocation adjustments.
  • Utilized Azure cloud services for seamless integration, storage, and computation, ensuring cost-effective and scalable solutions.
  • Automated and orchestrated data pipelines using Databricks workflows and integrated with Azure services like Azure Data Lake Storage (ADLS).
  • Technology & Tools Used: PySpark, Azure Databricks, Delta Lake, ADLS
PySparkAzure DatabricksDelta LakeAzure Data FactorySQLPython (Programming Language)+1

Data Engineer

Feb 2023 – Sep 2024 Ā· 1 yr 7 mos Ā· Bengaluru, Karnataka, India Ā· On-site

  • Project: PSU Bank – Market Risk Automation
  • Currently working in the banking sector domain, writing SAS and SQL queries.
  • Automated 15+ key RBI-regulated reports using SAS and SQL, streamlining report generation and formatting while reducing manual effort by 95%.
  • Extracting the huge data generated from Bank, perform the Data Quality (DQ) check and generating insightful reports for the bank.
  • Responsible for maintaining entire ETL jobs. There are around 60 ETL jobs. I have used the SAS Data Integration Studio tool for performing the task.
  • Banking Reports I have Automated - NSFR, LR, CVA, QCCP, AGL, NOOP, FEDAI VaR on AGL, AFS, Forex Limit Monitoring.
  • Also worked on FRTB module of banking domain.
  • Technology & Tools Used: SAS IRM (IFRS 17), SAS DI, SAS EG, SQL, ETL, SAS VA, SAS VIYA
Data AnalyticsSAS Enterprise GuideSAS Data Integration StudioSQLExtractTransform+4

Amdocs

Software Developer

Feb 2022 – Feb 2023 Ā· 1 yr Ā· Pune, Maharashtra, India Ā· Hybrid

  • Claro Puerto Rico: (Java Backend Developer)
  • Working in Java, Spring Boot, and Microservices technology.
  • Enhancing the software according to the business need, writing clean code, performing unit and component testing, resolving sonar issues, testing and debugging it locally.
  • Run the CI and CD pipeline to test the software in the OpenShift environment.
  • Using Kafka for the messaging system.
  • Using WireMock for mocking the external API.
  • Currently Working on an e-commerce domain project.
JavaSpring BootApache KafkaJUnitMicroservicesJava Development

Geeksforgeeks

3 roles

Technical Content Engineer

Feb 2021 – Aug 2021 Ā· 6 mos

  • Coordinate and work with the Technical Content Team for creating and reviewing quality Data Structure and Algorithm, Java, Android, Data Science, and ML content for the website.
  • Creating quality technical videos for GeeksforGeeks official YouTube channel and make strategies to grow their YouTube channel.
  • Design 3 Tutorials in Android along with reviewed more than 500 Data Structure and 600 Java, Data Science, Android technical articles.
  • Managed a team consisting of 5 freelancers. I have learned how to manage a team, it may be a small team but I successfully managed it and increase the article contribution by 5 times more.

Technical Content Writer and Reviewer

Jun 2020 – Feb 2021 Ā· 8 mos

  • After written, more than 50 articles at GeeksforGeeks got a promotion to the Technical Content Reviewer role. Responsible for reviewing the article written by other geeks.

Technical Content Writer

Mar 2020 – Jun 2020 Ā· 3 mos

  • I write articles related to the R programming language, Android, Data Science, and other computer science subjects. This is a work from home internship. I am rewarded for the article depending on the technical complexity, feedback, and reviews of the article. I am now at a medium level of content writer at geeks for geeks. Check out my published articles here: https://auth.geeksforgeeks.org/user/amiyaranjanrout/articles

Devopscube

Blogger

May 2020 – Aug 2020 Ā· 3 mos Ā· Work From Home

  • Publishing interesting DevOps related articles. Check out my published articles here:
  • https://devopscube.com/author/amiya/

Nimble tech

Data Science and Machine Learning Intern

Apr 2020 – May 2020 Ā· 1 mo Ā· Bhubaneshwar, Orissa

Education

Odisha University of Technology and Research

Master of Computer Applications - MCA — MCA

Jan 2018 – Jan 2021

FM University

B.Sc — Physics

Jan 2015 – Jan 2018

FM Junior College, Balasore

I.Sc — Science

Jan 2013 – Jan 2015

Stackforce found 100+ more professionals with Data Engineering & Azure Databricks

Explore similar profiles based on matching skills and experience