Skip to main content
Johnson Jobs

DataStage Senior Developer W2 opening

new york technology partnersDayton, OH

today

Occupations

Data Warehousing SpecialistsSoftware DevelopersDatabase Architects

Industries

Computer Systems Design ServicesCustom Computer Programming ServicesSoftware Publishers
APPLY NOW (opens in a new tab)

About the role

Job Description
Role: DataStage Senior Developer
Duration: Long Term Contact
Location: Cincinnati, OH HybridJob Summary
We are seeking a highly skilled DataStage Senior Developer with 5+ years of experience in designing, developing, and supporting enterprise data integration and ETL solutions using IBM InfoSphere DataStage. The ideal candidate will have strong expertise in data warehousing, ETL development, database technologies, and performance optimization. The individual will work closely with business stakeholders, data architects, and development teams to deliver high-quality data solutions.
Key Responsibilities:
  • Design, develop, test, and deploy ETL processes using IBM InfoSphere DataStage.
  • Analyze business requirements and translate them into technical ETL solutions.
  • Develop and maintain DataStage jobs, sequences, shared containers, and reusable components.
  • Perform data extraction, transformation, and loading (ETL) from multiple source systems to data warehouses and data marts.
  • Optimize DataStage jobs for performance, scalability, and reliability.
  • Monitor ETL workflows and troubleshoot production issues.
  • Conduct data validation, reconciliation, and quality checks.
  • Work with database teams to design and implement efficient data models.
  • Create and maintain technical documentation, mapping documents, and deployment procedures.
  • Participate in code reviews and ensure adherence to development standards and best practices.
  • Support production releases, incident management, and root cause analysis.
  • Collaborate with cross-functional teams including Business Analysts, Architects, QA teams, and Support teams.
  • Required Technical SkillsETL & Data IntegrationIBM InfoSphere DataStage (PX/Parallel Jobs, Server Jobs, Sequences)
  • DataStage Designer, Director, Administrator
  • DataStage Parallel Extender (PX)
  • Job sequencing and workflow management
  • DataStage performance tuning and optimization
  • DatabasesOracleSQL Server
  • PostgreSQLSnowflake (preferred)
  • Programming & ScriptingSQL and Advanced SQL QueriesUNIX/Linux Shell Scripting
  • Python (preferred)
  • Data Warehousing
  • Data Warehouse concepts
  • Dimensional Modeling (Star Schema, Snowflake Schema)
  • Fact and Dimension tables
  • Data Migration and Data Conversion
  • Tools & Technologies
  • Control-M or Autosys
  • Git, SVN, or other version control toolsJIRA or Agile project management tools
Required Qualifications: Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.5+ years of hands-on experience with IBM InfoSphere DataStage development. Strong knowledge of ETL methodologies and data integration best practices. Experience working with large-volume data processing environments. Strong SQL and database development skills. Experience in production support and issue resolution. Understanding of Software Development Life Cycle (SDLC) and Agile methodologies.
Preferred Qualifications: IBM DataStage Certification. Experience with Cloud Data Platforms such as AWS, Azure, or Snowflake. Knowledge of Data Governance and Data Quality frameworks. Experience with Big Data technologies (Hadoop, Spark) is a plus.
Key Competencies: Strong analytical and problem-solving skills. Excellent communication and stakeholder management skills. Ability to work independently and lead ETL development activities. Attention to detail and commitment to data quality. Strong teamwork and collaboration abilities.
Nice-to-Have Skills
Snowflake Data Warehouse: Informatica or Talend ETL toolsAWSDatabricksKafka or real-time data integration technologiesCI/CD pipeline implementation for ETL deployments

Matching similar jobs

JOB OVERVIEW

Experience level

Lead

Location

Dayton, OH

Occupation

Data Warehousing Specialists

Industry

Computer Systems Design Services

Posted

today

Tired of running searches?

Rank the roles you'd take once, and matches like these arrive on their own.

CREATE PROFILE (opens in a new tab)