SQL/SSIS, Oracle Developer

🔥 4 minutes ago

🇦🇷 Argentina – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

🖥 Software Engineer

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

OZ

WebsiteLinkedInAll Job Openings

201 - 500 employees

💼 Consulting

🏥 Healthcare

✈️ Travel

Consulting • Healthcare • Travel

OZ is a premier digital consulting firm and trusted Microsoft solutions partner located in Florida. With over 25 years of experience, OZ specializes in delivering deep technical expertise and industry knowledge through a global delivery model. The company offers a range of services, including Azure solutions, Power Platform, artificial intelligence, enterprise integration, intelligent automation, data and analytics, and app innovation. OZ serves a diverse range of industries, such as travel and hospitality, healthcare insurance, technology, public sector, and retail, and is known for its tailor-made, Microsoft-powered solutions to address unique business challenges. OZ also provides an on-demand talent studio to access certified IT professionals. It has built a reputation as a reliable partner for over 370 companies, offering services that enhance business agility and innovation.

📋 Description

• 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

🎯 Requirements

• 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 • Proficiency with SQL Server Management Studio (SSMS) and Visual Studio (SSDT) • Proficiency with Oracle SQL Developer or TOAD • 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 • Microsoft Certified: Azure Data Engineer Associate or an equivalent SQL Server certification is preferred • Experience with Azure Data Factory (ADF) or other cloud-based ETL platforms is preferred • Familiarity with data warehousing concepts, including star schema, snowflake schema, and slowly changing dimensions is preferred • Experience working with Azure cloud environments is preferred • Experience with Agile or Scrum methodologies is preferred • Experience with data lineage and metadata management tools is preferred • Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field is preferred