AMALRAJ AROCKIAM
Specialist Data Engineer
CHENNAI
Summary
Results-driven Data Engineer with over a decade of experience in Python development and cloud data engineering, specializing in transforming legacy ETL processes into efficient Python/dbt-core ELT systems. Expertise includes building scalable data pipelines on platforms such as Snowflake and Oracle, enabling advanced analytics through PySpark and Azure Databricks. Proficient in implementing CI/CD practices, ensuring data quality and governance, and mentoring engineering teams to deliver robust, business-impacting data solutions. Recognized for a strategic approach to problem-solving and a commitment to driving innovation in data management.
Overview
10
10
years of professional experience
2
2
Certifications
2
2
Languages
Work History
Specialist Data Engineer
LTIMindtree Ltd.
01.2023 - Current
- Led migration from Ab Initio ETL to Python/dbt-core ELT, reducing technical debt and improving maintainability.
- Designed a modular, version-controlled ELT framework in dbt-core to strengthen data quality, governance, and traceability.
- Built Python/PySpark data ingestion and transformation for Snowflake and Oracle; leveraged Azure Databricks for scalable orchestration.
- Established CI/CD pipelines for automated testing and deployment; mentored junior engineers on Python, SQL, and Databricks best practices.
Specialist Data Engineer
LTIMindtree Ltd.
11.2021 - Current
- Engineered and maintained risk analytics apps (WISER, ADCo, DeltaNormalQuickRisk, ScenarioService) using AWS, Snowflake, and FastAPI.
- Automated data ingestion and monthly reruns with PySpark reduce manual effort and increase accuracy.
- Developed RESTful APIs, integrating AWS S3 and Snowflake for near real-time analytics; improved error handling, unit tests, and documentation.
Senior Software Engineer
HCL Technologies
01.2021 - 10.2021
- Built connectors to fetch/process asset data from AWS sources; integrated with IBM Graph DB for risk analysis.
- Automated functional testing for UDS connectors, increasing test coverage by 10x, and reducing cycle time from 2 days to under 2 hours.
- Configured and managed AWS services for secure, scalable data operations.
Senior Software Engineer
HCL Technologies
05.2019 - 12.2020
- Developed data connectors for security threat intelligence using STIX-shifter, enabling automated threat detection and response.
- Delivered cross-platform security analytics by normalizing and cleansing multi-source data.
Senior Application Developer
BNY Mellon India
08.2015 - 05.2019
- Automated incident report analysis and visualization for IT support teams, improving insights, and reducing manual reporting.
- Built standalone Python applications for mainframe screen monitoring and incident management using GUI automation and email integration.
Education
Bachelor of Technology - Information Technology
RMD Engineering College
Chennai 04.2001 -
Skills
Programming: Python (Advanced), SQL, PySpark
Certification
Databricks Certified: Data Engineer Associate (2025)
Timeline
Specialist Data Engineer
LTIMindtree Ltd.
01.2023 - Current
Specialist Data Engineer
LTIMindtree Ltd.
11.2021 - Current
Senior Software Engineer
HCL Technologies
01.2021 - 10.2021
Senior Software Engineer
HCL Technologies
05.2019 - 12.2020
Senior Application Developer
BNY Mellon India
08.2015 - 05.2019
Bachelor of Technology - Information Technology
RMD Engineering College
04.2001 -