ETL Developer

Job Description: Senior DataStage Developer (8+ Years)

Job Overview

We are seeking a highly experienced and analytical Senior DataStage / ETL Developer with over 8 years of hands-on expertise in designing, developing, and managing enterprise-grade data integration pipelines. In this role, you will lead the implementation of complex ETL/ELT architectures, optimize high-volume data warehouses, and mentor junior developers. The ideal candidate will have deep expertise in the IBM InfoSphere DataStage Suite , strong SQL capability, and a solid understanding of modern data platforms.

Key Responsibilities

• Architecture & Design: Analyze complex business requirements and translate them into scalable, end-to-end technical ETL designs and robust data workflows.
• ETL Development: Design, develop, test, and deploy parallel and server jobs using IBM DataStage Designer , utilizing advanced stages (Lookup, Join, Merge, Transformer, Aggregator, etc.).
• Job Management & Sequences: Build and manage complex job sequences, execution loops, custom error-handling mechanisms, and standard job routines.
• Performance Tuning: Troubleshoot production bottlenecks and optimize long-running ETL processes, memory allocations, partition strategies, and SQL queries.
• Database & Data Modeling: Create data mappings, target schema structures, and validate complex data logic across databases like Oracle, Teradata, SQL Server, and DB2 .
• Automation & Orchestration: Write advanced Unix/Linux shell scripts for automated file handling, pre/post-job processing, and parameter configuration.
• Operations & Scheduling: Oversee enterprise job schedulers (such as Control-M , Autosys, or Tivoli) to manage dependencies and production runtime.
• Collaboration & Leadership: Partner with Data Architects, Business Analysts, and QA teams to maintain data quality standards. Provide guidance and code reviews for junior team members.

Required Technical Skills & Qualifications

• Core Tooling: 8+ years of dedicated experience with IBM InfoSphere DataStage (v11.x preferred) including Designer, Director, Administrator, and QualityStage.
• Databases & Languages: Expert-level proficiency in SQL, PL/SQL , and working knowledge of relational database architectures (RDBMS).
• Data Warehousing: In-depth knowledge of Data Warehousing concepts, Star/Snowflake schemas, and Dimension/Fact loading methodologies.