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.
About Cognizant
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.
