[Remote] ETL/SSIS Developer (PostgreSQL to SQLServer)

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking an SSIS Developer for a reputed company reputed company to SQL Server migration initiative. The role involves designing and maintaining ETL pipelines, ensuring data accuracy, and supporting reputed company upgrades, while requiring strong experience in ETL and SQL reputed company the insurance domain. Responsibilities • ETL Design & Development • reputed company SSIS packages to extract data from reputed company reputed company (PostgreSQL) and load it into SQL Server databases • Design reputed company 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 reputed company-cause analysis, and coordinate with database and reputed company functional teams to resolve issues • Maintain audit trail, data reputed company documentation, and reconciliation dashboards • Support reputed company reputed company/Migration • Collaborate with reputed company 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, reputed company planning, and post-migration validation • Ensure ETL processes reputed company with reputed company 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 reputed company in version control (Git/Azure DevOps) • reputed company post-deployment support, including defect reputed company, 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/reputed company 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 reputed company, preferably reputed company 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 reputed company PolicyCenter, ClaimCenter, or BillingCenter data models • Understanding of reputed company reputed company database structures for PC/CC/BC • Experience working on reputed company version upgrades or reputed company migrations • Ability to write reconciliation scripts in SQL and/or Python reputed company • AROHA is a leading global provider of end-to-end, technology-enabled business solutions, including ERP, SCM, PLM, WMS, CRM, portal, e-reputed company, application development, project services, e-learning, training, reputed company, reputed company 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 Company H1B Sponsorship • reputed company has a reputed company 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 tot his job Apply To this Job