Looking for a job

Akshay Mande

@akshaymande

Data Engineer at LTIMindtree supporting SAB, who built a manual file upload portal for loading business files into the data warehouse.

Saudi Arabia

Message

At LTIMindtree, I design Teradata SQL solutions and IBM DataStage pipelines for SAB, and troubleshoot production job failures. I also lead a PII masking team as part of a data governance initiative across the data warehouse platform.

At Synechron Technologies, I led the SCD2 implementation track for master tables and built a Manual File Upload Portal to load business files into the data warehouse. I also developed semantic views using the FSLDM data model and automated recurring tasks with shell scripts.

At Teradata India Pvt Ltd, I worked on data loading and transformation for Unilever, then supported Teradata databases for Koninklijke Philips, including its migration to AWS. I hold Teradata Certified Database Associate, ITIL V3 Foundation, and Azure AZ-900 certifications.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

LTIMindtree

Feb 2024 - Present (2 years 8 months)

Collaborated with business analysts and users to gather requirements and deliver data solutions. Developed and optimized complex Teradata SQL queries, views, and stored procedures, and designed ETL pipelines using IBM DataStage.

Teradata IBM DataStage Control M BTEQ PII Masking Data Governance Production Support

Data Engineer

Synechron Technologies

Mar 2022 - Feb 2024 (1 year 11 months)

Led SCD2 implementation for master tables and loaded history into CDM tables. Developed semantic views using FSLDM, built a manual file upload portal with Python, and supported ETL jobs and automation.

SCD2 Teradata BTEQ FSLDM Python Shell Scripting Control M DataStage Unit Testing UAT

Teradata Developer

Teradata India Pvt Ltd

Aug 2019 - Mar 2022 (2 years 7 months)

Worked on data transformation and loading using Teradata utilities like BTEQ, Fast Load, TPT, and MLOAD. Performed performance tuning, unit testing, and UAT to ensure data accuracy.

Teradata BTEQ FASTLOAD TPT MultiLoad Performance Optimization Statistics Collection Unit Testing UAT

Teradata DBA

Teradata India Pvt Ltd

Nov 2017 - Aug 2019 (1 year 9 months)

Managed Teradata servers, supported version upgrades and migration to AWS cloud. Handled database outages, automated operations with shell scripts, and provided performance recommendations.