profile-pic

Rajan Sainher

A software professional with over 3+ years of experience specializing in SQL, Database Management Systems, and programming languages such as PySpark, SparkSQL, PL/SQL, T-SQL, and Python. Proficient in various Big Data Technologies including Databricks, Azure SQL Database, MongoDB, Data Lake, DLT, Azure Synapse Analytics, and Azure Data Factory. Skilled in data modeling, query optimization, and performance tuning with hands-on experience in creating and managing database objects.
  • Role

    Associate Data & Databricks Engineer

  • Years of Experience

    6.25 years

Skillsets

  • T-SQL
  • Multi-hop architecture
  • Spark SQL
  • Database objects management
  • Change Data Capture
  • Big Data Frameworks
  • Azure Synapse
  • Azure DataBricks
  • Pentaho etl tools
  • Python
  • Pl/sql
  • Azure SQL Database
  • Azure Data Factory
  • Query Optimization
  • Performance Tuning
  • Data Modeling
  • PySpark

Professional Summary

6.25Years
  • Dec, 2024 - Present1 yr 4 months

    Senior Data Engineer

    Cognitio Analytics Inc
  • Oct, 2023 - Dec, 20241 yr 2 months

    Associate Consultant

    Celebal Technologies
  • May, 2021 - Sep, 20232 yr 4 months

    Associate Data Engineer

    Celebal Technologies
  • Jun, 2018 - Jul, 2018 1 month

    Cyber Security Intern

  • Apr, 2020 - Jun, 2020 2 months

    Java Developer

    Foxmula - The Smart Way
  • Jan, 2021 - Apr, 2021 3 months

    Associate Data Engineer

    Celebal Technologies
  • Sep, 2017 - Aug, 2018 11 months

    Fund raising volunteer

    Make A Difference

  • Senior SQL Developer

    An Indian Bank

  • Tech Lead/ Data Engineer

    An Indian Bank

  • Sr. Data Engineer

    Automobile Company

  • Databricks Developer

    Agriculture Manufacturing

Applications & Tools Known

  • icon-tool

    Azure SQL Database

  • icon-tool

    Azure Synapse

  • icon-tool

    Azure Databricks

  • icon-tool

    Azure Data Factory

  • icon-tool

    MongoDB

  • icon-tool

    Data Lake

  • icon-tool

    DLT

Work History

6.25Years

Senior Data Engineer

Cognitio Analytics Inc
Dec, 2024 - Present1 yr 4 months

Associate Consultant

Celebal Technologies
Oct, 2023 - Dec, 20241 yr 2 months

Associate Data Engineer

Celebal Technologies
May, 2021 - Sep, 20232 yr 4 months

Associate Data Engineer

Celebal Technologies
Jan, 2021 - Apr, 2021 3 months
    A software professional with over 3+ years of experience specializing in SQL, Database Management Systems, and programming languages such as PySpark, SparkSQL, PL/SQL, T-SQL, and Python. Proficient in various Big Data Technologies including Databricks, Azure SQL Database, MongoDB, Data Lake, DLT, Azure Synapse Analytics, and Azure Data Factory. Skilled in data modeling, query optimization, and performance tuning with hands-on experience in creating and managing database objects.

Java Developer

Foxmula - The Smart Way
Apr, 2020 - Jun, 2020 2 months

Cyber Security Intern

Jun, 2018 - Jul, 2018 1 month

Fund raising volunteer

Make A Difference
Sep, 2017 - Aug, 2018 11 months

Senior SQL Developer

An Indian Bank
    Developed database triggers, functions, and stored procedures using PL/SQL and T-SQL. Optimized SQL queries and performed logic modifications for report migration to Azure. Converted existing Pentaho jobs to Synapse SQL scripts.

Tech Lead/ Data Engineer

An Indian Bank
    Led a team of 5 to develop automated RBS data reporting for a Bank. Developed end-to-end data reporting solutions from Data DWH to Power BI reports. Transformed manual processes into automated procedures using stored procedures.

Databricks Developer

Agriculture Manufacturing
    Created Databricks workflows using PySpark and SparkSQL for data integration. Implemented Multi-hop architecture on delta lake. Developed PySpark Implementation for data cleaning and transformation.

Sr. Data Engineer

Automobile Company
    Implemented efficient incremental loading strategy for data synchronization. Orchestrated migration of data warehouse to cloud-based platform utilizing Azure Cloud services. Designed and implemented incremental loading framework to capture and transfer new and modified data. Employed Change Data Capture techniques for identifying and capturing data changes.

Achievements

  • Developed database triggers, functions, and stored procedures using PL/SQL and T-SQL.
  • Optimized SQL queries and performed logic modifications for report migration to Azure.
  • Converted existing Pentaho jobs to Synapse SQL scripts.
  • Led a team of 5 to develop automated RBS data reporting for a Bank.
  • Developed end-to-end data reporting solutions from Data DWH to Power BI reports.
  • Transformed manual processes into automated procedures using stored procedures.
  • Created Databricks workflows using PySpark and SparkSQL for data integration.
  • Implemented Multi-hop architecture on delta lake.
  • Developed PySpark Implementation for data cleaning and transformation.
  • Implemented efficient incremental loading strategy for data synchronization.
  • Orchestrated migration of data warehouse to cloud-based platform utilizing Azure Cloud services.
  • Designed and implemented incremental loading framework to capture and transfer new and modified data.
  • Employed Change Data Capture techniques for identifying and capturing data changes.

Education

  • XII

    ESS Convent Sr. Sec. School, Agra (2016)

  • B.Tech(CSE)

    UPES, Dehradun (2021)

Certifications

  • Azure fundamentals (az-900)

  • Azure cosmos db developer (dp-420)

  • Azure data engineer associate (dp-203)

  • Databricks professional data engineer

  • Databricks associate data engineer

  • Azure data fundamentals (dp-900)