Lead Software Engineer - Datastage

Reference 26000CGV

Experience Responsibilities 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.

Required Profile required 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

Why join us We are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status

Business insight At Société Générale, we are convinced that peo…