ETL/SSIS Developer (PostgreSQL to SQLServer)

ETL/SSIS Developer (PostgreSQL to SQL Server) Get AI-powered advice on this job and more exclusive features.

Aroha Technologies, Inc pay range This range is provided by Aroha Technologies, Inc.

Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range $50.00/yr - $55.00/yr Job Summary Role: SSIS Developer – Guidewire Aurora (PostgreSQL) to SQL Server Migration Location: Canada/USA - Remote Tentative Start Date: 3rd Week Dec No of position: 1 Domain/Industry: Insurance Year of Experience: 5-8 Years Type: Contract/FTE Role Overview The SSIS Developer will be responsible for designing, developing, and maintaining ETL pipelines to extract data from the Guidewire Aurora PostgreSQL database and load it into on‑premises SQL Server databases.

This role plays a critical part in a major Guidewire upgrade/migration initiative and involves building a nightly batch cycle, ensuring data accuracy through reconciliation processes, and validating end‑to‑end data movement.

The ideal candidate has strong ETL, SQL, and data migration experience within insurance domain systems.

Required Technical Skills • Strong hands‑on experience with SSIS (SQL Server Integration Services).

NET providers. • Experience with data migration, large datasets, and performance tuning.

Guidewire Migration Knowledge (Preferred) • Familiarity with Guidewire PolicyCenter, ClaimCenter, or BillingCenter data models.

Other Skills • Experience with ETL job scheduling (SQL Server Agent, Control‑M, Autosys, etc.).

Qualifications & Experience • 5–8 years of ETL development experience, with at least 3+ years in SSIS.

Key Responsibilities • ETL Design & Development: develop SSIS packages to extract data from Guidewire Aurora (PostgreSQL) and load it into SQL Server databases; design scalable and optimized ETL frameworks supporting incremental loads, full loads, and delta logic; configure secure connectivity between cloud Aurora DB and on‑prem SQL Server; implement transformations, business rules, surrogate key management, and referential integrity through ETL.

Seniority level Mid‑Senior level Employment type Contract Job function Business Development and Sales Industries Computer and Network Security