Senior SSIS & Oracle-to-SQL ETL Developer

OZ Digital LLC; United States; A distancia; USD 110.000 - 140.000; Jornada completa

Descripción de la vacante

OZ Digital LLC in the United States seeks a skilled SSIS/SQL Developer to lead data migrations from Oracle to Microsoft SQL Server. You will design, develop, and optimize ETL pipelines, and write complex T-SQL to support migration and reporting.

You will collaborate with DBAs and analysts, perform profiling and validation, tune performance, and document runbooks. A strong background in data governance and security policies during migration is essential.

Formación

• 5+ years of hands-on experience building and managing SSIS packages with control/data flow, error handling, and logging.
• Strong proficiency in Microsoft SQL Server (2016/2019/2022), including T-SQL, indexing, and database design.
• Solid experience working with Oracle (10g/11g/12c/19c), including PL/SQL, 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 data quality and transformation logic.

Responsabilidades

• Design, develop, and maintain robust SSIS packages for ETL workflows and automated data loads.
• Analyze Oracle schemas, procedures, and packages and re-engineer them in T-SQL for SQL Server compatibility.
• Develop complex T-SQL queries, procedures, views, triggers, and functions to support business logic and reporting.
• Perform data profiling, cleansing, validation, and reconciliation during migration.
• Collaborate with analysts, DBAs, and PMs to gather requirements and translate them into technical solutions.
• Conduct unit/integration testing and performance tuning of ETL pipelines and SQL scripts.
• Document migration strategies, data mapping specifications, and runbooks.

Conocimientos

SSIS

T-SQL

Data migration

SQL performance tuning

Educación

Bachelor's degree in CS/IT/SE

Herramientas

SSMS/SSDT

Oracle

Oracle PL/SQL

SSMA for Oracle

Azure DevOps

Descripción del empleo

OZ Digital LLC in the United States seeks a skilled SSIS/SQL Developer to lead data migrations from Oracle to Microsoft SQL Server. You will design, develop, and optimize ETL pipelines, and write complex T-SQL to support migration and reporting.

You will collaborate with DBAs and analysts, perform profiling and validation, tune performance, and document runbooks. A strong background in data governance and security policies during migration is essential.