DataStage Developer

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. Work closely with data architects, business analysts, QA teams, and infrastructure engineers across the Software Development Life Cycle (SDLC).

#J-18808-Ljbffr