Description

Design and implement SSIS packages to extract data from Duck Creek aligned sources and load into target schemas, including staging and reconciliation layers.

This role is on-site.

Responsibilities

• Develop source-to-target mapping and transformation logic, including cleansing, derived fields, and reference data alignment.
• Build repeatable migration runs for dry runs, dress rehearsals, and final cutover execution with operational readiness.
• Implement data quality validation automation using SQL-based reconciliation checks for counts, totals, and referential integrity.
• Provide robust error handling, audit logging, and exception quarantine to support triage and reruns.
• Contribute to automated testing at database and functional validation levels.

Required Skills

• 5+ years of relevant ETL/data engineering experience delivering production migrations.
• Hands-on experience with SSIS and SQL Server T-SQL.
• Strong SSIS package design expertise across Data Flow, Control Flow, error handling, and deployment execution patterns.
• Experience handling large data volumes with partitioning, parallelism, and performance tuning (buffers, lookups, network I/O).
• SQL performance skills including query optimization, indexing basics, and bulk load patterns.
• Knowledge of SSIS anti-patterns (e.g., excessive sorts, row-by-row commands).
• Experience with MSBI and SQL.

Preferred Skills

• Experience with Duck Creek Insights Clarity or XML-to-relational conversion approaches.
• Azure stack familiarity including Azure Data Factory and Azure SQL Data Lake.
• CI/CD experience for SSIS deployments and release management.

Key Skills

Education

Any Graduate