DataStage Developer

Cognizant Technology Solutions Corporation

Canada

On-site

CAD 90,000 - 130,000

Full time

12 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Cognizant Canada is seeking an experienced ETL Engineer to design, build, and modify IBM InfoSphere DataStage jobs and related batch processes. You will implement complex business logic, perform data profiling, and optimize SQL across Oracle, DB2, and SQL Server environments.

You will automate data handling with UNIX/Linux scripts, monitor production jobs, and contribute to data warehousing initiatives across EDW, ODS, and Data Marts. Collaboration with architects and QA teams is essential.

Qualifications

  • Experience with IBM InfoSphere DataStage Designer client and building/ modifying parallel jobs, sequences, and custom routines.
  • Ability to implement complex business logic using transformer stages, lookups, joins, aggregations, and sorting mechanisms.
  • Translate business requirements and STDs into scalable ETL solutions for data warehouses.
  • Write and optimize advanced SQL/PL-SQL for Oracle/DB2/SQL Server.

Responsibilities

  • Design, build, and modify parallel jobs, sequence jobs, and custom routines in IBM InfoSphere DataStage.
  • Implement complex business logic and data transformations.
  • Profile and optimize data, tune slow-running jobs using partitioning and performance monitors.
  • Develop UNIX/Linux shell scripts to automate data handling and job triggers.
  • Schedule, execute, and monitor DataStage jobs and batch processes.
  • Provide production support: investigate failures, root-cause analysis, and preventive fixes.

Skills

IBM InfoSphere DataStage
SQL optimization
UNIX/Linux scripting
Data profiling
ETL design & development
Data warehousing
Production support
Testing & documentation

Tools

Oracle
DB2
SQL Server
PL/SQL

Job description

  • 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.

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

DataStage ETL Lead: Hands-On Data Integration
DataStage ETL Lead: Hands-On Data Integration

Compunnel Inc. • Toronto

On-site
CAD 90,000 - 120,000
Data Dev Lead
Data Dev Lead

Compunnel Inc. • Toronto

On-site
CAD 90,000 - 120,000
ETL DataStage Developer
ETL DataStage Developer

Apptoza Inc. • Toronto

On-site
CAD 80,000 - 100,000
DataStage Developer - Contract Opportunity
DataStage Developer - Contract Opportunity

ROSS • Toronto

On-site
CAD 80,000 - 100,000
DataStage Developer
DataStage Developer

Cognizant Technology Solutions Corporation • Mississauga

On-site
CAD 129,000 - 142,000
Medical/Dental/Vision/Life Insurance
401(k) plan and contributions
Long-term/Short-term Disability
+2
Senior ETL Datastage Developer
Senior ETL Datastage Developer

Lorven Technologies, Inc. • Vancouver

On-site
CAD 90,000 - 130,000
Datastage developer
Datastage developer

Tata Consultancy Services Limited • Toronto

On-site
CAD 100,000 - 120,000
Senior DataStage ETL Developer
Senior DataStage ETL Developer

Cognizant Technology Solutions Corporation • Mississauga

On-site
CAD 129,000 - 142,000
Medical/Dental/Vision/Life Insurance
401(k) plan and contributions
Long-term/Short-term Disability
+2
ETL/Datastage Developer
ETL/Datastage Developer

ROSS • Toronto

On-site
CAD 80,000 - 100,000
Contract DataStage ETL Developer — Informatica Expert
Contract DataStage ETL Developer — Informatica Expert

ROSS • Toronto

On-site
CAD 80,000 - 100,000