DataStage Developer

Cognizant Technology Solutions Corporation

Mississauga

On-site

CAD 129,000 - 142,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

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

Get past ATS filters

Benefits offered by this job

Medical/Dental/Vision/Life Insurance
401(k) plan and contributions
Long-term/Short-term Disability
Paid Parental Leave
Employee Stock Purchase Plan

Job summary

Cognizant Technology Solutions Corporation in Mississauga is seeking a Data Stage Developer with 8–11 years of ETL design and development experience. You will design, build, and optimize DataStage parallel jobs, transformer logic, and complex SQL across Oracle/DB2/SQL Server.

You will also automate scripts and support production data processing. Responsibilities include data profiling, translating mappings to scalable solutions, and collaborating with cross-functional teams to ensure robust data

Qualifications

  • 8-11 years of experience required in ETL design and development with DataStage.
  • Experience designing and modifying parallel jobs, sequences, and custom routines in IBM InfoSphere DataStage.
  • Experience implementing complex business logic using transformer stages, lookups, joins, aggregations and sorting.
  • Ability to translate business requirements and source-to-target mappings into scalable technical solutions.
  • Experience with database optimization and writing/optimizing SQL/PLSQL for Oracle, DB2 or SQL Server.

Responsibilities

  • ETL design and development.
  • Design, build and modify parallel jobs, sequence jobs and custom routines in IBM InfoSphere DataStage Designer client.
  • Implement complex business logic using transformer stages, lookups, joins, aggregations and sorting mechanisms.
  • Translate business requirements and source-to-target mapping documents into scalable technical solutions.
  • Database and SQL optimization; write, tune and optimize advanced SQL and PL/SQL for relational databases like Oracle, DB2 or SQL Server.
  • Perform data profiling and analyze source data nuances to prevent data redundancy across EDW, ODS and Data Marts.
  • Develop and maintain UNIX/Linux shell scripts to automate file handling and job triggers; schedule and monitor via DataStage Director or schedulers.
  • Provide production support for daily/weekly/monthly data processing; analyze failures and implement fixes.
  • Create and execute unit/integration/regression tests; participate in code reviews and UAT; maintain runbooks.

Skills

ETL design
IBM InfoSphere DataStage
Transformer stages
Lookups
Joins
Aggregations
Sorting
SQL
PL/SQL
Oracle
DB2
SQL Server
UNIX/Linux shell scripts
DataStage Director
Enterprise schedulers

Tools

DataStage
UNIX/Linux shell
DataStage Director
Enterprise schedulers

Job description

Job Title- Data Stage Developer

Years of experience- 8-11 years

Job Summary

ETL Design and Development

Design build and modify parallel jobs sequence jobs and custom routines in IBM InfoSphere DataStage Designer client

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 and SQL Optimization

Write tune and optimize advanced SQL and PL SQL queries for relational databases like Oracle DB2 or SQL Server

Responsibilities

ETL Design and Development

Design build and modify parallel jobs sequence jobs and custom routines in IBM InfoSphere DataStage Designer client

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 and 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 and Automation

Develop and maintain UNIX Linux shell scripts to automate file handling job triggers and operational pipelines

Schedule execute and monitor jobs using DataStage Director or enterprise schedulers

Troubleshooting and 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 and 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

Exempt Roles (up to AD Level)

Note: Compensation range should extend from the minimum to P75, consistent with the job family and level.

For all remote positions and those based in pay transparency locations, include this text in the External Description:

Salary and Other Compensation:

The annual salary for this position is between $90-99K depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits:

Medical/Dental/Vision/Life Insurance

Paid holidays plus Paid Time Off

401(k) plan and contributions

Long-term/Short-term Disability

Paid Parental Leave

Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Datastage developer
Datastage developer

Tata Consultancy Services Limited • Toronto

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

ROSS • Toronto

On-site
CAD 80,000 - 100,000
ETL Data Lead (Hybrid)
ETL Data Lead (Hybrid)

Cognizant Technology Solutions Corporation • Halifax

Hybrid
CAD 106,000 - 177,000
DataStage ETL Lead: Hands-On Data Integration
DataStage ETL Lead: Hands-On Data Integration

Compunnel Inc. • Toronto

On-site
CAD 90,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
IBM MDM Consultant
IBM MDM Consultant

Cognizant Technology Solutions Corporation • Toronto

Hybrid
CAD 81,000 - 156,000
Long-term/Short-term Disability
ETL DataStage Developer
ETL DataStage Developer

Apptoza Inc. • Toronto

On-site
CAD 80,000 - 100,000
Data Scientist (Hybrid)
Data Scientist (Hybrid)

Cognizant Technology Solutions Corporation • Toronto

Hybrid
CAD 75,000 - 115,000
Discretionary bonus
Wellbeing programs
Data Dev Lead
Data Dev Lead

Compunnel Inc. • Toronto

On-site
CAD 90,000 - 120,000
ETL Data Lead (Hybrid)
ETL Data Lead (Hybrid)

Cognizant • Halifax

Hybrid
CAD 75,000 - 140,000