Job title- Datastage Developer

Description

- ETL Design &
- Development
- Design, build, and modify parallel jobs, sequence jobs, and custom routines in IBM InfoSphere DataStage (Designer client). -- Must have
- 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 &
- 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 &
- Automation
- Develop and maintain UNIX/Linux shell scripts to automate file handling, job triggers, and operational pipelines.
- Schedule, execute, and monitor jobs using DataStageDirector or enterprise schedulers.
- Troubleshooting &




- 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 &
- 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.
- Collaboration &
- Upgrades

Work closely with data architects, business analysts, QA teams, and infrastructure engineers across the Software Development Life Cycle (SDLC).

📌 DataStage Developer (Canada)
🏢 Cognizant
📍 Canada