Description

Design, develop, and maintain IBM DataStage ETL jobs and SQL Server pipelines.

This role is hybrid.

Responsibilities

• Build end-to-end ETL flows using IBM DataStage, implementing staging, transformation, validation, and publishing to downstream SQL Server schemas.
• Implement source-to-target mapping using common stages (Transformer, Lookup, Join/Merge, Aggregator) with a focus on parallel job design and partitioning.
• Write, optimize, and tune SQL Server queries, stored procedures, and T-SQL scripts for performance and efficiency.
• Ensure operational stability through parameterization, robust logging, reject handling, auditing columns, and reconciliation checks.
• Monitor ETL runs via DataStage Director/Operations Console, perform root-cause analysis on failures, and maintain clear runbooks.

Required Skills

• Hands-on IBM DataStage ETL development experience, including data mapping and transformation implementation.
• Strong SQL Server experience with advanced T-SQL (joins, window functions, CTEs, temp tables, indexing basics, query plans).
• Solid understanding of file-based ingestion and parsing (CSV, fixed-width, headers/trailers, control totals, encoding, delimiters, quoting/escaping).
• Experience designing ETL jobs with good operational characteristics: parameter-driven design, logging, error handling, restart/re-run strategy, and auditability.
• Ability to troubleshoot data issues end-to-end (source file → stage tables → target tables) and communicate findings clearly.
• Bachelor’s degree in Computer Science, Engineering, Information Systems, or equivalent practical experience.
• 5+ years of relevant experience.

Preferred Skills

• Familiarity with UNIX/Linux basics and shell scripting for orchestration and file handling.
• Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys) and CI/CD practices.
• Knowledge of common warehousing patterns (incremental loads, slowly changing dimensions, surrogate keys, effective dating).

Key Skills

Education

Bachelor's degree