SQL/SSIS and Oracle Developer
Guarda esta oferta y sigue tu búsqueda
Crea una cuenta gratis para guardar empleos, crear alertas y volver a esta oferta desde tu panel.
Al continuar, aceptas nuestros Términos & Política de Privacidad.
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
Requirements
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.