DIVYALAKSHMI R
Data Engineer | ETL Specialist | AWS Cloud | Data Migration
Coimbatore
Summary
Data Engineer with 7+ years of experience in ETL Development, Data Migration, Data Integration, and AWS Cloud technologies. Expertise in designing and implementing scalable data pipelines using Pentaho Data Integration, Oracle SQL/PLSQL, PostgreSQL, AWS S3, Athena, Lambda, and Aurora databases. Proven experience in large-scale financial and insurance domain projects involving data modelling, transformation, migration, validation, and reporting. Skilled in Snowflake, Python development, cloud-based data processing, performance tuning and optimization. Strong experience working in onsite-offshore delivery models, leading teams, code reviews, production releases, and end-to-end SDLC activities.
Overview
7
7
years of professional experience
Work History
Data Engineer
RelevantZ Technologies Services
11.2023 - Current
- Client: BNY
- Project: Issuer Service
- Project Description:
✔Analyzed and migrated data from multiple legacy applications into Oracle-based Turing platform, successfully transforming and validating 40+ critical financial tables.
✔ Created detailed source-to-target mapping documents, reducing migration defects and improving business validation efficiency.
✔ Implemented business rules covering:
- Bonds
- Shares
- Investors
- Corporate Actions
- ✔ Performed reconciliation and validation activities achieving high data accuracy.
✔ Designed ETL pipelines using Pentaho Data Integration.
✔ Led code reviews, test case reviews, and production release activities.
ETL Developer
Nallas Software Solutions Private Limited
01.2019 - 10.2023
- Client: Verisk.
- Project: Stat Implementation System.
- Project Description:
✔ Developed enterprise-scale ETL solutions serving global insurance customers.
✔ Built an AWS-based data ingestion framework using Lambda, S3, Athena, and Aurora DB.
✔ Designed and maintained Pentaho transformations for processing large insurance datasets.
✔ Automated monthly and quarterly reporting processes.
✔ Created source-to-target mapping documents and business validation workflows.
Managed production releases and support activities.
✔ Led an offshore team of three engineers.
Education
BE - CSE
KPR Institute of Engineering and Technology
Coimbatore01.2019
Skills
Data Engineering Skills:
ETL Development, Data Migration, Data Integration, Data Modelling, Data Validation, Data Warehousing
Cloud Technologies:
AWS S3, AWS Athena, AWS Lambda, AWS Glue, AWS Batch, CloudWatch, Aurora PostgreSQL
Databases:
Oracle, PostgreSQL, Aurora DB, SQL Server, Sybase, MySQL
Programming:
SQL, PL/SQL, Python
ETL Tools:
Pentaho Data Integration (PDI), Informatica (Basic)
Data Platforms:
Snowflake
Tools:
DBeaver, PGAdmin, Jira, Git, Bit Bucket SourceTree, Postman
Methodologies:
Agile Scrum, Code Review, Production Support, Release Managemen
Additional Information
• Financial Services
• Banking & Capital Markets
• Insurance Analytics
• Data Migration
• Regulatory Reporting
Key Achievements
• Designed and implemented AWS-based ETL architectures for insurance reporting platforms.
• Reduced manual effort through automation of ETL and reporting processes.
• Involved in various Performance optimization techniques.
• Led offshore team members and ensured successful sprint deliveries.
• Consistently participated in code reviews and production release activities ensuring high-quality deployments.
Timeline
Data Engineer
RelevantZ Technologies Services
11.2023 - Current
ETL Developer
Nallas Software Solutions Private Limited
01.2019 - 10.2023
BE - CSE
KPR Institute of Engineering and Technology