SSIS ETL Developer Job at Forward Progress Staffing, California

WDlQdzNIajdEYzg4UUFqdGMwQ1M2bTJEK3c9PQ==
  • Forward Progress Staffing
  • California

Job Description

Senior ETL Migration Specialist - SSIS to IICS & Microsoft Fabric
Contract Remote-Flexible

We're looking for a hands-on data integration specialist to own the migration of legacy SSIS workloads into Informatica Intelligent Cloud Services (IICS) and Microsoft Fabric. You'll work independently across multiple migration tracks - from analysis and design through build, testing, and cutover - with minimal day-to-day supervision.

What you'll do

  • Review existing SSIS packages, dependencies, schedules, and SQL logic to document current-state ETL behavior and migration requirements
  • Design and build IICS CDI solutions including mappings, tasks, connections, parameters, and reusable components
  • Implement Microsoft Fabric pipelines and integrate them into the target data platform
  • Develop SQL scripts for extraction, transformation, loading, and validation
  • Tune IICS CDI jobs and SQL logic for performance, scalability, and operational efficiency
  • Create and execute test cases and data reconciliation checks; support UAT, defect resolution, and post-migration stabilization
  • Assist with cutover planning and hypercare activities
  • Produce comprehensive documentation - mapping specs, design docs, runbooks, and data lineage records
  • Provide regular status updates and participate in design reviews and working sessions
  • Support knowledge transfer to internal teams through documentation and walkthroughs

What we're looking for

  • Deep hands-on experience with SSIS - package design, dependencies, scheduling, and configuration
  • Strong IICS CDI expertise - mappings, tasks, connections, pushdown optimization, and orchestration
  • Microsoft Fabric experience including pipeline development and platform integration
  • Advanced SQL skills across extraction, transformation, loading, and performance tuning
  • Proven ability to manage complex migration workstreams independently
  • Solid understanding of ETL patterns - incremental loads, error handling, logging, and recovery
  • Strong documentation skills and clear communication with both technical and business stakeholders
  • Experience with UAT support, cutover planning, and post-migration stabilization

Job Tags

Contract work, Seasonal work, Remote work, Flexible hours

Similar Jobs

Myer Hospitality

Hotel Assistant General Manager Job at Myer Hospitality

 ...performance Lead by example to ensure exceptional guest service across all departments Supervise front desk, gift shop, housekeeping, breakfast, and maintenance operations as needed Help recruit, train, coach, and motivate team members to achieve service and performance... 

BrightStar Care Charlotte

Caregiver Job at BrightStar Care Charlotte

 ...available during the week and rotating weekends. We can share what we currently have available with our...  ...for a trustworthy, reliable Home Health Aides to provide assistance with our client's activities of daily living and personal care needs on a Part Time/Full Time schedule... 

Confidential

Primary Care Physician Job at Confidential

 ...Risk Manager / Assistant Director of Nursing (ADON) Setting: Long-Term Care Facility Job Type: Full-Time | On-Site Located in a scenic coastal community, our premier long-term care facility is dedicated to delivering high-quality, resident-centered care in... 

Tandem Intermediate LLC

Clinical Research Coordinator (Full Time) Job at Tandem Intermediate LLC

 ...specific systems ~ Ability to maintain strict confidentiality ~ Required Experience & Qualifications ~ Education: Bachelors degree in a related field ~ Experience: Minimum of two (2) years of clinical research or clinical trial management experience ~... 

Midwest Logistic Systems

Dedicated truck driver Job at Midwest Logistic Systems

 ...Have a predictable daily home time work schedule. Drive the same out-and-back dedicated route...  ...~$5,000 sign-on bonus for experienced drivers. ~ Safety and performance bonuses of up...  ...Valid Class A Commercial Drivers License (CDL). Live within 50 miles of Duncan, SC....