Lead Software Engineer - Datastage

SGS Société Générale de Surveillance SA; Bengaluru; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

SGS Société Générale de Surveillance SA in Bengaluru seeks a highly experienced Senior DataStage Administrator with a strong development background to independently handle performance and environment issues, leveraging IBM InfoSphere DataStage expertise.

You will lead DataStage admin, ETL tuning, UNIX/Linux coordination, and work with DBAs and IT teams to ensure 24/7 reliability and alignment with data warehousing architecture.

Qualifications

• Experience with IBM InfoSphere DataStage administration and development.
• ETL performance tuning and troubleshooting.
• Strong UNIX/Linux/AIX administration skills.
• Database connectivity via ODBC/JDBC and scripting exposure.

Responsibilities

• DataStage Administration & Platform Support: project creation, user/role management, import/export, dataset and metadata management, DR planning, backup and recovery.

Skills

IBM DataStage

ETL performance tuning

UNIX/Linux/AIX

ODBC/JDBC connectivity

Shell scripting (Bash/Python)

Scheduling tools (BMC Control-M/crontb

Snowflake / cloud DW awareness

SQL

Tools

DataStage Administration & Development

Job description

Responsibilities

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 managementImport/export of projectsDataset and metadata managementDatabase connectivity (ODBC/JDBC) configurationManage backup and disaster recovery (DR) processes for DataStage environments.
• Perform platform monitoring, health checks, and maintenance activities including: Releasing locked jobsStop/start of DataStage servicesCapacity monitoring and tuningMonitor 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 administratorsDatabase 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 practicesOptimal 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-MCrontab.
• 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 managementProblem managementChange managementDocument production issues, root cause analysis, and resolutions for knowledge reuse.

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.

ESG Commitment

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.