Vaibhav Solanki

Software Engineer

Bhopal, Madhya Pradesh, India4 yrs 9 mos experience

Most Likely To Switch

Key Highlights

Proven expertise in SQL and ETL tools.
Strong analytical skills with a focus on data quality.
Experience in optimizing database performance.

Stackforce AI infers this person is a Data Engineer with expertise in ETL and database management.

Contact

Skills

Core Skills

SqlDatabase ManagementEtlData Engineering

Other Skills

Analytical SkillsAnalyticsAzure Data FactoryBig DataC (Programming Language)DWHData AnalysisData AnalyticsData PipelinesData ReportingData WarehousingDatabase DesignDatabase Management System (DBMS)ETL ToolsETL tools

About

As an experienced data professional with 3 years of hands-on experience in SQL, PL/SQL, ETL tools, Databases (SQL server, MySQL, Vertica, and Oracle), Azure(ADF & Databricks), DWH , Python, and PowerBI .I have proven expertise in working with a variety of data tools and technologies. My passion for data has drivenme to excel in my role, where I have worked with different ETL tools such as Talend open Studio and Informatica. Throughout my career, I have demonstrated my ability to create and modify workflows for data loads in tables, as well as design and modify database structures to meet business requirements. I am committed to delivering high-quality data solution , and have worked closely with business stakeholders to fix data quality and unavailability issues within tight deadlines for weekly and month-end activities. Skills: • ETL tools: Talend Open Studio, Informatica . • Databases: MySQL, Oracle, Vertica ,Microsoft SQL Server . • Programming Languages: SQL, PL/SQL, C, Python . • Big Data , Hadoop ,Hive . • Tools: Excel, Power BI . • Azure Cloud , ADF and Azure Databricks. • Excellent problem-solving and analytical abilities .

Experience

Spektra systems

SDE 1

Jun 2024 – Present · 1 yr 9 mos · Bengaluru, Karnataka, India · Remote

Avendata

SQL Developer

May 2023 – Jun 2024 · 1 yr 1 mo · Remote

1.Developed and maintained a web application for archiving structured and unstructured data, ensuring compliance with legal storage requirements.
2.Collaborated with a multi-disciplinary team using JIRA software to plan, track, and release software updates.
3.Designed and created database tables using MySql Workbench, transforming raw client data from Excel sheets into a format that can be easily queried and accessed.
4.Built advanced SQL queries and stored procedures to generate data reports, delivering key insights to clients and stakeholders.
5.Improved SQL query performance by creating and modifying indexes and optimizing query structures, resulting in faster query response times.
6.Developed, implemented, and optimized stored procedures and functions using T-SQL, increasing application performance and stability by identifying and resolving issues at the root cause.
7.Analyzed and resolved issues in view scripts, ensuring that data is accurately represented and easily accessible to end-users.
8.Maintained a high level of attention to detail while debugging code and resolving errors to ensure that the application operates smoothly and efficiently.
9.Demonstrated strong analytical skills and a deep understanding of database architecture and design principles.

MySQLT-SQLSQLExcelData AnalysisData Reporting+3

Wipro

Project Engineer ( Data Engineer )

Nov 2020 – Oct 2022 · 1 yr 11 mos · Bengaluru, Karnataka, India

1. Demonstrated expertise in ETL tools such as Talend Open Studio and Informatica to perform large-scale data loads.
2. Extensive knowledge of databases like MySQL, Oracle, and Vertica, and proficient in programming languages such as SQL, PL/SQL, and Python. Daily worked with these languages to
create new codes according to new requirements.
3. Accomplished in creating and modifying workflows to optimize data loading processes, building and modifying database structures to meet business needs.
4. Proven ability to fix data quality and availability issues within tight deadlines, enabling smooth weekly and month-end activities.
5. Strong project coordination and management skills, successfully managing project plans and guiding teams to achieve their goals.
6. Experienced in developing and documenting engineering procedures and processes.
7. Passionate about optimizing data processes, problem-solving, and achieving goals.
8. Proficient in tools such as Excel and Power BI, to provide valuable insights and analytics to stakeholders.