DataStage Developer

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