SSIS & SQL Migration Specialist (Oracle to SQL Server)

OZ; Argentina; Presencial; ARS 1.000.000 - 1.800.000; Jornada completa

Descripción de la vacante

OZ in Argentina is seeking a highly skilled SSIS / SQL Developer to lead large-scale data migrations from Oracle to Microsoft SQL Server. You will design, develop, and optimize ETL pipelines, write complex T-SQL, and ensure data integrity throughout the migration lifecycle.

Responsibilities include building robust SSIS packages, analyzing Oracle schemas, and collaborating with DBAs and analysts to translate requirements into technical solutions while following data governance and security

Formación

• 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

Responsabilidades

• 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

Herramientas

SSMS

Visual Studio

Oracle SQL Developer

TOAD

ODI

SSMA for Oracle

SSIS Catalog

SQL Server Agent

Git

Azure DevOps

TFS

SSRS

Power BI

Descripción del empleo

OZ in Argentina is seeking a highly skilled SSIS / SQL Developer to lead large-scale data migrations from Oracle to Microsoft SQL Server. You will design, develop, and optimize ETL pipelines, write complex T-SQL, and ensure data integrity throughout the migration lifecycle.

Responsibilities include building robust SSIS packages, analyzing Oracle schemas, and collaborating with DBAs and analysts to translate requirements into technical solutions while following data governance and security