Lead Specialist Software Engineer - Datastage

We are seeking an experienced datawarehouse engineer with strong skills on Datatstage. The ideal candidate will have a solid background in data ingestion, data processing, and data management using Data warehousing /ETL projects on Data validations .

Knowledge on Datastage  & Teradata/Postgres development is a must to have.. You will be responsible Independently design components, develop code and test case scenarios by applying relevant software craftsmanship principles and meet the acceptance criteria using Datastage. In addition, you will work with CI/CD tools, such as Jenkins, and schedulers like CTRL-M, to automate data workflows.

•  7+ years of experience in DataStage and Teradata development within Data Warehousing projects, preferably in the Banking domain.

• Proven leadership experience in Agile environments, actively driving Agile ceremonies and fostering team collaboration.
• Strong expertise in Unix commands and scripting, with the ability to guide and mentor team members.
• Extensive experience in Data Warehousing/ETL projects, including data governance and quality assurance.
• Experience leading end-to-end project delivery, managing multiple individual contributors.
• Proficient in Control-M for scheduling Unix jobs, with oversight of job scheduling strategies.
• Advanced SQL skills with analytical expertise to identify data anomalies and lead resolution efforts.
• Knowledge of Cloud tools like Snowflake is a plus.
• Skilled in stakeholder communication, translating technical challenges and business requirements effectively between BAs, developers, and operations teams.
• Strong analytical and troubleshooting skills to address complex business requirements.
• Excellent verbal and written communication skills to coordinate with all stakeholders including senior management.

Technical Skills Required

·       DB : TERADATA

·       ETL with devops environment : Datatsage

·       Source code : Git on github.

·       OS : Linux and good proficiency on shell scripting.

·       Methodology : Agile via Scrum/Kanban (tool Jira)

• Good to have knowledge of Snowflake or cloud data platforms 

• Good to have BI MicroStrategy knowledge – This is more relevant to PLR and not for EDC and CMW.

  
  

• Responsibilities

• Lead the design, development, and testing of data warehousing components using DataStage, ensuring adherence to software craftsmanship and quality standards.
• Own the end-to-end delivery of projects, including planning, resource allocation, risk management, and quality assurance.
• Drive the full Software Development Life Cycle (SDLC) in an Agile framework, mentoring the team on best practices and Agile principles.
• Collaborate cross-functionally with other development teams to define and implement robust data pipelines and integrations.
• Communicate proactively with stakeholders, including business analysts, product owners, and operations, to ensure alignment on technical solutions and business goals.
• Identify production bottlenecks and lead continuous improvement initiatives to enhance system reliability and performance.
• Oversee production load management, incident resolution, and post-release support activities.
• Ensure thorough release validations, metrics reporting, and defect management.
• Foster a culture of technical excellence, continuous learning, and knowledge sharing within the team.
• Act as a technical escalation point and mentor for junior and senior team members.

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.