Lokesh Ajja
Hyderabad
Summary
Results-driven Associate Data Engineer with proficiency in data pipeline development, ETL processes, and Azure services. Skilled in Python scripting and SQL query optimization, contributing to improved database performance and scalable data solutions.
Overview
6
6
years of professional experience
Work History
Associate Data Engineer
Loadshare Networks
Bengaluru
08.2024 - 02.2026
- Designed and developed scalable ETL data pipelines using Azure Data Factory (ADF) and Azure Databricks/PySpark to ingest data from APIs, databases, and flat files into Azure Data Lake Storage Gen2.
- Developed PySpark and Pandas-based data transformation scripts, enhancing data quality through cleansing, enrichment, and aggregation of large datasets.
- Implemented Azure-based data storage solutions, supporting scalable architecture to accommodate growing data needs.
- Developed Python scripts for extracting data from web services/REST APIs and loading it into databases.
- Performed query tuning, indexing, and schema design in PostgreSQL to improve database performance and reduce latency.
- Monitored pipeline performance and resolved failures, establishing logging and alerting mechanisms to ensure reliability.
- Applied CI/CD practices using Git-based repositories and Azure DevOps pipelines for version control, automated testing, and deployments.
- Collaborated with analytics teams to deliver curated datasets for dashboards and business intelligence tools.
Data Associate
Delivery Limited
Hyderabad
03.2022 - 08.2024
- Executed ETL operations with Apache Spark to cleanse, enrich, and integrate data from multiple sources, enhancing data accessibility.
- Designed and maintained data pipelines to ingest, transform, validate, and store data, ensuring reliability and accuracy in data handling.
- Analyzed data to identify trends, providing actionable insights that influenced strategic decision-making.
- Developed data models to support business intelligence initiatives.
- Optimized existing databases for better performance by indexing columns or rewriting queries.
- Monitored database performance and implemented necessary optimizations.
- Utilized cloud services for scalable data storage solutions.
- Prepared documentation for data engineering processes and workflows.
- Maintained version control systems, like GitHub, for tracking code changes.
Integration Developer
Razorpay
Bengaluru
03.2020 - 03.2022
- Implemented APIs to improve user experiences in payment processing systems, facilitating smoother transactions.
- Collaborated with team members to design data architecture solutions that supported system scalability and performance.
- Utilized SQL queries to retrieve and manipulate data from databases.
- Analyzed data sets to identify trends and patterns for reporting.
- Documented technical processes and integration workflows, providing a comprehensive reference for team members and ensuring consistency.
- Maintained documentation of all integration processes for reference purposes.
Software Developer Intern
Mountblue Technologies
Bengaluru
11.2019 - 03.2020
- Developed user-friendly web applications using Python, Django, JavaScript, and React.
- Optimized SQL queries to improve application performance and scalability.
- Integrated third-party APIs into web applications, enhancing functionality and user engagement.
- Integrated APIs into web applications to enhance their capabilities and improve user experience.
- Collaborated with team to design software solutions addressing client requirements and improving user satisfaction.
- Assisted in debugging and troubleshooting software issues, ensuring smoother application performance and reliability.
Education
Bachelor of Engineering Technology - Software Development
St. Joseph's Engineering College
Mangalore08-2019
Skills
- Microsoft Azure
- Data pipeline development
- ETL processes
- Azure services
- Python scripting
- SQL query optimization
- Cloud storage solutions
- Version control management
- API integration
- API development
- Excellent communication
Timeline
Associate Data Engineer
Loadshare Networks
08.2024 - 02.2026
Data Associate
Delivery Limited
03.2022 - 08.2024
Integration Developer
Razorpay
03.2020 - 03.2022
Software Developer Intern
Mountblue Technologies
11.2019 - 03.2020
Bachelor of Engineering Technology - Software Development
St. Joseph's Engineering College