Chandrakant Singh

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.

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

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)