Tushar Halder
Bengaluru
Summary
Accomplished Principal Data Engineer at Fidelity Investments, adept in architecting scalable ETL solutions and pioneering data governance initiatives. Proficient in Snowflake, Oracle PL/SQL and AWS, I excel in mentoring teams and driving compliance with financial regulations, enhancing data integrity and operational efficiency.
Overview
21
21
years of professional experience
1
1
Certification
Work History
Principal Data Engineer / Tech Lead
Fidelity Investment
Bengaluru
01.2021 - Current
- Led development of workspace investment data lake for efficient data ingestion and consumption.
- Designed and implemented ETL pipelines from AWS S3 to enable scalable analytics and reporting.
- Architected solutions for participant account balance, contribution loans, deferrals, and match data domains.
- Engineered security frameworks for data lake platform, enhancing compliance with financial regulations.
- Pioneered data governance initiatives, creating observability tool that improved pipeline monitoring.
- Implemented IcedQ for automated reconciliation and compliance checks to enhance data integrity.
Principal Data Engineer
Workspace Investment Distributed Record Keeping Domain
Bengaluru
01.2017 - 01.2020
- Managed participant account records and data processing using Oracle PL/SQL and Informatica ETL tool for improved accuracy.
- Delivered scalable solutions that ensured compliance with SOX and GDPR regulations.
- Created new RDS instances via YAML templates to optimize AWS cloud infrastructure.
- Implemented automated deployment processes using Jenkins and Concourse pipelines.
- Deployed EC2 instances effectively utilizing CloudFormation for improved resource management.
- Strengthened technical knowledge in workplace investment record keeping practices.
Lead Software Engineer
Fidelity Asset Management Business Unit
Bengaluru
01.2010 - 01.2016
- Collaborated with Fidelity's asset management unit to modernize portfolio and market data systems, enhancing data accessibility and reliability.
- Executed portfolio launch and benchmark index creation, developing custom indices to meet client-specific needs.
- Migrated legacy Index Return Calculation system from manual processes to a modernized platform, improving calculation speed and accuracy.
- Designed ETL pipelines to accurately process high-volume market feeds.
- Delivered analytics dashboards enabling portfolio managers to monitor asset performance and compliance metrics.
Data Engineer / Oracle Specialist
Infosys
Bengaluru
01.2005 - 01.2008
- Engaged onsite with clients in California for 3 years in Electric Utility domain, enhancing project delivery and client relationships.
- Designed and optimized Oracle PL/SQL procedures, triggers, and packages for billing and customer management systems.
- Developed automation scripts in Python and Shell, reducing manual workload by 30%.
- Collaborated with client teams onsite to facilitate migration and ensure compliance with industry standards, resulting in successful project outcomes.
Education
Bachelor of Engineering - Information Technology
Burdwan University
West Bengal08.2002
Skills
- Oracle PL/SQL
- Snowflake
- Spark
- Hadoop
- Kafka
- AWS
- S3
- Glue
- Redshift
- Lambda
- EMR
- RDS
- IAM
- Python
- SQL
- Shell scripting
- ICEDQ
- In-house observability tools
- Client/divisional security models
- Technical strategy
- Agile/Scrum
- Mentoring senior engineers
- Git
- Jenkins
- Concourse
- Docker
- Terraform
- CloudFormation
Websites
Certification
• AWS Certified Solutions Architect - Professional
• Snowflake SnowPro Certification
• Snowflake SnowPro Certification
Accomplishments
• Pioneered Workspace Investment Data Lake, enabling scalable ingestion and consumption pipelines.
• Reduced operational costs by 40% through cloud migration
• Engineered resilient ETL pipelines for large‑scale ingestion, balancing performance with precision to support demanding analytical,AI/ML and compliance use cases.
•Optimized and fine‑tuned client reporting systems to handle massive data volumes with uncompromising precision, ensuring consistent high‑performance delivery under stringent SLA commitments
• Reduced operational costs by 40% through cloud migration
• Engineered resilient ETL pipelines for large‑scale ingestion, balancing performance with precision to support demanding analytical,AI/ML and compliance use cases.
•Optimized and fine‑tuned client reporting systems to handle massive data volumes with uncompromising precision, ensuring consistent high‑performance delivery under stringent SLA commitments
Timeline
Principal Data Engineer / Tech Lead
Fidelity Investment
01.2021 - Current
Principal Data Engineer
Workspace Investment Distributed Record Keeping Domain
01.2017 - 01.2020
Lead Software Engineer
Fidelity Asset Management Business Unit
01.2010 - 01.2016
Data Engineer / Oracle Specialist
Infosys
01.2005 - 01.2008
Bachelor of Engineering - Information Technology
Burdwan University