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

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

At Société Générale, we are convinced that people are drivers of change, and that the world of tomorrow will be shaped by all their initiatives, from the smallest to the most ambitious. Whether you’re joining us for a period of months, years or your entire career, together we can have a positive impact on the future. Creating, daring, innovating, and taking action are part of our DNA. If you too want to be directly involved, grow in a stimulating and caring environment, feel useful on a daily basis and develop or strengthen your expertise, you will feel right at home with us!

Still hesitating?
You should know that our employees can dedicate several days per year to solidarity actions during their working hours, including sponsoring people struggling with their orientation or professional integration, participating in the financial education of young apprentices, and sharing their skills with charities. There are many ways to get involved.

We are committed to support accelerating our Group’s ESG strategy by implementing ESG principles in all our activities and policies. They are translated in our business activity (ESG assessment, reporting, project management or IT activities), our work environment and in our responsible practices for environment protection.