Javed

Assistant Data Engineer

Tata Consultancy Services

Jun 2024 - Present

Spearheaded the design, development, and optimization of scalable data pipelines using Azure Data Factory, Oracle SQL, and SQL Server, supporting large-scale banking data processing and analytics workloads. Built and optimized complex SQL and PL/SQL queries to handle high-volume transactional datasets, improving query performance and ensuring data accuracy for downstream analytics. Designed and implemented Azure Data Factory (ADF) pipelines for SBI Bank, enabling reliable data ingestion and migration from source databases into centralized storage systems. Collaborated closely with cross-functional teams, including business analysts, QA teams, and client stakeholders, to align technical delivery with business and compliance requirements. Monitored, debugged, and optimized long-running and failed ADF pipelines, ensuring smooth execution of critical data workflows and improving overall pipeline reliability and turnaround time. Developed and optimized SQL queries using Microsoft SQL Server Management Studio (SSMS 2014) to process large transactional datasets, manage long-running session jobs, and enhance resource utilization. Strengthened operational efficiency by following best practices in error handling, monitoring, and performance tuning, ensuring stable and scalable data processing for banking applications.