Data Engineer

Rajasekar C

Production Data Engineer with 5+ years of experience building, operating, automating, and troubleshooting high-volume production data systems. Strong in Python, SQL, PostgreSQL, and Oracle, with hands-on experience in ETL pipelines, data ingestion, data modelling, schema design, and production reliability at approximately 50M records per day.

Key results

50M records/day

Designed and operated production ETL pipelines at scale.

30 min to under 1 min

Built Flask and Pandas automation recognized with the Tech Titan Award.

4000+ issues resolved

Reduced the open production-data backlog from approximately 600 to under 70.

Experience

Digit Insurance

Data Engineer

Nov 2023 - Jun 2025
  • Designed and operated ETL data pipelines processing approximately 50M records per day for high-volume batch data processing and downstream reporting
  • Built a Flask and Pandas automation tool that reduced Vahan issue resolution from approximately 30 minutes to under 1 minute, earning the Tech Titan Award
  • Resolved 4000+ production data issues and reduced the open backlog from approximately 600 to under 70
  • Owned PostgreSQL schema design and DDL versioning in Git; implemented PII classification and secure credential storage for data quality and compliant handling
  • Automated MoEngage customer notification workflows with SQL stored procedures for policy-renewal detection, eliminating redundant alerts
  • Delivered ETL, data-ingestion, and schema work for Bima Satrak regulatory reporting; automated recurring credit-update and Excel-to-database ingestion with SQL and Pandas

Appzwork

Software Engineer

Jan 2020 - Nov 2023
  • Built and maintained Oracle SQL and PL/SQL solutions, stored procedures, and production reports for banking and insurance data systems
  • Owned production support and database incident response, diagnosed root causes, and deployed fixes across client environments
  • Optimized SQL queries and stored procedures to improve database performance under high-usage production workloads
  • Managed production database deployments, maintenance, and recovery across client environments

Skills

Languages

  • Python
  • SQL
  • PL/SQL
  • Shell

Data Engineering

  • ETL
  • ELT
  • Data Pipelines
  • Data Ingestion
  • Data Modelling
  • Data Warehousing
  • Batch Processing
  • Pandas
  • PySpark

Databases

  • PostgreSQL
  • Oracle
  • DB2
  • Redis

Backend

  • Flask
  • REST APIs
  • Stored Procedures
  • Database Design
  • Query Optimization

Data Platforms

  • Databricks
  • ClickHouse

DevOps

  • Docker
  • Git
  • Linux
  • GitHub Workflows

Developer Tools

  • Cursor
  • Claude
  • GPT Codex
  • GitHub Copilot

Other

  • Selenium
  • MoEngage

Education

B.E.

CGPA: 7.17

RMK Engineering College