Chandrakant Singh
Serving Notice Period | Data Platform & Engineering | Big Data & ETL/ELT Specialist | Python, PySpark, Airflow | AWS | 3+ Years Experience.
Hire this person
Send a job offer directly to this candidate
About
Data Engineer with 3+ years of experience in designing, building, and optimizing scalable data pipelines, ETL processes, and cloud-based data warehouse solutions. Proficient in Python, SQL, and PySpark, with hands-on expertise in AWS (Redshift, Glue, S3, EMR), and Hadoop ecosystem.
Experience
Data Engineer at Lenskart (2025-03 – Present)
Data Engineer at Lenskart focused on optimizing SQL queries, developing ETL pipelines, and implementing Spark optimization techniques
- Optimized a long-running SQL query, reducing execution time from several hours to 7 minutes, significantly improving performance and system efficiency
- Developed a generalized Python script to securely execute multiple types of SQL queries (SELECT, INSERT, UPDATE, DELETE) from a single interface, improving code reusability and maintainability
- Developed robust ETL pipelines in Python to ingest and transform data from diverse sources including AWS S3, GCP, MySQL, and MongoDB into AWS Redshift for centralized analytics and reporting
- Implemented Spark optimization techniques such as caching, multithreading, and broadcast joins, resulting in a 20% decrease in processing time for handling a daily load of around 2 Million records
Engineer at IndiaMART InterMESH Limited (2023-08 – 2025-02)
Engineer focused on creating business-critical data warehouse projects and developing APIs for operational teams
- Led the creation of business-critical projects in the data warehouse that empowered the Business Intelligence team, minimizing manual interventions and unlocking new insights
- Enhanced facts and dimensions logic by identifying and eliminating erroneous logic, ensuring more reliable and accurate data models
- Developed an API using PL/SQL, Datamart on Redshift, Materialized View, View, procedure on AWS RDS integrating on ERP screen for various Operations Team Performance Evaluation hosted on AWS Lambda, AWS API Gateway
Associate Engineer - Software Programming at IndiaMART InterMESH Limited (2022-08 – 2023-07)
Associate Engineer developing and optimizing facts, dimensions, and ETL/ELT pipelines for data warehouse
- Achieved 20% cost optimization in AWS Redshift by auditing and eliminating unused facts, dimension and datamarts, reducing overall storage and operational costs
- Developed and implemented various facts and dimensions, based on business requirements
- Optimized the refresh time of facts and dimensions by refining procedures, views, and scripts written in PySpark and PL/SQL, improving data processing performance
- Worked on ETL/ELT pipeline to ingest billions of rows of the data in the Data lake, Data Warehouse
Associate Software Engineer - Trainee at IndiaMART InterMESH Limited (2022-01 – 2022-06)
Trainee Associate Software Engineer working with Big Data team to understand big data tools and technologies
- Provided data to different business teams as per the business requirement
- Worked in Big Data team to understand various big data tools and technologies
Education
Bachelor of Technology in Computer Science Engineering – Harcourt Butler Technical University (2018-08 – 2022-07)
Senior Secondary School – Sri Chaitanya Junior Kalasala (2014-04 – 2016-03)
