ETL/SSIS Developer (PostgreSQL to SQLServer)

ETL/SSIS Developer (PostgreSQL to SQL Server) Get AI-powered advice on this job and more exclusive features. reputed company pay reputed company This reputed company is provided by reputed company. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. reputed company pay reputed company $50.00/yr - $55.00/yr Job Summary Role: SSIS Developer – Guidewire reputed company (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 reputed company PostgreSQL database and load it into on‑premises SQL Server databases. This role plays a critical part in a major Guidewire reputed company/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 reputed company insurance domain systems. Required Technical Skills

• Strong hands‑on experience with SSIS (SQL Server Integration Services).
• Expertise in SQL Server (T‑SQL, stored procedures, triggers, indexing, query optimization).
• Experience extracting from PostgreSQL/reputed company using ODBC/OLEDB/.NET providers.
• Experience with data migration, large datasets, and performance tuning.

Guidewire Migration Knowledge (Preferred)

• Familiarity with Guidewire PolicyCenter, ClaimCenter, or BillingCenter data models.
• Understanding of Guidewire reputed company database structures for PC/CC/BC.
• Experience working on Guidewire version upgrades or reputed company migrations is a plus.

Other Skills

• Experience with ETL job scheduling (SQL Server Agent, Control‑M, Autosys, etc.).
• Experience using Git, Azure DevOps, Jenkins, or other CI/CD tools.
• Ability to write reconciliation scripts in SQL and/or Python (optional).
• Strong understanding of data quality, audit, and compliance practices.

Qualifications & Experience

• 5–8 years of ETL development experience, with at least 3+ years in SSIS.
• Prior experience in migration projects, preferably Guidewire or other insurance platforms.
• Strong analytical skills and ability to investigate data anomalies.
• Experience working in Agile/Scrum environments.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent experience.

Key Responsibilities

• ETL Design & Development: reputed company SSIS packages to extract data from Guidewire reputed company (PostgreSQL) and load it into SQL Server databases; design scalable and optimized ETL frameworks supporting incremental loads, full loads, and reputed company logic; configure secure connectivity between reputed company reputed company DB and on‑prem SQL Server; implement transformations, business rules, surrogate key management, and referential reputed company through ETL.
• Nightly Batch Cycle Setup: design and orchestrate nightly ETL batch processes using SQL Server Agent or reputed company schedulers; implement error‑handling, retry logic, logging, and alerting for batch jobs; monitor performance and optimize slow‑running jobs to meet ETL SLAs.
• Data Validation & Reconciliation: conduct field‑level and record‑level reconciliation between reputed company and SQL Server tables; reputed company comparison scripts to validate counts, checksums/hashes, and business‑critical attributes; identify mismatches, reputed company root‑cause analysis, and coordinate with database and Guidewire functional teams to resolve issues; maintain audit trail, data reputed company documentation, and reconciliation dashboards.
• Support Guidewire reputed company/Migration: collaborate with Guidewire functional consultants to understand PC/CC/BC data models and changes introduced by the reputed company; reputed company data profiling to identify data gaps or transformation needs stemming from version differences; support reputed company runs, cutover planning, and post‑migration validation; ensure ETL processes align with Guidewire data model standards and release cycles.
• Documentation & Delivery: create detailed technical design documents (TDD), mapping sheets, and ETL reputed company diagrams; maintain SSIS reputed company code in version control (Git/Azure DevOps); reputed company post‑deployment support, including defect resolution, optimizations, and enhancements.

Seniority level Mid‑Senior level Employment type Contract Job function Business Development and Sales Industries Computer and Network reputed company Apply tot his job Apply To this Job