varanasi Rohit
@varanasirohit
Versatile Senior Data Engineer with expertise in cloud-native ETL solutions.
What I'm looking for
I am a Senior Data Engineer with over 10 years of experience in developing and optimizing applications that align with business objectives. My expertise lies in delivering large-scale, cloud-native ETL/ELT solutions across AWS, Azure, and Snowflake ecosystems. I have successfully designed and implemented robust ETL pipelines leveraging Snowflake, AWS Glue, dbt, and Informatica, enabling efficient ingestion, transformation, and reporting on high-volume transactional data.
Throughout my career, I have demonstrated a strong ability to migrate databases to Snowflake environments and have extensive hands-on experience with Snowflake architecture, including virtual warehouses, databases, schemas, and resource monitors. I pride myself on my proficiency in Snowflake SQL for data transformations and complex analytical queries, as well as my experience in high-velocity stream processing with Apache Spark. My commitment to continuous improvement and innovation drives me to develop scalable and reusable data processing components that enhance data integration and accelerate insights delivery.
Experience
Work history, roles, and key accomplishments
Senior Data Engineer
Lithia Motors
Mar 2024 - Present (1 year 5 months)
Designed and implemented modular ETL frameworks using AWS Glue, Snowflake, and dbt, enabling scalable and reusable data processing components. Engineered end-to-end pipelines integrating PySpark, dbt, and Snowflake, ensuring seamless ingestion from diverse financial systems.
Senior Data Engineer
State Farm Insurance
Sep 2022 - Jan 2024 (1 year 4 months)
Designed and implemented scalable ETL platform on Azure using Snowflake as the core data warehouse, driving improved data integration and accelerating insights delivery. Developed and managed data integration workflows to load data from various sources into Snowflake using tools like Snowpipe, ETL/ELT frameworks, and third-party connectors.
Data Engineer
Digital Reality
Dec 2021 - Aug 2022 (8 months)
Worked on AWS Glue, S3, EMR for the migration process and involved in creating Hive tables, Partitioning, loading, and analyzing data using Hive queries. Used Spark APIs to perform necessary transformations and actions for building the data model as per the requirement.
Data Engineer
Paytm
Jun 2019 - Aug 2021 (2 years 2 months)
Created Databricks jobs using Spark Scala code and processed streaming data through Spark jobs where the source was Kafka. Executed Spark jobs on cleaned data to calculate cumulative user investments on a daily and overall basis.
Hadoop Developer
NDT Technologies
Aug 2015 - Jun 2019 (3 years 10 months)
Developed and designed new applications based on detailed business requirements, ensuring alignment with organizational objectives. Optimized existing applications for enhanced performance, scalability, and user experience.
Education
Degrees, certifications, and relevant coursework
University of New Haven
Masters in Business Analytics, Business Analytics
Specialized in Business Analytics, focusing on data-driven decision-making and analytical methodologies. Gained expertise in leveraging data for strategic business insights.
Gitam University
Bachelors in Information Technology, Electrical and Communications Engineering
Majored in Electrical and Communications Engineering, building a strong foundation in technology and engineering principles. Developed skills in various aspects of information technology.
Tech stack
Software and tools used professionally
Amazon Redshift
Matillion
Azure Synapse
Apache Spark
AWS Glue
Data Studio
Amazon EC2
Google Cloud Platform
Google Cloud Storage
Azure Storage
AWS Step Functions
GitHub
GitLab
Kubernetes
Jenkins
GitLab CI
PySpark
dbt
Sqoop
PostgreSQL
MongoDB
Memcached
Cassandra
Hadoop
HBase
Gmail
Yarn
Databricks
Redis
Terraform
Azure DevOps
JSON
PowerShell
Kafka
Grafana
Prometheus
Azure Monitor
Amazon DynamoDB
Zookeeper
Linux
The Hive
AWS Lambda
Serverless
Azure Functions
Azure SQL Database
Apache Tomcat
Airflow
Azure Analysis Services
Time Analytics
Amazon EMR
SQL
Core Data
Azure Blob Storage
Amazon EventBridge
Availability
Location
Authorized to work in
Job categories
Skills
Interested in hiring varanasi?
You can contact varanasi and 90k+ other talented remote workers on Himalayas.
Message varanasiFind your dream job
Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
