Sirojiddin S.

Data Engineer

Sirojiddin is a Data Engineer with over six years of experience in developing Business Intelligence and Big Data solutions. His expertise spans various data stacks, including SQL Server Data Stack (T-SQL, SSIS, SSRS, SSAS). He is proficient in programming languages like Python and C#, and is adept with monitoring tools such as Apache Airflow.

Sirojiddin has hands-on experience in report development using MS Power BI and SSRS. Additionally, he has a strong background in developing solutions using both on-premise tools and cloud technologies. His cloud expertise includes MS Azure Stack (ADF, ADLS Gen2, Azure Synapse, Azure Databricks), as well as Snowflake and dbt (data build tool).

Hauptkompetenz
  • Apache Spark
    Apache Spark 2 Jahre
  • Azure Data Factory
    Azure Data Factory 4 Jahre
  • CSV 5 Jahre
Andere Fähigkeiten
  • Data Modeling 3 Jahre
  • dbt
    dbt 3 Jahre
  • Apache Hive
    Apache Hive 2 Jahre
Sirojiddin
Sirojiddin S.

Uzbekistan

Erste Schritte

Ausgewählte Erfahrung

Beschäftigung

  • Senior Data Engineer

    Data Integrity Services Inc - 5 jahre 4 monate

    • A solid understanding and great experience in working with different subsets of SQL servers such as DML, DDL, TCL, and DCL Commands.
    • Created and worked with various database objects such as complex stored procedures, multivalued user-defined functions, temporary tables, CTEs, Derived tables, table types, views, and triggers.
    • Wrote complex queries using subqueries, cross-apply, and outer apply.
    • Implemented error handling in T-SQL inside transactions using TRY-CATCH blocks.
    • Implemented performance Tuning of Power BI reports using Performance Analyzer and DAX Studio.
    • Wrote complex DAX queries in order to create calculated columns and measures.
    • Created DAGs, ETL, and ELT processes and monitored jobs using Apache Airflow.
    • Worked on Airflow Performance Tuning of the DAGs and task instance.

    Technologien:

    • Technologien:
    • Apache Spark Apache Spark
    • Azure Data Factory Azure Data Factory
    • CSV
    • Data Engineering
    • Databricks Databricks
    • Microsoft Power BI Microsoft Power BI
    • Azure Synapse Azure Synapse
    • Azure Blob storage Azure Blob storage
    • Snowflake Snowflake
    • MSSQL MSSQL
  • SQL/BI DEVELOPER

    MaxData Solutions LLC - 1 jahr 6 monate

    • Implemented complex joins and subqueries and inserted data from Oracle, IBM DB2, and PostgreSQL databases into SQL server by creating Linked Server and using open query functions.
    • Implemented Performance Tuning on slow-running queries by modifying the properties of SQL server database, creating proper indexes, re-writing bad running queries, and checking execution plan.
    • Used Execute Package Task in order to execute child packages from the master package.
    • Implemented slowly changing dimension type 2 using staging table with T-SQL Merge Statement in SQL Server Integration Services.
    • Created and modified Clustered and Non-Clustered Indexes to optimize the queries using the Index tuning wizard.
    • Normalized the tables and maintained Integrity by using Primary and Foreign Keys.
    • Developed measures with complex dynamic DAX queries to calculate all the required KPIs requested.

    Technologien:

    • Technologien:
    • Azure Data Factory Azure Data Factory
    • CSV
    • Databricks Databricks
    • SQL SQL
    • Microsoft Power BI Microsoft Power BI
    • Azure Synapse Azure Synapse
  • SQL/BI DEVELOPER

    DataSite Technology - 1 jahr 11 monate

    • Created and scheduled various SQL jobs, using SQL Server Agent to perform various administrative tasks;
    • Created stored procedure using nodes method to load XML file data into SQL server tables.
    • Created and used different Database constraints, such as Primary Key, Foreign Key, Unique Key, Check, and NULL, in order to provide referential integrity as well as apply business logic into tables in SQL server.
    • Implemented reverse engineering so as to examine a database or script file in T-SQL
    • Created complex ETL packages to load data from OLTP to Datawarehouse with incremental load using SQL Server Integration Services.
    • Loaded data from various sources, such as a flat file, CSV, Excel, SQL Server, and Oracle Database, into Datawarehouse using SSIS.
    • Used Script Task in order to load data from multiple flat files into SQL Server.
    • Involved in Analyses Services, particularly in building both Tabular and Multidimensional models (OLAP, Cubes) on top of DW/DM/DB and writing complex DAX and MDX queries against the models.

    Technologien:

    • Technologien:
    • CSV
    • SQL SQL
    • Microsoft Power BI Microsoft Power BI
    • SSIS SSIS

Ausbildung

  • BSc.World Economy and International Economic Relations

    UWED · 2014 - 2019

Finden Sie Ihren nächsten Entwickler innerhalb von Tagen, nicht Monaten

In einem kurzen 25-minütigen Gespräch würden wir gerne:

  • Auf Ihren Bedarf bezüglich des Recruitments von Software-Entwicklern eingehen
  • Unseren Prozess vorstellen und somit wie wir Sie mit talentierten und geprüften Kandidaten aus unserem Netzwerk zusammenbringen können
  • Die nächsten Schritte besprechen, um den richtigen Kandidaten zu finden - oft in weniger als einer Woche

Unterhalten wir uns

Jetzt Entwickler:innen finden, die innerhalb von wenigen Tagen starten können. Ohne Risiko.