Cognizant

DataStage Developer

Cognizant
Apply
2 days ago
Mississauga, CanadaSenior / Staff+

Base Salary

$90k - $99k/yr

Responsibilities

  • Design, build, and modify parallel jobs, sequence jobs, and custom routines using IBM InfoSphere DataStage Designer.
  • Implement business logic with transformer stages, lookups, joins, aggregations, and sorting mechanisms.
  • Translate business requirements and source-to-target mapping documents into scalable technical solutions.
  • Write, tune, and optimize advanced SQL and PL/SQL queries for Oracle, DB2, and SQL Server databases.
  • Perform data profiling, analyze source data, and prevent redundancy across EDW, ODS, and data marts.
  • Develop and maintain UNIX/Linux shell scripts for file handling, job triggers, and operational pipelines.
  • Schedule, execute, and monitor jobs using DataStage Director or enterprise schedulers.
  • Support recurring daily, weekly, and monthly data processing cycles.
  • Monitor execution logs, investigate failed loads, perform root cause analysis, and implement preventive fixes.
  • Debug and tune slow-running jobs using partitioning strategies, stage optimization, and performance monitors.
  • Create and execute unit, integration, and regression test plans; participate in code reviews and support UAT.
  • Maintain technical documentation, data lineage, and operational runbooks.

Requirements

  • 8–11 years of experience in DataStage development and enterprise ETL.
  • Experience with IBM InfoSphere DataStage Designer, parallel jobs, sequence jobs, custom routines, and DataStage Director.
  • Advanced SQL and PL/SQL development and optimization experience.
  • Experience with Oracle, DB2, or SQL Server relational databases.
  • Experience with data warehouses, EDW, ODS, and data marts.
  • Experience developing UNIX/Linux shell scripts and supporting operational data pipelines.
  • Experience with ETL testing, code reviews, UAT, troubleshooting, root cause analysis, and performance tuning.

Benefits

  • Annual salary of $90K–$99K depending on experience and qualifications.
  • Eligibility for Cognizant’s discretionary annual incentive program based on performance and applicable plan terms.
  • Medical, dental, vision, and life insurance.
  • Paid holidays and paid time off.
  • 401(k) plan and contributions.
  • Long-term and short-term disability coverage.
  • Paid parental leave.
  • Employee Stock Purchase Plan.

Tech Stack

IBM DB2LinuxMicrosoft SQL ServerSQL

Categories

Data Engineering
Cognizant

About Cognizant

10,000+ employees

Cognizant is a public IT services and consulting firm that designs, builds, and runs enterprise technology, including digital engineering, cloud modernization, data/AI, and managed services. It sells consulting, systems integration, and outsourcing on multi-year engagements to large enterprises in healthcare, banking, retail, communications, and manufacturing. Founded in 1994 and headquartered in Teaneck, New Jersey, Cognizant is NASDAQ-listed (CTSH) and a Fortune 500 company.

Contact me