Shashank Ranjan
Data Engineer | AWS | PySpark | Apache Airflow | SQL | ETL | Python
Hire this person
Send a job offer directly to this candidate
About
Data Engineer with 4+ years of experience designing, building, and maintaining scalable ETL pipelines on AWS, with hands-on expertise in PySpark, Apache Airflow, and SQL. Proficient across the core AWS data stack — S3, Glue, Athena, Redshift, Lambda, and IAM — with strong grounding in data modeling and schema design for large-scale, analytics-ready datasets. Experienced in building and orchestrating production-grade Airflow DAGs, improving SQL query performance by up to 20%, and delivering reliable, well-tested data pipelines for business intelligence and reporting.
Comfortable working in fast-moving teams and available to join on short notice.
Experience
Data Engineer - LinkedIn Service Private Ltd.
(2025-04)
- Design and develop scalable ETL pipelines using Python and PySpark on AWS for high-volume data ingestion and transformation.
- Build and maintain automated Airflow DAGs using Apache Airflow for task scheduling, monitoring, and dependency management.
- Collaborate with cross-functional stakeholders to gather data requirements and deliver analytics-ready datasets on AWS.
- Apply data modeling best practices and validation/cleansing processes to maintain data accuracy and consistency.
- Monitor pipeline health using Amazon CloudWatch, resolve data anomalies, and implement performance improvements proactively.
Data Engineer - Startek Solutions
(2024-08 - 2025-03)
- Developed and optimized SQL queries on AWS Redshift for faster data retrieval and summarization, reducing execution times by approximately 20%.
- Built ETL workflows using AWS Glue and Python to integrate data from diverse source systems into a centralized AWS data repository.
- Supported data warehousing operations on AWS, including data ingestion, schema design (data modeling), and pipeline maintenance.
- Performed data audits and applied cleansing techniques to uphold accuracy, consistency, and compliance standards.
- Created data integration processes using AWS services to facilitate seamless and dependable data exchange between systems.
Data Engineer - SSSEL Pvt. Ltd.
(2020-06 - 2023-12)
- Architected and deployed data lake infrastructure on AWS using S3, Glue, and Athena; enabled advanced analytics on large-scale datasets.
- Developed and maintained ETL jobs using AWS Glue and Python, handling complex data ingestion and transformation at scale.
- Designed optimized data models and schemas in Amazon Athena for efficient querying of structured and semi-structured datasets.
- Built and supported ETL frameworks with PySpark to manage high-volume data transformation and processing workflows.
- Collaborated with business stakeholders to translate requirements into scalable, production-ready data solutions on AWS.
Education
Bachelor of Technology - B.Tech - Jagan Nath University (2015 - 2019)
AISSCE - Class XII - SSVM (2012 - 2014)
Matriculation - Class X - SSVM (2010 - 2012)
