Specialist Software Engineer - Datastage

We are looking for an experienced Senior DataStage Developer to lead our data engineering and migration initiatives. In this role, you will architect, develop, and optimize large-scale data processing and analytics solutions, with a strong focus on modernizing our Datawarehouse ecosystem into Snowflake. You will work with advanced technologies to deliver high‑quality pipelines for data ingestion, transformation, storage, and processing. Your expertise in both traditional ETL tool like DataStage and Snowflake will play a key role in shaping our data modernization strategy while ensuring the performance, reliability, and scalability of our next‑generation data platform.
Lead the migration of existing DataStage workloads to Snowflake Lakehouse, ensuring scalable, high-quality solutions.

• Provide technical leadership in data modeling, ELT/ETL design, performance tuning, and Snowflake best practices.
• Drive analysis, refactoring, and optimization of legacy code to align with Snowflake architecture.
• Oversee testing, validation, debugging, and automation of migrated pipelines.
• Collaborate closely with cross‑functional and distributed teams, representing the engineering team as the SPOC for status, risks, and delivery updates.
• Guide DevOps activities including CI/CD, environment setup, and release readiness.
• Mentor junior engineers, enforce coding standards, and ensure adherence to engineering guidelines.
• Participate in Agile ceremonies and ensure high-quality, defect‑free sprint deliveries.

Job Description

• 5-7 years of experience in DataStage development within Data Warehousing projects.
• Strong hands‑on experience with Snowflake SQL, including complex queries and performance tuning.
• Good understanding of ETL/Data Warehouse concepts, including data validations and reconciliation.
• Strong knowledge of Unix commands and shell scripting.
• Experience with Control-M for scheduling DataStage and Unix jobs.
• Proficient in SQL, with strong analytical skills to identify data anomalies and provide resolutions.
• Experience working in Agile/Scrum environments and active participation in Agile ceremonies.
• Ability to work as an individual contributor, taking ownership of deliverables end-to-end.
• Good communication skills to collaborate with Business Analysts (BAs) on technical issues and acceptance criteria for business changes in pre-prod and prod environments.
• Strong analytical and troubleshooting skills to address business and production requirements.
• Excellent verbal and written communication skills to work with multiple stakeholders.
• Good to have: Knowledge of cloud data platforms.

Responsibilities

• Independently design, develop, and test DataStage components, ensuring alignment with acceptance criteria and software craftsmanship principles.
• Deliver across all phases of the Software Development Life Cycle (SDLC) in line with Agile practices.
• Manage production deployments and provide post‑production support.
• Collaborate with cross-functional teams to define and implement data pipelines.
• Ensure timely and effective communication with counterparts, stakeholders, and partners.
• Identify and address recurring production issues and propose improvement actions.
• Manage and support production batch loads.
• Perform release validations, ensuring defect‑free deployments.
• Prepare and maintain metrics, test results, and defect reports.

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.