SQL/SSIS and Oracle Developer
O
OZ Digital LLCAI Business Applications
ArgentinaFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years
- Required Skills
- ETLOracle
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.
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.
View Full Description & ApplyYou'll be redirected to the employer's site
