Omm IT Solutions - Senior Data Engineer (DataStage) - Contractor

Data Scientist is needed in Orlando, United States.

Client: Omm IT Solutions

Location: Orlando, FL, us

Contract: Contract

Job Description

The role is for a Software Engineer with strong ETL experience, responsible for designing, building, and supporting file-to-table data transformations using IBM InfoSphere DataStage. The candidate will turn inbound file feeds into reliable, auditable SQL Server table loads with an emphasis on performance, error handling, and repeatable operations.

Key Responsibilities

• Design, develop, and maintain IBM DataStage ETL jobs that ingest file feeds (CSV, fixed-width, delimited) and load curated destination tables in SQL Server.
• Build end-to-end ETL flows, including staging, transformations, validations, and publishing to downstream schemas.
• Perform source-to-target mapping and implement transformation logic based on business and technical requirements.
• Utilize common DataStage stages and patterns with attention to partitioning and parallel job design.
• Write, optimize, and tune SQL Server queries, stored procedures, and T-SQL scripts used in ETL workflows.
• Implement restartable and supportable jobs with robust logging, reject handling, auditing columns, and reconciliation checks.
• Apply data quality controls and produce clear exception outputs for remediation.
• Monitor and troubleshoot ETL runs, performing root-cause analysis and fixing defects.
• Improve performance through job design tuning and SQL tuning.
• Participate in code reviews, testing, and documentation; maintain clear runbooks and operational procedures.
• Collaborate with business analysts, data modelers, QA, and production support to deliver stable pipelines.

Requirements

Required Skills

• Hands-on IBM DataStage ETL development experience, including data mapping and transformation implementation.
• Strong SQL Server experience with advanced T-SQL, including joins, window functions, CTEs, temp tables, indexing basics, and 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 including parameter-driven design, logging, error handling, and auditability.
• Ability to troubleshoot data issues from end-to-end and communicate findings clearly.

Preferred Qualifications

• Experience with DataStage Parallel Jobs tuning, including partitioning methods and skew handling.
• Familiarity with UNIX/Linux basics and shell scripting for orchestration and file handling.
• Experience with job scheduling/orchestration tools and CI/CD practices.
• Knowledge of common warehousing patterns like incremental loads and surrogate keys.
• Experience with version control (Git) and structured promotion/release processes across environments.
• Exposure to data governance practices and secure handling of sensitive data.

Additional Information

• Hybrid position located in Orlando, FL.
• Work mode: 3 days a week onsite.
• Duration: Contract (with possible extension).