ETL Developer - DataStage, PL / SQL, Shell Scripting

Job Description

Job Title : ETL Developer

Experience : 6–8 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

6–8 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.

Requirements

Experience (Years) : 8-10