DataStage Developer (Mississauga)

DataStage Developer (Mississauga)

19 Nov
|
Cognizant Technology Solutions
|
Mississauga

19 Nov

Cognizant Technology Solutions

Mississauga

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

#J-18808-Ljbffr

📌 DataStage Developer (Mississauga)
🏢 Cognizant Technology Solutions
📍 Mississauga

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: datastage developer (mississauga) / mississauga

Subscribe to this job alert:

Get the latest job offers by email for: datastage developer (mississauga) / mississauga