Senior Data Engineer

Hybrid in Orlando, FL, US • Posted 5 hours ago • Updated 5 hours ago
Part Time
No Travel Required
Able to Sponsor
Hybrid
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

  • Auditing

Summary

Role summary Software Engineer with strong ETL experience to design, build, and support file-to-table data transformations using IBM InfoSphere DataStage. You'll turn inbound file feeds into reliable, auditable SQL Server table loads with solid performance, clear 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.
  • Use common DataStage stages and patterns (e.g., Sequential File, Transformer, Lookup, Join/Merge, Aggregator, Sort, Funnel, Remove Duplicates), with attention to partitioning and parallel job design.
  • Write, optimize, and tune SQL Server queries, stored procedures, and TSQL scripts used in ETL workflows.
  • Implement restartable and supportable jobs: parameterization, robust logging, reject handling, auditing columns, and reconciliation checks.
  • Apply data quality controls (format checks, referential checks, null/duplicate checks, threshold checks) and produce clear exception outputs for remediation.
  • Monitor and troubleshoot ETL runs using DataStage Director/Operations Console and SQL Server tooling; perform root-cause analysis and fix defects.
  • Improve performance through job design tuning (partitioning strategy, sorting choices, buffering, pushdown where appropriate) and SQL tuning (indexes, statistics, set-based logic).
  • Participate in code reviews, testing, documentation, and release activities; maintain clear runbooks and operational procedures.
  • Collaborate with business analysts, data modelers, QA, and production support to deliver stable pipelines.

Required skills and experience

  • Hands-on IBM DataStage ETL development experience, including data mapping and transformation implementation.
  • Strong SQL Server experience with advanced TSQL (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.

Preferred qualifications

  • Experience with DataStage Parallel Jobs tuning (partitioning methods, collect/sort trade-offs, skew handling).
  • Familiarity with UNIX/Linux basics and shell scripting for orchestration and file handling.
  • Experience with job scheduling/orchestration tools (e.g., ControlM, Autosys) and CI/CD practices.
  • Knowledge of common warehousing patterns (incremental loads, slowly changing dimensions, surrogate keys, effective dating).
  • Experience with version control (Git) and structured promotion/release processes across environments (dev/test/prod).
  • Exposure to data governance practices (metadata, lineage, naming standards) and secure handling of sensitive data.

Education

  • Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent practical experience.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91103492
  • Position Id: 8927847
  • Posted 5 hours ago

Company Info

About Netsynk

Netsynk is a pioneer in the staffing world.' Our mission has been to serve our clients, employees, partners and community by doing it right. People first is our motto. Finding the right candidate for a client or finding a right job for a candidate can sometimes seem a Herculean task. Our goal is to make this task, just not a smooth and easy, but also an enriching and fun experience for them both. Our experience and helpful network helps place talented professionals in organizations across the country, making the experience for both the client and the consultant an enriching one. At Netsynk, the job is where the dream is built. Irrespective of who you are, a recent graduate or high level professional looking for your next good break or even a company looking for help in staffing; we can definitely help. Vision Statement Be the sought after staffing services company for our clients and consultants Mission Statement Serve our clients, employees, partners and community by doing it right.

Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Orlando, Florida

Today

Easy Apply

Contract

$70 - $75

Hybrid in McLean, Virginia

Today

Easy Apply

Contract

$50 - $55

Search all similar jobs