Lead Software Engineer - Datastage

Experience

8-10 Years

Location

Bangalore

Role Summary

We are looking for a highly experienced Senior DataStage Administrator with strong development background who can independently handle application performance issues as well as environment-related problems. The role requires deep expertise in IBM InfoSphere DataStage administration, ETL performance tuning, and infrastructure coordination, along with strong troubleshooting and stakeholder management skills.

Key Responsibilities

DataStage Administration & Platform Support

• Perform end-to-end DataStage administration activities including:
  • Project creation, user and role management
  • Import/export of projects
  • Dataset and metadata management
  • Database connectivity (ODBC/JDBC) configuration
• Manage backup and disaster recovery (DR) processes for DataStage environments.
• Perform platform monitoring, health checks, and maintenance activities including:
  • Releasing locked jobs
  • Stop/start of DataStage services
  • Capacity monitoring and tuning
• Monitor platform availability and ensure 24x7 system stability, responding promptly to component failures.

Performance & Issue Management

• Independently handle DataStage job-level and application-related performance issues.
• Analyze CPU, memory, I/O, and cluster-level utilization to identify environment bottlenecks.
• Engage in ETL performance tuning and optimization of DataStage jobs.
• Troubleshoot and resolve environment-related issues in coordination with:
  • UNIX/Linux/AIX administrators
  • Database administrators (Oracle, DB2, etc.)
• Handle P1/P2 incidents, including engagement with IBM via PMRs for critical issue resolution and product enhancements.

Development & Best Practices

• Provide hands-on DataStage development support when needed, ensuring:
  • ETL design adheres to standards and best practices
  • Optimal use of parallelism, partitioning, and stages
• Support development teams in ETL design, debugging, and deployment activities.
• Ensure ETL solutions align with data warehousing concepts and architecture.

Integration, Automation & Security

• Experience with Snowflake connectivity, JDBC driver installation, and client setup.
• Work with workload automation and scheduling tools such as:
  • BMC Control-M
  • Crontab
• Perform and track vulnerability remediation activities related to IBM InfoSphere DataStage.
• Strong understanding of server management, cluster environments, and infrastructure controls.

ITIL, Documentation & Communication

• Apply ITIL processes with strong focus on:
  • Incident management
  • Problem management
  • Change management
• Document production issues, root cause analysis, and resolutions for knowledge reuse.
• Communicate effectively with end users, application teams, and business stakeholders.
• Provide regular status updates on assigned activities and initiatives.
• Continuously evaluate processes and propose improvement opportunities.

Technical Skills (Must Have)

• IBM InfoSphere DataStage (Administration & Development)
• ETL performance tuning and troubleshooting
• UNIX/Linux/AIX environment
• Database connectivity (ODBC/JDBC)
• Shell scripting (Bash, Python, PowerShell preferred)
• Scheduling tools (BMC Control-M, crontab)
• Basic understanding of cloud/warehouse platforms (Snowflake preferred)
• SQL (knowledge in writing query and debug)

Personal & Professional Attributes

• Strong ownership and ability to work independently
• High adaptability and availability during critical incidents
• Analytical mindset with strong problem-solving skills
• Excellent communication and documentation abilities
• Customer-focused and collaborative team player
• Quick learner with the ability to assimilate complex technical environments

Nice to Have

• Experience in banking or financial services environments
• Exposure to large-scale enterprise DataStage landscapes
• Knowledge of security and compliance requirements