Description review
SQL/SSIS and Oracle Developer
OZ · Argentina · back to the listing
HR standards
56/100
needs work
Title ↔ description
77/100
solid
Reads as
Data Engineer
99% confident
How others title the same work
Large employers
- Data Engineer, Product Analytics Meta
- Senior Staff Data Engineer Mozilla
- Staff, Analytics Engineer, GTM Data Science & Analytics Twilio
- Senior Software Engineer - Data Platform Coinbase
- Senior Security Data Engineer Doordash
Startups
- Business Intelligence Engineer GoSats
- IPinfo.io | Data Engineer | REMOTE (Anywhere) | Full-time IPinfo.io
- Senior Data Engineer Camber
- Senior Data Engineer Instrumentl
- Cardog | Toronto, Canada or REMOTE | Full-time Cardog
What the listing never says
- 29 bullet points. Long requirement lists deter qualified candidates, who read them as hard gates. Scope clarity
- No pay range published. Candidates cannot tell whether applying is worth their time. Pay transparency
- No location or timezone policy stated, so a candidate cannot tell where they may work from. Scope clarity
The listing, marked up
Nothing in the wording of this listing tripped a check. The scores above still judge how complete and coherent it is.
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
• 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
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 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.
Originally posted on Himalayas
KEY 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.
• Provide post-migration support, including issue resolution and performance monitoring.
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 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.
Originally posted on Himalayas