Rajeev Singh

About Me

I am a passionate data engineer/Programmer with a strong background in designing, developing, and maintaining data architectures. My expertise includes data modeling, ETL processes, and database management.I am constantly learning new stuff.

Medium Articles

• Pythonic Ways of Coding
• Cloud Function — Save Most active stocks in every 2 minute
• Cloud Run — Web App to store ChuckNorris Jokes
• PySpark Tutorial
• Convert JSON into CSV using Python

Video playlist

Python

• LeetCode #3. Longest Substring
• LeetCode #1. Two Sum
• Explore Data Frame Columns

SQL

• LeetCode #571. Find Median Given Frequency of Numbers

Misc

• Future of SQL Scripting

Projects

• Profile data: This project is about profiling any dataset. It gathers info on all the columns/fields in the dataset.
• Pkey Finder FindKey is program to find the key for any CSV data file. If there is no Primary key then It will try to find the composite key. Couple of parameters which is important for program execution.
• DBT Project This project is to understand on how to use the DBT tool. dbt is a data transformation tool that enables data analysts and engineers to transform, test and document data in the cloud data warehouse.
• Mint Transaction Analysis Analysis on the all account transactions from Mint Application. The project is to determine the inflow and outflow of money across all the accounts (saving, checking, Brokerage, credit cards account, 401K, Roth, HSA).

Skills

• Data Modeling
• ETL Processes
• Database Management
• SQL and NoSQL Databases
• Big Data Technologies (e.g., Hadoop, Spark)
• Data Warehousing

Contact me