SQL/SSIS and Oracle Developer

OZ Digital LLC

Redmond, Austin (WA, TX)

On-site

USD 110,000 - 150,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

OZ Digital LLC in Redmond, WA seeks an experienced SSIS/SQL Developer to design, build, and optimize ETL pipelines for large-scale data migrations from Oracle to SQL Server.

You will implement complex T-SQL, ensure data integrity, tune performance, and collaborate with analysts and DBAs throughout the migration lifecycle, with a focus on governance and post-migration support.

Qualifications

  • 5+ years in SSIS/ETL development and data migration.
  • Strong T-SQL skills and SQL Server experience.
  • Experience migrating from Oracle to SQL Server.
  • Ability to optimize ETL workflows and perform data profiling.
  • Collaborative with analysts, DBAs, and business analysts.

Responsibilities

  • Design, develop, and maintain SSIS packages for ETL workflows and automated data loads.
  • Analyze Oracle schemas, procedures, and packages; re-engineer in T-SQL for SQL Server compatibility.
  • Develop complex T-SQL queries, stored procedures, views, triggers, and functions.
  • Perform data profiling, cleansing, validation, and reconciliation during migration.
  • Collaborate with business analysts, DBAs, and project managers to gather requirements.
  • Conduct unit and integration testing; tune ETL pipelines and SQL scripts for performance.
  • Document migration strategies, data mappings, ETL workflows, and runbooks.
  • Monitor and troubleshoot ETL job failures, discrepancies, and performance bottlenecks.
  • Optimize queries and SSIS packages using indexing and execution plans.
  • Ensure data governance, security policies, and regulatory compliance during migration.
  • Provide post-migration support and issue resolution.

Skills

SSIS
SQL Server
ETL
T-SQL
Oracle
Data Migration
Performance Tuning
Data Governance
Documentation

Education

Bachelor's degree in CS/IT/SE

Tools

SSMS
Visual Studio/SSDT
Git/Azure DevOps
SSMA for Oracle
SSIS Catalog / SQL Server Agent
Power BI/SSRS

Job description

We are seeking a highly skilled SSIS / SQL Developer with proven expertise in data migration, particularly in migrating large-scale enterprise data from Oracle to Microsoft SQL Server. The ideal candidate will be responsible for designing, developing, and optimizing ETL pipelines using SQL Server Integration Services (SSIS), writing complex T-SQL queries, and ensuring data integrity throughout the migration lifecycle.

KEY RESPONSIBILITIES

  • Design, develop, and maintain robust SSIS packages for ETL workflows, data transformation, and automated data loads.
  • Analyze Oracle database schemas, stored procedures, functions, and packages and re-engineer them in T‑SQL for SQL Server compatibility.
  • Develop complex T‑SQL queries, stored procedures, views, triggers, and functions to support business logic and reporting requirements.
  • Perform data profiling, cleansing, validation, and reconciliation to ensure accuracy and completeness during migration.
  • Collaborate with business analysts, DBAs, and project managers to gather requirements and translate them into technical solutions.
  • Conduct unit testing, integration testing, and performance tuning of ETL pipelines and SQL scripts.
  • Document migration strategies, data mapping specifications, ETL workflows, and technical runbooks.
  • Monitor and troubleshoot ETL job failures, data discrepancies, and performance bottlenecks in production and staging environments.
  • Optimize SQL queries and SSIS packages for performance using indexing strategies, query plans, and execution profiling.
  • Ensure compliance with data governance, security policies, and regulatory requirements throughout the migration process.
  • Provide post‑migration support, including issue resolution and performance monitoring.

Core Technical Skills

  • 5+ years of hands‑on experience building and managing SSIS packages, including control flow, data flow, event handlers, and error handling.
  • Strong proficiency in Microsoft SQL Server (2016/2019/2022), including T‑SQL, query optimization, indexing, and database design.
  • Solid experience working with Oracle (10g/11g/12c/19c), including PL/SQL, Oracle data types, sequences, and schema management.
  • Proven experience executing Oracle‑to‑SQL Server migrations, including schema conversion, data mapping, and validation.
  • Expertise in building scalable ETL pipelines for large datasets with strong data quality and transformation logic.

Tools & Technologies

  • Proficiency with SQL Server Management Studio (SSMS) and Visual Studio (SSDT).
  • Proficiency with Oracle SQL Developer or TOAD.
  • Experience with ODI (Oracle Data Integrator).
  • Experience with Microsoft SQL Server Migration Assistant (SSMA) for Oracle.
  • Experience with SSIS Catalog and SQL Server Agent for job scheduling.
  • Experience with Git, Azure DevOps, or TFS for version control is preferred.
  • Experience with SSRS or Power BI for reporting integration is advantageous.
PREFERRED / NICE-TO-HAVE QUALIFICATIONS
  • Microsoft Certified: Azure Data Engineer Associate or an equivalent SQL Server certification.
  • Experience with Azure Data Factory (ADF) or other cloud‑based ETL platforms.
  • Familiarity with data warehousing concepts, including star schema, snowflake schema, and slowly changing dimensions.
  • Experience working with Azure cloud environments.
  • Experience with Agile or Scrum methodologies.
  • Experience with data lineage and metadata management tools.

EDUCATIONAL REQUIREMENTS

  • Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field is preferred.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior SQL SSIS & Data Warehouse Developer
Senior SQL SSIS & Data Warehouse Developer

Compunnel Inc. • Pittsburgh

On-site
USD 90,000 - 120,000
SSIS/SQL Server Developer/Solutions Architect
SSIS/SQL Server Developer/Solutions Architect

TecTammina • Livingston (NJ)

On-site
USD 95,000 - 120,000
SQL SSIS Developer
SQL SSIS Developer

Compunnel Inc. • Pittsburgh

On-site
USD 90,000 - 120,000
SQL Developer (T-SQL / SSIS / ETL)
SQL Developer (T-SQL / SSIS / ETL)

Two95 International Inc. • New Jersey

Hybrid
USD 100,000 - 140,000
Senior Database Developer / Engineer (SQL Server to Oracle Migration) – Pittsburgh, PA
Senior Database Developer / Engineer (SQL Server to Oracle Migration) – Pittsburgh, PA

Tech Mirrors • Pittsburgh

On-site
USD 120,000 - 160,000
Relocation assistance
SQL Developer
SQL Developer

E-Solutions • United States

On-site
USD 90,000 - 130,000
SSIS/SQL Developer
SSIS/SQL Developer

Altair Data Resources, Inc. • Nashville (TN)

On-site
USD 80,000 - 100,000
SQL/SSIS Developer
SQL/SSIS Developer

Intone • New York (NY)

On-site
USD 85,000 - 120,000
SSIS Developer ETL Specialist
SSIS Developer ETL Specialist

ClinDCast LLC • Chicago (IL)

On-site
USD 80,000 - 100,000
SQL Server Developer
SQL Server Developer

Valiant Technologies LLC • Minnesota

Hybrid
USD 120,000 - 160,000