Title: Senior ETL SSIS Engineer with ADF
Duration: 12 Months (Contract)
Location: Davenport Iowa (Hybrid)
Note: Local Iowa candidates Preferred.
Responsibilities:
- Design develop and deploy ETL processes using SSIS/Azure Data Factory.
- 8 years of experience in ETL development using SSIS or 4 years of experience in Azure data factory
- Monitor and troubleshoot ETL jobs and data flows.
- Implement data quality checks and ensure data integrity.
- Maintain documentation of ETL processes and data flow diagrams
- Design develop and maintain interactive Power BI reports and dashboards to visualize key performance indicators (KPIs) and business metrics.
- Translate complex business requirements into technical specifications for data extraction transformation and reporting.
- Collaborate with cross-functional teams to understand their data and reporting needs.
- Write complex SQL queries for data extraction manipulation and analysis from various relational databases.
- Resource needs to have good insurance domain knowledge
ETL,SQL Server Integration Services (SSIS),azure data factory,Power BI,ADF