Lead Data Engineer ETL
Responsibilities
Daily Operations & ETL Run Management
· Ensure the complete and correct execution of all daily ETL batches. All detected errors must be identified, logged, analyzed, and resolved independently, including documentation of findings and corrective actions
· Maintain and enhance Informatica PowerCenter ETL processes
· Maintain, optimize, and enhance ETL processes
· Maintain: ETL, Python, Java, Shell Scripts and Elastic Search
· Adjust batch chains according to operational needs
· Provide effort estimations for operational and change tasks
· Create technical specifications for new requirements
· Observe Linux Servers (Load, Diskspace, etc.), check Informatica Services Logfiles on errors
· Work in metadata driven environments (DEV,TST,REF,PRD) based and script ecosystem
· Administration/configuration of Informatica and Services
Incident & Problem Management
· Evaluate incoming incidents and classify urgency & impact
· Investigate error patterns and complex data-processing issues
· Apply and coordinate corrective measures
· Perform Root Cause Analysis (RCA)
· Document all activities in the ticketing system (JIRA/Kanban)
Change Management
· Follow internal governance, BAIT, MaRisk and compliance guidelines
· Coordinate required inputs from technical and business stakeholders
· Conduct effort estimation and timeline planning
· Specify and implement ETL-related functional changes
· Modify data models, ETL flows, and reporting logic
· Prepare and participate in CAB (Change Advisory Board) meetings
· Document all change-related activities
Testing Activities
· Plan and conduct technical acceptance tests
· Prepare test cases and perform manual or automated tests
· Execute regression tests for ETL components
· Document test steps, test results, and create formal test reports
Concept Creation & Technical Documentation
Creation or contribution to:
· Architecture concepts
· Test concepts
· Permission concepts
· Operating manuals
· Disaster recovery / contingency concepts
· Processing guidelines
· Archiving & deletion concepts
· Regular updates based on regulatory changes (BAIT, MaRisk, etc.).
Authorization Management
· Create, modify, and remove access permissions
· Ensure audit-proof documentation
· Maintain internal access overview records
· Support recurring user access reviews
Deployment Management
· Independently plan, coordinate, and execute deployments across DEV/REF/PRD
· Ensure all deployment activities follow the 4‑eyes principle and internal governance
· Validate deployment artifacts and ensure compliance with standards
· Conduct smoke tests after deployments and ensure system stability
· Document deployment steps
Profile required
· Strong knowledge of Informatica PowerCenter
· Very strong SQL (Oracle; SQL Developer), PLSQL, Python, Java and Shell Script skills & Unix script skills
· ETL design, batch processing, and DWH architecture experience
· Experience with modelling tools (PowerDesigner)
· Familiarity with JIRA/Kanban operational tracking
· Strong understanding of testing methodologies and regression testing
Experience with operational DWH environments at enterprise scale
Why join us
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
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.