SSIS ETL Developer Job at Forward Progress Staffing, California

WjhXVDBnajFGR1c5aEVwZDhOM0xaRVdlQkE9PQ==
  • 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

The Oak Room

Open Call Bartenders Job at The Oak Room

 ...*** Open Interviews*** Wednesday 08/26/26 2pm-4pm Please bring an updated resume, dress professional and be prepared to interview! Desert 5 Spot: 400 Morse St, NE, Washington, DC 20002 Ten Five Hospitality is excited to announce the launch of it's new restaurant... 

Confidential

Junior-Level Business Analyst Job at Confidential

Junior-Level Business Analyst Position Description Do you have a proven interest in information technology and business and a passion for learning? Are you a go to problem solver that is motivated to make an impact by crafting customized business efficiencies for... 

Twist Bioscience

Sr Bioinformatics Scientist Job at Twist Bioscience

 ...Senior Bioinformatics Scientist Position Overview Twist Bioscience is seeking a Senior Bioinformatics Scientist to join our Scientific Computing team supporting R&D across DNA Synthesis and Protein Solutions. You will develop computational methods and predictive... 

Marriott

Event Manager Job at Marriott

 ...JOB SUMMARY Responsible for preparing all event documentation and coordinates with Sales, property departments and customer...  ...diploma or GED; experienced (1 2 years of experience) in the event management or related professional area. OR 2-year degree from an... 

Confidential

Senior Healthcare Data Analyst, Claims Analytics Job at Confidential

 ...is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Senior Healthcare Data Analyst, Claims Analytics based in the United States. This is a fully remote opportunity for an experienced data analyst to turn...