Huseyn Mammadov

Data Engineer

Summary

Experienced Data Engineer with over five years of expertise in advanced T-SQL, complex ETL processes, and data warehousing. Proficient in Python, C#, MSSQL, PostgreSQL, and MySQL, with hands-on experience in SSIS, Pentaho, Airflow, and dbt. Skilled in developing and optimizing stored procedures, user-defined functions, and data pipelines. Adept at creating interactive dashboards using Plotly Dash and managing Dataiku platforms. Demonstrated ability to tackle technical challenges and enhance data integrity in projects such as IFRS 17. Fluent in English, Azerbaijani, and Turkish.

Professional Experience

Data Engineer / Pasha Insurance, Baku (08/2021-Present)
  • Utilize advanced T-SQL techniques to develop and optimize stored procedures, user-defined functions, views, and cursors.
  • Implement error and event handling mechanisms to ensure the reliability and maintainability of ETL processes.
  • Import and export data from diverse sources using SSIS/DTS utility to streamline data workflows.
  • Leverage C# within the script component of SSIS for dynamic ETL package development.
  • Define and implement data warehouse structures for comprehensive data analysis and reporting.
  • Resolve technical and data-related challenges, ensuring accurate and efficient data processing.
  • Execute data quality tasks and manage data pipelines using Python, dbt, and SSIS.
  • Create interactive Dash Apps for data visualization using Plotly Dash.
  • Administer the Dataiku Platform to streamline data science workflows and improve collaboration.
Data Engineer / Agile Solutions, Baku (10/2019-08/2021)
  • Developed and deployed dashboards and reporting interfaces using BI platforms.
  • Generated SQL queries for data extraction, summarization, and ad-hoc reporting.
  • Resolved technical and data-related issues, aligning with business requirements.
  • Provided insights in meetings on analysis and reporting topics.
  • Designed and developed Oracle SQL databases, including packages, functions, and procedures.
  • Managed automated and manual ETL jobs, ensuring performance measurement.
  • Standardized ETL processes, ensuring data integrity and validation with JavaScript.
  • Utilized Pentaho for ETL development and scheduling on Linux.
  • Translated business requirements into technical architecture and implementation plans.
  • Designed data warehouse systems using Star Schema and Snowflake models with Oracle RDBMS.

Education

Bachelor of Engineering in Computer Engineering / Qafqaz University, Baku, Azerbaijan
  • Awarded the Presidential Scholarship
  • Achieved a weighted average of 80/100
M.S. in Informatics (In Progress) / Sapienza University of Rome, Rome, Italy
  • Completed all coursework with a weighted average of 26.45/30.0
  • Pending thesis completion

Skills