ITnova is looking for a Data Warehouse / ETL Developer to design, develop, and support Data Warehouse and ETL processes.
Requirements
- 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
Responsibilities
- designing, developing, and supporting Data Warehouse and ETL processes
- maintaining ETL jobs
- optimizing query performance
- working independently to resolve issues
- designing, development, testing, and support of Data Warehouse and ETL processes as needed
- writing complex T-SQL Queries, Store Procedures, Views and ETL in re-designing Databases/Data warehouse using SQL server, SSIS and any custom scripts
- maintaining and monitoring of ETL jobs by making sure that jobs are completed in timely manner
Other
- Ability to act independently to resolve issues
- excellent communication and interpersonal skills
- strong critical & analytic thinking
- Hybrid work at Jersey City, NJ
