Satwik Payyavula
Data Engineer
London
Summary
Experienced SQL Data Engineer with a proven track record at ELVIRA TECHNOLOGIES PRIVATE LIMITED in London, United Kingdom. Adept at gathering and analysing client requirements to develop robust SQL Data Engineering and Power BI solutions. Expertise in designing, developing, and optimising ETL pipelines using SSIS and Azure Data Factory. Skilled in managing SQL Server databases, ensuring data integrity, security, and high performance. Proficient in building and optimising data models for efficient storage and retrieval, as well as developing actionable Power BI and SSRS reports. Demonstrated ability to implement performance tuning techniques and automate data processing workflows using T-SQL, PowerShell, and SQL Server Agent. Strong collaborator with cross-functional teams to streamline data processes and support data-driven decision-making.
Overview
6
6
years of professional experience
6
6
years of post-secondary education
3
3
Languages
Work History
Data Engineer
ELVIRA TECHNOLOGIES PRIVATE LIMITED
London, England
01.2024 - Current
- Gathering and Analysing Client requirements, understand and convert them into SQL Data Engineering and Power Bi solutions with solid exposure to architecture, analysis, design, testing, deployment.
- Designed, developed, and optimized ETL pipelines using SSIS and Azure Data Factory for seamless data ingestion, transformation, and loading.
- Managed and maintained SQL Server databases, ensuring data integrity, security, and high performance.
- Built and optimized data models for efficient storage, retrieval, and reporting, improving query performance.
- Developed and maintained Power BI and SSRS reports and dashboards, providing actionable insights for business teams.
- Implemented performance tuning techniques, including indexing, partitioning, and execution plan analysis, to enhance database efficiency.
- Automated data processing workflows using T-SQL, PowerShell, and SQL Server Agent , reducing manual efforts.
- Integrated and migrated structured and unstructured data from diverse sources into a centralized data warehouse.
- Collaborated with cross-functional teams to streamline data processes and support data-driven decision-making.
Jr Data Engineer
MEGHA TECHNICAL LIMITED
Hyderabad , India
02.2019 - 05.2021
- Develop and optimize SQL queries for data retrieval, manipulation, and maintenance. Assist in database schema design, defining tables and relationships to support efficient data structures. Create and maintain stored procedures, functions, and triggers to automate tasks and enhance database functionality. Improve performance by analyzing execution plans, optimizing queries, and implementing indexing strategies.
- Design and optimize reports and dashboards using SQL and reporting tools to deliver actionable insights to stakeholders. Conduct data analysis to identify trends, support business decisions, and enhance data-driven strategies.
- Extract data from databases, APIs, and files; transform it for consistency and accuracy; and load it into data warehouses, data lakes, or other storage solutions.
- Design, develop, and optimize automated data pipelines for seamless data flow. Schedule and monitor pipeline tasks to ensure efficiency and reliability, implementing robust error-handling mechanisms for issue resolution.
- Ensure data integrity by implementing robust validation and quality checks. Adhere to data governance policies and security standards to maintain compliance. Develop and maintain comprehensive documentation for data processes and pipelines to support transparency and efficiency.
- Partner with data scientists, analysts, and engineers to understand requirements and deliver optimized data solutions. Engage with stakeholders to gather needs, provide updates, and resolve concerns. Stay current with emerging tools, technologies, and best practices in data engineering to drive continuous improvement.
Education
Master of Science - Project Management
University of Greenwich
London, United Kingdom 09.2021 - 10.2023
Bachelor of Science - Civil Engineering
Jawaharlal Nehru Technological University
Hyderabad, India 04.2014 - 05.2018
Skills
Database management
Database optimisation
Microsoft sql development
T-SQL expertise
SSRS and SSIS
undefinedHobbies and interests
- Music
- Browsing NET
Timeline
Data Engineer
ELVIRA TECHNOLOGIES PRIVATE LIMITED
01.2024 - Current
Master of Science - Project Management
University of Greenwich
09.2021 - 10.2023
Jr Data Engineer
MEGHA TECHNICAL LIMITED
02.2019 - 05.2021
Bachelor of Science - Civil Engineering
Jawaharlal Nehru Technological University
04.2014 - 05.2018
Similar Profiles
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
RAKESH JRAKESH J
Network Engineer at EQL FINANCIAL TECHNOLOGIES PRIVATE LIMITED (Formerly name of INDIAFILINGS PRIVATE LIMITED)Network Engineer at EQL FINANCIAL TECHNOLOGIES PRIVATE LIMITED (Formerly name of INDIAFILINGS PRIVATE LIMITED)
NARENDRA JILKARNARENDRA JILKAR
Assistant Manager at Scootsy Logistics Private Limited (Swiggy Instamart - Bundl Technologies Private Limited)Assistant Manager at Scootsy Logistics Private Limited (Swiggy Instamart - Bundl Technologies Private Limited)