[Remote] ETL/SSIS Developer (PostgreSQL to SQLServer)
Note: The job is a remote job and is open to candidates in USA. Aroha Technologies, Inc is seeking an SSIS Developer for a Guidewire Aurora to SQL Server migration initiative. The role involves designing and maintaining ETL pipelines, ensuring data accuracy, and supporting Guidewire upgrades, while requiring strong experience in ETL and SQL within the insurance domain.
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
- Nightly Batch Cycle Setup
- Design and orchestrate nightly ETL batch processes using SQL Server Agent or enterprise 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 Aurora and SQL Server tables
- Develop comparison scripts to validate counts, checksums/hashes, and business-critical attributes
- Identify mismatches, perform root-cause analysis, and coordinate with database and Guidewire functional teams to resolve issues
- Maintain audit trail, data lineage documentation, and reconciliation dashboards
- Support Guidewire Upgrade/Migration
- Collaborate with Guidewire functional consultants to understand PC/CC/BC data models and changes introduced by the upgrade
- Perform data profiling to identify data gaps or transformation needs stemming from version differences
- Support parallel 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 flow diagrams
- Maintain SSIS source code in version control (Git/Azure DevOps)
- Provide post-deployment support, including defect resolution, optimizations, and enhancements
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/Aurora using ODBC/OLEDB/.NET providers
- Experience with data migration, large datasets, and performance tuning
- 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
- Familiarity with Guidewire PolicyCenter, ClaimCenter, or BillingCenter data models
- Understanding of Guidewire Aurora database structures for PC/CC/BC
- Experience working on Guidewire version upgrades or cloud migrations
- Ability to write reconciliation scripts in SQL and/or Python
Company Overview
- AROHA is a leading global provider of end-to-end, technology-enabled business solutions, including ERP, SCM, PLM, WMS, CRM, portal, e-commerce, application development, project services, e-learning, training, staffing, call center, and global sourcing solutions. It was founded in 2008, and is headquartered in Pleasanton, California, USA, with a workforce of 51-200 employees. Its website is http://www.arohatechnologies.com.
Company H1B Sponsorship
- Aroha Technologies, Inc has a track record of offering H1B sponsorships, with 12 in 2025, 22 in 2024, 25 in 2023, 18 in 2022, 28 in 2021, 43 in 2020. Please note that this does not guarantee sponsorship for this specific role.
Apply tot his job Apply To this Job