ETL Developer DataStage, PLSQL, Shell Scripting

Not Interested
Bookmark
Report This Job

profile Job Location:

Calgary - Canada

profile Monthly Salary: Not Disclosed
profile Experience Required: 5years
Posted on: Yesterday
Vacancies: 1 Vacancy

Job Summary

Job Title: ETL Developer

Experience: 68 years
Location: Calgary (Hybrid)
Primary Skill: PL/SQL


Key Responsibilities

  • Design develop and maintain ETL processes using industry-standard ETL tools (DataStage preferred).

  • Develop and optimize PL/SQL code for data extraction transformation and loading.

  • Work extensively with MS SQL Server (preferred) or Oracle databases for data processing and validation.

  • Perform data analysis profiling and troubleshooting to ensure data accuracy and integrity.

  • Develop and maintain shell scripts to support ETL workflows and automation.

  • Use enterprise job scheduling tools such as Control-M StoneBranch or similar to manage batch processes.

  • Monitor ETL jobs perform root-cause analysis and resolve production issues.

  • Collaborate with business analysts data architects and downstream teams to understand data requirements.

  • Ensure adherence to data quality performance and security standards.

  • Participate in code reviews testing and deployment activities.


Required Skills & Qualifications

  • 68 years of experience in ETL development and data integration.

  • Strong expertise in PL/SQL.

  • Hands-on experience with DataStage (preferred) or other ETL tools.

  • Strong working knowledge of MS SQL Server (preferred) or Oracle.

  • Basic to intermediate experience in Shell scripting.

  • Experience with job scheduling tools such as Control-M or StoneBranch.

  • Strong analytical and problem-solving skills.


Nice to Have

  • Experience working in large-scale data environments.

  • Exposure to performance tuning and optimization.

  • Experience supporting production data pipelines.




Required Skills:

Experience (Years): 8-10

Job Title: ETL DeveloperExperience: 68 years Location: Calgary (Hybrid) Primary Skill: PL/SQLKey ResponsibilitiesDesign develop and maintain ETL processes using industry-standard ETL tools (DataStage preferred).Develop and optimize PL/SQL code for data extraction transformation and loading.Work exte...
View more view more

Company Industry

IT Services and IT Consulting

Key Skills

  • Children Activity
  • Client Servicing
  • FX
  • Airlines
  • Logistics & Supply Chain Management
  • Manufacturing