SSIS / SQL Developer – Data Migration (Remote, Anywhere From Pakistan, USD Salary)

HR POD - Hiring Talent Globally; Lahore; Remote; PKR 2,000,000 - 3,500,000; Full time

Job summary

HR POD - Hiring Talent Globally in Lahore, Pakistan, seeks an experienced ETL/BI engineer to design, develop, and maintain SSIS packages for large data loads and migrations from Oracle to SQL Server.

You will optimize T-SQL queries, build scalable ETL pipelines, and collaborate with Java developers to modernize legacy ETL processes into SSIS/T-SQL solutions. Knowledge of SSRS/Power BI and cloud ETL tools is a plus.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field.
• Equivalent professional experience and certifications will be considered in lieu of a formal degree.
• 3+ 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 with Oracle (10g/11g/12c/19c), including PL/SQL, Oracle data types, sequences, and schema management.
• Proven experience with Oracle-to-SQL Server migrations, including schema conversion, data mapping, validation, data profiling, cleansing, and reconciliation.
• Expertise in building scalable ETL pipelines for large datasets, with strong data quality and transformation logic.
• Working knowledge of Java, including Core Java, JDBC, JDK 8+, Maven, and Java IDEs such as IntelliJ IDEA or Eclipse, with the ability to read, debug, and migrate legacy Java-based ETL and data-integration applications to SSIS/T-SQL.
• Familiarity with Java frameworks such as Spring Batch or Apache Camel.
• Proficiency in SQL Server Management Studio (SSMS), Visual Studio (SSDT), Oracle SQL Developer or TOAD, and Microsoft SQL Server Migration Assistant (SSMA) for Oracle.
• Experience with the SSIS Catalog and SQL Server Agent for ETL 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.
• Strong analytical and problem-solving skills, with excellent attention to detail.
• Excellent written and verbal communication skills for technical documentation and cross-functional collaboration.
• Ability to manage multiple tasks and priorities in a fast-paced project environment.
• Self-motivated, with the ability to work independently and as part of a team.
• 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.
• Familiarity with data warehousing concepts, including star schema, snowflake schema, and slowly changing dimensions.
• Exposure to Azure cloud environments and experience with Agile/Scrum methodologies.
• Knowledge of data lineage and metadata management tools.

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.
• Analyze and re-engineer existing Java-based ETL applications, including JDBC-based data access, batch jobs, and stored-procedure calls, into SSIS/T-SQL equivalents while recommending modernization approaches where appropriate.
• 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 across production and staging environments.
• Optimize SQL queries and SSIS packages using indexing strategies, query plans, and execution profiling.
• Ensure compliance with data governance, security policies, and regulatory requirements throughout the migration process.
• Collaborate with business analysts, DBAs, and project managers to gather requirements and translate them into technical solutions.
• Provide post-migration support, including issue resolution and performance monitoring.

Skills

SSIS

SQL Server

Oracle

Oracle to SQL Server migrations

ETL pipelines

Java

Spring Batch

Apache Camel

SSMS

SSDT / Visual Studio

SSMA for Oracle

Git / Azure DevOps

SSRS / Power BI

Azure Data Factory

Data warehousing concepts

Azure Cloud

Agile / Scrum

Data governance

Education

Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field

Tools

Oracle SQL Developer

TOAD

Job description

Requirements:

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field.
• Equivalent professional experience and certifications will be considered in lieu of a formal degree.
• 3+ 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 with Oracle (10g/11g/12c/19c), including PL/SQL, Oracle data types, sequences, and schema management.
• Proven experience with Oracle-to-SQL Server migrations, including schema conversion, data mapping, validation, data profiling, cleansing, and reconciliation.
• Expertise in building scalable ETL pipelines for large datasets, with strong data quality and transformation logic.
• Working knowledge of Java, including Core Java, JDBC, JDK 8+, Maven, and Java IDEs such as IntelliJ IDEA or Eclipse, with the ability to read, debug, and migrate legacy Java-based ETL and data-integration applications to SSIS/T-SQL.
• Familiarity with Java frameworks such as Spring Batch or Apache Camel.
• Proficiency in SQL Server Management Studio (SSMS), Visual Studio (SSDT), Oracle SQL Developer or TOAD, and Microsoft SQL Server Migration Assistant (SSMA) for Oracle.
• Experience with the SSIS Catalog and SQL Server Agent for ETL 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.
• Strong analytical and problem-solving skills, with excellent attention to detail.
• Excellent written and verbal communication skills for technical documentation and cross-functional collaboration.
• Ability to manage multiple tasks and priorities in a fast-paced project environment.
• Self-motivated, with the ability to work independently and as part of a team.
• 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.
• Familiarity with data warehousing concepts, including star schema, snowflake schema, and slowly changing dimensions.
• Exposure to Azure cloud environments and experience with Agile/Scrum methodologies.
• Knowledge of data lineage and metadata management tools.

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.
• Analyze and re-engineer existing Java-based ETL applications, including JDBC-based data access, batch jobs, and stored-procedure calls, into SSIS/T-SQL equivalents while recommending modernization approaches where appropriate.
• 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 across production and staging environments.
• Optimize SQL queries and SSIS packages using indexing strategies, query plans, and execution profiling.
• Ensure compliance with data governance, security policies, and regulatory requirements throughout the migration process.
• Collaborate with business analysts, DBAs, and project managers to gather requirements and translate them into technical solutions.
• Provide post-migration support, including issue resolution and performance monitoring.