Senior DataStage ETL 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

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Contract DataStage ETL Developer — Informatica Expert
Contract DataStage ETL Developer — Informatica Expert

ROSS • Toronto

On-site
CAD 80,000 - 100,000
Datastage developer
Datastage developer

Tata Consultancy Services Limited • Toronto

On-site
CAD 100,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 ETL Lead: Hands-On Data Integration
DataStage ETL Lead: Hands-On Data Integration

Compunnel Inc. • Toronto

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

Cognizant Technology Solutions Corporation • Canada

On-site
CAD 90,000 - 130,000
ETL/Datastage Developer
ETL/Datastage Developer

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
Data Dev Lead
Data Dev Lead

Compunnel Inc. • Toronto

On-site
CAD 90,000 - 120,000