ETL Developer - New York, United States - TechTriad

    TechTriad
    TechTriad New York, United States

    4 weeks ago

    Default job background
    Transportation / Logistics
    Description

    Role: ETL Developer (Data Warehouse)

    Location: NYC, NY – Remote with occasional travel

    Duration: Long Term

    This consultant shall be responsible for maintaining and enhancing of existing ICMS Data Warehouse and any other databases hosted is support of reporting solutions to business Involve in troubleshooting any data issues as and when arisen and resolve help desk tickets . Also, responsible for maintenance and monitoring of ETL jobs by making sure that jobs are completed in timely manner and work with reporting and DBA teams for any query performance tuning and optimization. Responsibility includes deployment of DB structures and ETL packages between environments after r any enhancements and testing of functionality.

    8+ years of experience in designing, development, testing, and support of Data Warehouse and ETL processes as needed.

    Strong experience using SQL Server Integration Services (SSIS), SSAS and SSRS for analysis and report generation.

    Proficient in writing complex T-SQL Queries, Store Procedures, Views and ETL in designing Databases/Data warehouse using SQL server, SSIS and any custom scripts.

    Knowledge of working in Cloud data platforms development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS related to database.

    Experience with Azure Analysis services in AAS Data Model Development, AAS Data model Deployment in Azure, Querying data from AAS to build Reports.

    Experience in developing, optimizing, and administering Tabular Models in 'Azure Analysis services'.

    Knowledge of or working experience with Cognos BI environment or other business Intelligence tool set such as Power Platform BI tools required.

    Experience in maintaining and monitoring of ETL jobs by making sure that jobs are completed in timely manner.

    Experience working with Reporting and DBA teams for any query performance tuning and optimization as required.

    Ability to act independently to resolve issues, excellent communication and interpersonal skills, strong critical & analytic thinking.

    Bachelor's degree in computer science/engineering or related fields