Data Warehouse / ETL Developer from ALTA IT Services
Hoboken, NJ 07030
About the Job
ALTA is looking for a Data Warehouse / ETL Developer with 8+ years of experience in designing, developing, and supporting Data Warehouse and ETL processes. The ideal candidate should have strong skills in SSIS, SSAS, SSRS, and T-SQL, along with experience working with Azure data platforms and business intelligence tools like Power BI or Tableau. The role also involves maintaining ETL jobs, optimizing query performance, and working independently to resolve issues.
Experience / Qualifications
Education
Work Location
Experience / Qualifications
- 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 re-designing Databases/Data warehouse using SQL server, SSIS and any custom scripts.
- Knowledge of working in Data platforms development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS related to database.
- Knowledge of or working experience with Cognos BI environment or other business Intelligence tool set such as Power BI or tableaus preferred.
- 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.
Education
- Bachelor's degree in computer science/engineering or related fields.
Work Location
- Hybrid work at Jersey City, NJ