Apply now

Posted 7 days ago

DataStage Developer

@ Cognizant

Canada

Full-time
Apply now
SIGNALS

Overview

Cognizant is hiring a full-time DataStage Developer to design, build and support ETL pipelines in IBM InfoSphere DataStage. The role covers parallel and sequence jobs, SQL and PL/SQL tuning across relational databases, UNIX/Linux scripting, production support and testing.

Responsibilities:

  • Design and build DataStage parallel and sequence jobs
  • Write and tune SQL and PL/SQL queries
  • Automate data pipelines with UNIX/Linux scripts
  • Monitor jobs and fix failed or slow loads
  • Test, document and support user acceptance testing

Requirements summary:

  • Hands-on experience with IBM InfoSphere DataStage
  • Advanced SQL and PL/SQL on Oracle, DB2 or SQL Server
  • UNIX/Linux shell scripting experience
  • Data warehouse and ETL design knowledge
  • Experience with SDLC and collaboration across teams

Tools & skills

Source and dates

Source type not verified · apify-linkedin

Employer posting date
2026-11-03
First seen by our source
2026-11-10
Source record updated
2026-11-10

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

DepartmentData & analytics
Hours per week40 (estimated)
Travelair: none · ground: none
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high

Summary and details written by AI from the posting; the employer’s posting is the authority.

Cognizant

FieldValue
Open jobs on Jobsy1
Job description

Job title- Datastage Developer

Description

  • ETL Design & Development
  • Design, build, and modify parallel jobs, sequence jobs, and custom routines in IBM InfoSphere DataStage (Designer client). -- Must have
  • Implement complex business logic using transformer stages, lookups, joins, aggregations, and sorting mechanisms.
  • Translate business requirements and source-to-target mapping documents (STDs) into scalable technical solutions.
  • Database & SQL Optimization
  • Write, tune, and optimize advanced SQL and PL/SQL queries for relational databases like Oracle, DB2, or SQL Server.
  • Perform data profiling, analyze source data nuances, and prevent data redundancy across data warehouses (EDW, ODS, and Data Marts).
  • Scripting & Automation
  • Develop and maintain UNIX/Linux shell scripts to automate file handling, job triggers, and operational pipelines.
  • Schedule, execute, and monitor jobs using DataStageDirector or enterprise schedulers.
  • Troubleshooting & Production Support
  • Provide ongoing support for daily, weekly, and monthly data processing cycles.
  • Monitor job execution logs, perform root-cause analysis on failed loads, and implement preventive performance fixes.
  • Debug and tune slow-running jobs using partitioning strategies, stage optimizations, and performance monitors.
  • Testing & Documentation
  • Create and execute comprehensive unit, integration, and regression test plans.
  • Participate in code reviews and support User Acceptance Testing (UAT).
  • Maintain technical documentation, data lineage, and operational runbooks.
  • Collaboration & Upgrades

Work closely with data architects, business analysts, QA teams, and infrastructure engineers across the Software Development Life Cycle (SDLC).

Similar jobs

  • Datastage Developer

    Toronto, ON
    On-siteFull Time

    system canada technologies

    8+ YOECandidates need at least 8 years of IBM InfoSphere DataStage design and development experience, preferably version 8.1 or later. They also need strong SQL on any RDBMS (DB2 preferred), Unix shell scripting with cron jobs, and strong analytical and communication skills.

    IBM InfoSphere DataStage, SQL, DB2, Unix shell, cron

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.