IBM InfoSphere DataStage

Infosys; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Infosys is seeking a Senior Systems Engineer specialized in IBM InfoSphere DataStage to design and deliver reliable ETL data pipelines for analytics-ready outputs. You will optimize and monitor DataStage jobs, profile data, and ensure data quality across complex datasets.

Collaboration with data engineers, analysts, and platform teams will be essential to meet production SLAs. The role emphasizes scalable, secure data movement, rigorous documentation, and best practices in SQL, scheduling, and

Qualifications

• Bachelor's degree (or equivalent) in Engineering/Computer Science/IT (BTech/BE/BSc or equivalent).
• 23 years of hands-on experience in IBM InfoSphere DataStage development and support.
• Strong working knowledge of ETL concepts, data warehousing fundamentals, and relational databases.
• Proficiency in SQL for querying, transformations, and performance tuning.
• Experience in debugging ETL workflows and supporting production deployments with attention to reliability and accuracy.
• Experience with DataStage parallel framework concepts, partitioning strategies, and performance optimization techniques.

Responsibilities

• Design, develop, and maintain ETL workflows using IBM InfoSphere DataStage to support enterprise data integration needs.
• Build and optimize DataStage jobs (sequences, parallel jobs) with a focus on performance, scalability, and reusability.
• Write and tune SQL queries to support extraction, transformation, validation, and reconciliation activities.
• Perform data profiling, data quality checks, and end-to-end validation to ensure accurate and consistent outputs.
• Troubleshoot job failures, analyze logs, resolve production issues, and implement preventive fixes to improve stability.
• Collaborate with stakeholders to understand data requirements and translate them into technical ETL specifications.
• Maintain technical documentation for job design, mappings, dependencies, and operational runbooks.

Skills

ETL

Data Quality

IBM InfoSphere DataStage

SQL

Data Warehousing

Education

Bachelor's degree in Engineering/CS/IT

Tools

IBM InfoSphere DataStage

Job description

Job DescriptionAbout the job:

Step into a role where your ETL expertise directly powers trusted, analytics-ready data for critical business decisions. As a Senior Systems Engineer focused on IBM InfoSphere DataStage, youll work alongside data engineers, analysts, and platform teams to design and deliver reliable data pipelines that are secure, scalable, and easy to operate. Youll help transform raw, complex datasets into well-structured outputs by building high-quality jobs, optimizing performance, and ensuring smooth production runs. If you enjoy solving data movement challenges, improving runtime efficiency, and collaborating in a delivery-focused environment, this role offers the right mix of ownership and teamwork. Youll also have opportunities to strengthen best practices around SQL, scheduling, monitoring, and documentationmaking data operations more predictable and impactful for everyone involved.

Roles ResponsibilitiesKey Responsibilities:

• Design, develop, and maintain ETL workflows using IBM InfoSphere DataStage to support enterprise data integration needs.
  
• Build and optimize DataStage jobs (sequences, parallel jobs) with a focus on performance, scalability, and reusability.
  
• Write and tune SQL queries to support extraction, transformation, validation, and reconciliation activities.
  
• Perform data profiling, data quality checks, and end-to-end validation to ensure accurate and consistent outputs.
  
• Troubleshoot job failures, analyze logs, resolve production issues, and implement preventive fixes to improve stability.
  
• Collaborate with stakeholders to understand data requirements and translate them into technical ETL specifications.
  
• Maintain technical documentation for job design, mappings, dependencies, and operational runbooks.
  Technical Requirement
• Primary skills:Technology->ETL Data Quality->IBM Infosphere Datastage
  Additional ResponsibilityMinimum Qualifications:
  
• Bachelors degree (or equivalent) in Engineering/Computer Science/IT (BTech/BE/BSc or equivalent).
  
• 23 years of hands-on experience in IBM InfoSphere DataStage development and support.
  
• Strong working knowledge of ETL concepts, data warehousing fundamentals, and relational databases.
  
• Proficiency in SQL for querying, transformations, and performance tuning.
  
• Experience in debugging ETL workflows and supporting production deployments with attention to reliability and accuracy.
  Preferred Qualifications:
  
• Experience with DataStage parallel framework concepts, partitioning strategies, and performance optimization techniques.
  
• Familiarity with job scheduling, dependency management, and operational monitoring for ETL pipelines.
  
• Exposure to data reconciliation approaches, audit controls, and handling incremental/CDC-style loads.
  
• Ability to collaborate effectively across teams, communicate technical findings clearly, and contribute to delivery timelines.
  
• Experience working with version control and structured release processes for ETL artifacts.
  Good to have skills:
  Unix/Linux, Shell Scripting, IBM DB2, Oracle, Informatica PowerCenter
  Educational RequirementMCA,MSc,MTech,Bachelor of Engineering,BTech
  Preferred SkillsTechnology->ETL Data Quality->IBM Infosphere Datastage->IBM Infosphere Datastage - Datastage
  Service LineData Analytics Unit