Dinesh babu S V
Verified Expert in Engineering
Data Engineer and Developer
Dinesh is a data engineer with a decade of experience in the IT industry. He's keen on build release management, software configuration, design, development, and cloud implementation for projects involving ETL, data warehouse, and data analytics on different databases. With a recent master's degree in data science and artificial intelligence, Dinesh is looking to contribute to ETL or data analytics projects.
Portfolio
Experience
Availability
Preferred Environment
MacOS, DBeaver, PyCharm, Amazon Web Services (AWS), Sublime Text, Visual Studio Code (VS Code), Slack, Postman
The most amazing...
...project I've owned is a timely-delivered data migration for a leading wealth management client in the UK that included frequent interaction with stakeholders.
Work Experience
Lead Data Engineer
BigTapp Analytics Ltd
- Developed AWS Batch jobs and AWS Lambda for ETL and data quality.
- Extensively worked on back-end testing for data integrity tests in AWS.
- Designed and deployed an automation framework for data and API validation using Python.
- Worked with program managers, requirement analysts, mappers, developers, and other testers to resolve requirements and mapping transformation issues.
- Performed proof of concept on PySpark to load data from S3 into Redshift.
- Provided documentation and maintenance of mapping documents on Confluence.
Team Lead
Intellect Design Arena Ltd
- Led a 6-member team as the onsite coordinator for a data migration project in the UK.
- Developed mapping for fact loading from various dimension tables.
- Contributed to logical and physical data modeling for the new data warehouse.
- Developed and automated the CSV comparison tool and XML validation using R programming for various manual tasks.
- Worked on customer segmentation using the k-means clustering algorithm on Python using the scikit-learn library.
- Carried data mining, data segregation, and data mockup for all possible scenarios.
IT Analyst
Tata Consultancy Services
- Analyzed existing ab-initio scripts for the respective portfolios and cross-checked them with the latest TSD.
- Designed intuitive development logic for better performance and quality.
- Created a dependency matrix between different portfolios.
- Performed design preparation for converting ab-initio scripts to Netezza SQLs.
- Communicated and shared knowledge about the design flow for each portfolio with the team.
- Reviewed SQLs prepared by the team and ensured they covered all scenarios and fulfilled all coding standards.
- Received appreciation from the delivery head for higher commitment toward the project.
Associate
Cognizant
- Worked closely with the business team to prepare RTM, SQL scripts, execution, and sign-off for multiple datawarehouse projects.
- Prepared high-level test scenarios covering all business and functional requirements.
- Performed static analysis on a data model and prepared a clarification document.
- Gathered requirements and discussed onsite with the clients to understand the business logic.
Experience
Generating SQL Statements Based on Text
This project has many use cases like helping beginners auto-correct the code and supporting BAs to write simple SQL statements for ad-hoc queries.
Electric Vehicles Solution Recommendation Using Neo4j
Skills
Languages
SQL, Python 3, Excel VBA, Snowflake, Python, R
Platforms
Oracle, MacOS, Amazon Web Services (AWS), Visual Studio Code (VS Code), AWS Lambda, Unix
Storage
DBeaver, Relational Databases, PostgreSQL, Netezza, Redshift, PL/SQL, Neo4j, Amazon S3 (AWS S3), SQL Server Integration Services (SSIS), Graph Databases
Other
Data Engineering, Data Warehousing, SQL Server 2015, Analytics, Data Analytics, Data Visualization, Big Data, Data Modeling, Deep Neural Networks, Time Series Analysis, SAP Business Object Processing Framework (BOPF), GraphDB
Paradigms
ETL, Business Intelligence (BI)
Libraries/APIs
Spark ML
Tools
PyCharm, Sublime Text, Slack, Postman, Amazon Elastic MapReduce (EMR), AWS Batch, Amazon Simple Queue Service (SQS), HP Quality Center (QC), Abinitio
Education
Master's Degree in Data Science
Data ScienceTech Institute - Paris, France
Certifications
Neo4j Certified Professional
Neo4j GraphAcademy
AWS Certified Cloud Practitioner
Amazon Web Services
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring