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

Wells Fargo

Teller Part Time El Paso Job at Wells Fargo

 ...religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other legally protected...  ...during the application or interview process, visit Disability Inclusion at Wells Fargo. Drug and Alcohol Policy Wells Fargo... 

Shaanxi Ruisi Tongsheng Translation Service Co., Ltd.

mathematics/chemistry/physics/biology teacher Job at Shaanxi Ruisi Tongsheng Translation Service Co., Ltd.

 ...High School2. Canadian citizenship (Bachelors degree in education, certificate required), teaching mathematics/chemistry/physics/biology.3. Visas: Teaching-related visas4. Gender: Not specified.5. Teaching population: middle school and high school students.6. Start... 

Sage Haus

House Manager & Family Assistant Job at Sage Haus

 ...overnight stays with the kids (given significant notice) is valued! Description We are a kind family of four including two teens (13-year-old girl and 15-year-old boy), a small dog, and two beloved guinea pigs. We are looking for a warm, detail-oriented, and proactive... 

Flowers Foods

Industrial Maintenance Technician - $30.85+/hour Job at Flowers Foods

 ...holidays, and parental leave Benefits may vary depending on your work location. Bringing Home the Dough Industrial Maintenance Technicians ensure optimal efficiency is achieved by performing scheduled and unscheduled maintenance, with safety and quality... 

Siri InfoSolutions Inc

Cloud Infrastructure Architect Job at Siri InfoSolutions Inc

 ...Functional Skills Experience as Enterprise infrastructure Architect providing solutions for Compute, Storage, Backup and Disaster Recovery, Virtualization, Networking, Identity and Access Management. Support hybrid cloud infrastructure integrating Azure with on...