Lead Software Engineer - Datastage

Societe Generale Global Solution Centre; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Société Générale is seeking a Senior DataStage Administrator with strong development background in Bangalore. You will independently handle DataStage administration, performance tuning, and environment-related issues, coordinating with UNIX/Linux and DBAs to ensure robust ETL operations.

You will provide hands-on development support, ensure best practices in ETL design, and manage incidents with IBM PMRs when needed. The role requires 24x7 availability and strong stakeholder communication.

Qualifications

• DataStage administration & development expertise.
• ETL performance tuning and troubleshooting.
• Unix/Linux/AIX environment proficiency.
• Database connectivity with ODBC/JDBC.
• Shell scripting (Bash/Python/PowerShell).
• Scheduling tools such as BMC Control-M or crontab.
• Basic understanding of Snowflake and cloud data warehousing.
• SQL knowledge and debugging skills.

Responsibilities

• DataStage Administration & Platform Support including projects, users, imports/exports, and metadata.
• Backup/DR management and platform health checks, including service restarts and capacity tuning.
• Monitor 24x7 availability and respond to failures; manage incidents with IBM PMRs as needed.
• Performance issue diagnosis, ETL tuning, and coordination with UNIX/Linux and DBAs.
• Hands-on DataStage development support and adherence to best practices.
• Support integration, automation, and security; Snowflake connectivity and scheduling tools.
• ITIL-aligned incident/problem/change management and documentation.

Skills

IBM InfoSphere DataStage

ETL performance tuning

UNIX/Linux/AIX

ODBC/JDBC connectivity

Shell scripting

Scheduling tools

Snowflake

SQL

Job description

Role Summary

We are looking for a highly experienced

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