Data integration remains a cornerstone of modern analytics, and expertise in IBM DataStage is in high demand across industries. Companies are seeking seasoned developers who can design, build, and maintain robust ETL pipelines to power data‑driven decisions. This long‑term hybrid role in Columbus offers a stable W‑2 position for U.S. citizens or green‑card holders looking to advance their DataStage career.

Job Summary

We are looking for a DataStage Developer with 5‑10 years of hands‑on experience to join a Columbus‑based team on a hybrid schedule (3 days onsite). The role involves designing, developing, and maintaining ETL jobs in IBM DataStage, collaborating with data architects, and ensuring data quality for enterprise reporting. The position is a full‑time W‑2 role, open to U.S. citizens or green‑card holders.

Top 3 Critical Skills Table

Interview Preparation

1. Explain the end‑to‑end process you follow when building a new DataStage job.
   What the interviewer is looking for: Understanding of requirement analysis, source/target mapping, stage selection, performance tuning, and testing.

2. How do you troubleshoot a job that fails intermittently in production?
   What the interviewer is looking for: Ability to use logs, reject files, and DataStage Director to isolate issues, plus knowledge of data quality checks.

3. Describe a situation where you optimized an ETL workflow for performance. Which techniques did you use?
   What the interviewer is looking for: Experience with parallelism, partitioning, push‑down optimization, and resource tuning.

4. What are the differences between Server‑Side and Client‑Side execution in DataStage, and when would you choose each?
   What the interviewer is looking for: Deep technical knowledge of execution modes and impact on resource consumption.

5. How do you ensure data security and compliance when handling sensitive data in your pipelines?
   What the interviewer is looking for: Familiarity with encryption, masking, role‑based access, and audit logging.

Resume Optimization

• DataStage
• ETL Development
• SQL
• Data Integration
• Data Warehousing
• Performance Tuning
• Data Quality
• W‑2 Employment
• US Citizenship
• Green Card

Application Strategy

When reaching out to the recruiter, send a concise email that greets the hiring manager, briefly introduces yourself, and attaches your updated resume. Clearly highlight your 5‑10 years of DataStage experience, mention any large‑scale ETL projects you’ve led, and map your top skills—such as DataStage, ETL design, and SQL—to the requirements listed in the job description. End by expressing enthusiasm for the hybrid Columbus role and your eligibility to work in the U.S.

Career Roadmap