| Sr. Data Warehouse Developer SSIS ETL at Remote, Remote, USA |
| Email: [email protected] |
| From: Ashok, Bean Infosystems LLC [email protected] Reply to: [email protected] Sr. SSIS ETL / Data Warehouse Developer- Location: Remote This role will focus on addressing our complex ETL (Extract, Transform, Load) needs, ensuring seamless data integration across our systems. We are looking for a highly skilled individual with deep expertise in SQL who can manage large-scale data processes, optimize performance, and support the overall data architecture. This senior-level position requires a strategic thinker with a proven ETL development and database management track record. Essential Responsibilities: Must have solid knowledge of the ETL process, Change Data Capture (CDC), and data warehouse concepts. Expertise in creating and deploying Microsoft SQL Server Integration Services (SSIS) packages and Microsoft Azure Data Factory (ADF) pipelines to load data into a data warehouse and data mart tables. Create and maintain ETL technical specifications, ETL process, and ETL testing documents. Strong in writing complex SQL queries, stored procedures, triggers, and functions to automate ETL load. Working experience with Slowly Changing Dimensions (SCD) type-2 tables and developing ETL packages to load and maintain consistent historical data from heterogeneous source systems. Strong experience with various data quality transformations to enrich data and load data warehouse and data mart tables. Create and maintain ETL technical specifications, ETL process, and ETL testing documents. Working experience in ETL testing for dimensional and fact tables. Working experience in scheduling, monitoring, troubleshooting, and resolving ETL jobs in non-prod and prod environments. Have excellent working experience with Microsoft SQL Server, SSIS tool, SQL Server Management Studio (SSMS), Azure SQL Database, and Azure Data Factory. Collaborate with business analysts, database administrators, architects, and Canopy Health stakeholders to gather requirements and design solutions. Work with the BI team to support business intelligence and reporting through the data warehouse Follow industry regulations and organizational policies for data governance, including compliance with HIPAA. Preference for experience with healthcare clinical and health plan data. Requirements: Expert-level working knowledge with the following tools: Microsoft SQL Server SSIS (SQL Server Integration Services) SSMS (SQL Server Management Studio) Visual Studio (need version) Azure SQL Database Azure ADF (Azure Data Factory) Microsoft Office (add version) Version Control Systems: GIT, Azure DevOps, CI/CD Pipelines Keywords: continuous integration continuous deployment business intelligence Sr. Data Warehouse Developer SSIS ETL [email protected] |
| [email protected] View all |
| Wed Nov 13 23:24:00 UTC 2024 |