Nilanjan Mandal

About Nilanjan Mandal

Hi, I’m Nilanjan I graduated in 2019 from Asansol Engineering College with a degree in Applied Electronics and Instrumentation Engineering. I am passionate about cloud computing and enjoy working with platforms such as GCP, AWS. With 6+ years of experience in Data Engineering & Big Data operations, I specialize in managing high-volume data pipelines, cloud migrations, and production-critical platforms across Hadoop, Spark, and AWS environments. I build, migrate, optimize, and support large-scale data ecosystems that power mission-critical business decisions. I am currently employed at HCLTech as a Senior Software Developer, with nearly 6 years of experience in Data Engineering and Big Data support. My role involves managing critical customer data and providing 24/7 production support. My professional background includes developing and maintaining applications using a wide range of technologies and tools. My core expertise lies in ETL applications, Big Data, Data Engineering (both on-premises and cloud), and DevOps.🧠 Core Expertise Big Data Ecosystem (Hadoop, Spark, Hive, HDFS, Impala) Cloud Platforms – AWS | GCP (Associate Certified)| Microsoft Azure ETL & Data Pipeline Engineering SQL Optimization & Debugging Production Support & Incident Management DevOps & Monitoring (Docker, Kubernetes, Git, Grafana, Prometheus) Migration Strategy (Lift & Shift | Split-brain | Non-split brain) You can reach out to me at n••••••••@hotmail.com

Experience

1. Senior Software Developer

   HCLTech

   Aug 2025 — Present

   Currently working within an enterprise data platform team, contributing to the design, development, and delivery of scalable data pipelines in a Teradata-based ecosystem. Focused on building reliable, high-performance workflows while ensuring governance, documentation standards, and structured SDLC practices aligned with business objectives.🧠 Data Engineering & Pipeline Development🧩 Design and develop robust ETL/ELT pipelines aligned with core data engineering principles, supporting analytics, reporting, and downstream consumption layers.🧩 Build and maintain scalable data workflows across warehouse environments, ensuring high availability, strong performance, and data quality.🧩 Implement Slowly Changing Dimensions (SCD) and historical data load strategies to maintain versioning, audit trails, and business traceability.🧩 Optimize complex Teradata SQL queries and enhance workflow efficiency for large-volume enterprise datasets.🧩 Leverage Hive and distributed data platforms where required for structured data processing. SDLC, Governance & Release Management🧱 Prepare Business Metadata Documents (BMT) and comprehensive technical documentation to ensure data lineage, traceability, and architectural alignment.🧱 Follow structured SDLC under Agile methodology, delivering iterative solutions with strong stakeholder collaboration.🧱 Conduct UAT validation to ensure pipelines meet business and functional requirements before production release.🧱 Manage packaging and deployments across SIT and Pre-Production environments, actively monitoring production releases and implementing rollback protocols when necessary.

Education

• Asansol Engineering College

  Graduate , Applied Electronics and Instrumentation Engineering

  2015 — 2019