ETL Developer

Job Description

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. It is a responsible and diverse organization of 350,000 team members in nearly 50 countries. Capgemini Romania is building tech savvy teams in Bucharest, Brasov, Cluj and Iasi. With its strong 55 year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms.

As an ETL developer you will be working in a scrum squad consisting of a product owner, a scrum master, business analysis & technical analysis members, other ETL developers, QA and DevOps. The new member is responsible for implementing and testing ETL flows according to business requirements, based on the source to target mappings.

Requirements:

• Minimum 2-3 years of experience in:
1. Developing, testing and implementation of ETL processes and reporting solutions using MS SQL Server tools
2. Project life cycle implementation specific to ETL

o Full Project life cycle implementation specific to ETL
• Performance tuning in MS SQL Server
• Strong foundation of Data Warehouse concepts
• Experience diagnosing problems and troubleshooting production issues
• Strong analytic and problem-solving abilities
• Strong foundation in System Development Lifecycle principles
• Strong written and verbal communication skills
• Ability to work independently and collaboratively

Responsibilities:

• Understand and translate business needs into technology solutions
• Build complete data Integration solutions working in an Agile environment to provide rapid solutions conforming to best practices and to ICT Development standards
• Develop automated data flows, using Visual Studio (dtsx)
• Create technical documentation
• Perform code, design and test plan reviews for peers and develop system
implementation schedules while working closely with operations/ infrastructure team
• Perform System testing
• Analyze and troubleshoot SQL statements, code and model database objects
• Independently perform problem determination and resolution in the production
environment and support production as needed
• Actively propose improvements in implementation, standards and other work
practices.

Benefits:

• Flexible working environment within a dynamic team;
• Access to various training programs and platforms (e.g.: content provided by Pluralsight, Harvard and Coursera);
• Attractive benefits package (meal tickets, medical services, gym discounts);
• Opportunity to work with Top Clients on large projects;
• Continuous learning and improvement activities;
• Dynamic, international working environment;
• Long term career development programs.