Shashank Ranjan

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.

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.

Bachelor of Technology - B.Tech - Jagan Nath University (2015 - 2019)

AISSCE - Class XII - SSVM (2012 - 2014)

Matriculation - Class X - SSVM (2010 - 2012)