ETL Engineer: SSIS & Oracle-to-SQL Migrations

HR POD Careers

Lahore

À distance

PKR 1 800 000 - 3 200 000

Plein temps

14 jours+

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Résumé du poste

HR POD Careers is seeking an experienced ETL/Data Engineer in Lahore to design, develop, and maintain SSIS packages for large datasets. You will analyze Oracle schemas and migrate them to SQL Server, building complex T-SQL queries and ETL workflows.

The role requires 3+ years in SSIS, strong Oracle and SQL Server expertise, and experience with migrating legacy Java ETL applications. Collaboration with DBAs and business analysts is essential, with a focus on data quality and governance.

Qualifications

  • Bachelor's degree in CS/IT/SE or equivalent professional experience.
  • 3+ years experience building and managing SSIS packages.
  • Strong SQL Server (2016/2019/2022) + Oracle (10g-19c) expertise.
  • Experience with Oracle-to-SQL Server migrations and ETL pipelines.

Responsabilités

  • Design, develop, and maintain robust SSIS packages for ETL workflows and data loads.
  • Analyze Oracle schemas, procedures, functions, and re-engineer in T-SQL for SQL Server compatibility.
  • Develop complex T-SQL queries, stored procedures, views, triggers, and functions.
  • Analyze and re-engineer existing Java-based ETL applications to SSIS/T-SQL.
  • Convert Java ETL apps into SSIS/T-SQL equivalents and plan modernization.
  • Unit test, integrate, and tune ETL pipelines and SQL scripts.
  • Document migration strategies, data mappings, and ETL workflows.
  • Monitor and troubleshoot ETL jobs and data discrepancies across environments.
  • Optimize queries and SSIS using indexing and execution plans.
  • Ensure data governance and security during migration.
  • Collaborate with analysts, DBAs, and PMs to translate requirements.
  • Provide post-migration support and performance monitoring.

Connaissances

SSIS
SQL Server
Oracle
ETL
Java
Spring Batch
Apache Camel
SSMS/SSDT
Git/Azure DevOps
Power BI
Azure Data Factory
Data warehousing
Legacy ETL

Formation

Bachelor's degree in Computer Science / Information Technology / Software Engineering

Outils

SSMS
Visual Studio
Oracle SQL Developer
TOAD
SSMA for Oracle
SQL Server Agent
SSIS Catalog
Git
Azure DevOps
Power BI
IntelliJ / Eclipse
Maven

Description du poste

HR POD Careers is seeking an experienced ETL/Data Engineer in Lahore to design, develop, and maintain SSIS packages for large datasets. You will analyze Oracle schemas and migrate them to SQL Server, building complex T-SQL queries and ETL workflows.

The role requires 3+ years in SSIS, strong Oracle and SQL Server expertise, and experience with migrating legacy Java ETL applications. Collaboration with DBAs and business analysts is essential, with a focus on data quality and governance.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

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

HR POD - Hiring Talent Globally • Lahore

À distance
PKR 2 000 000 - 3 500 000
Oracle to SQL Migration Specialist
Oracle to SQL Migration Specialist

Kamayi • Lahore

À distance
PKR 1 800 000 - 3 200 000
Senior SSIS & SQL ETL Architect
Senior SSIS & SQL ETL Architect

HR POD Careers • Lahore

À distance
PKR 2 000 000 - 3 500 000
Remote Oracle-to-SQL Data Migration Specialist
Remote Oracle-to-SQL Data Migration Specialist

Kamayi • Lahore

À distance
PKR 1 800 000 - 3 200 000
Senior Data Engineer (AWS / PLSQL / Oracle)
Senior Data Engineer (AWS / PLSQL / Oracle)

NorthBay Solutions • Karachi Division

Hybride
PKR 1 200 000 - 1 800 000
Senior Data Engineer (AWS / PLSQL / Oracle)
Senior Data Engineer (AWS / PLSQL / Oracle)

NorthBay Solutions LLC • Islamabad

Hybride
PKR 2 500 000 - 4 500 000
Senior Data Engineer (AWS / PLSQL / Oracle)
Senior Data Engineer (AWS / PLSQL / Oracle)

NorthBay Solutions LLC • Lahore

Hybride
PKR 1 500 000 - 2 300 000
Senior Data Engineer (AWS / PLSQL / Oracle)
Senior Data Engineer (AWS / PLSQL / Oracle)

NorthBay Solutions LLC • Karachi Division

Hybride
PKR 1 200 000 - 1 800 000
Data Engineer - Islamabad
Data Engineer - Islamabad

Yeah! Global • Islamabad

Sur place
PKR 1 116 000 - 1 674 000
Senior Data Migration Engineer - LegalTech ETL Lead
Senior Data Migration Engineer - LegalTech ETL Lead

Cloudelligent • Islamabad

Sur place
PKR 1 800 000 - 3 000 000
Lieux principaux