Data Engineer – Senior IBM DataStage Developer

Role Name: Data Engineer – Senior IBM DataStage Developer Location: Cincinnati, OH Job Description Job Summary We are seeking a highly skilled Senior IBM DataStage Developer with 5+ years of hands-on experience designing, developing, implementing, and supporting enterprise-level data integration and ETL solutions using IBM InfoSphere DataStage. The ideal candidate will possess strong expertise in data warehousing, ETL development, database technologies, and performance optimization. This individual will collaborate closely with business stakeholders, data architects, and development teams to deliver scalable, reliable, and high-quality data solutions. Key Responsibilities; Design, develop, test, and deploy ETL processes using IBM InfoSphere DataStage. Analyze business requirements and translate them into effective 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 into data warehouses and data marts. Optimize DataStage jobs to improve performance, scalability, and reliability. Monitor ETL workflows, troubleshoot production issues, and implement corrective solutions. Conduct data validation, reconciliation, and quality assurance checks. Collaborate with database teams to design and implement efficient data models. Create and maintain technical documentation, mapping specifications, 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 Skills: ETL & Data Integration IBM InfoSphere DataStage (PX/Parallel Jobs, Server Jobs, and Sequences) DataStage Designer, Director, and Administrator DataStage Parallel Extender (PX) Job sequencing and workflow management DataStage performance tuning and optimization Database Technologies Oracle Microsoft SQL Server PostgreSQL Snowflake (preferred) Programming & Scripting SQL and advanced SQL queries UNIX/Linux Shell Scripting Python (preferred) Data Warehousing Data warehousing concepts and architecture Dimensional modeling (Star Schema and Snowflake Schema) Fact and Dimension tables Data migration and data conversion Tools & Technologies Control-M or AutoSys Git, SVN, or other version control tools JIRA or other Agile project management tools Required Qualifications: Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field. Minimum of 5 years of hands-on experience developing ETL solutions using IBM InfoSphere DataStage. Strong understanding of ETL methodologies and data integration best practices. Experience working with large-volume data processing environments. Strong SQL programming and database development skills. Proven experience in production support, troubleshooting, and issue resolution. Solid understanding of the 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. Familiarity with Big Data technologies, including Hadoop and Apache Spark. Key Competencies Strong analytical and problem-solving abilities. Excellent communication and stakeholder management skills. Ability to work independently and lead ETL development activities. Strong attention to detail and commitment to data quality. Effective teamwork and cross-functional collaboration skills. Nice-to-Have Skills Snowflake Data Warehouse Informatica or Talend ETL tools Amazon Web Services (AWS) Databricks Apache Kafka or other real-time data integration technologies CI/CD pipeline implementation for ETL deployments “All qualified applicants will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.”