Senior Data Engineer(SSIS, Data Warehouse, ADF, ADB, Python)
__jobinformationwidget.freetext.LocationText__
Bangalore
We’re AtkinsRéalis, a world-leading Design, Engineering and Project Management organization. Created by the integration of long-standing organizations dating back to 1911, we are a world-leading professional services and project management company dedicated to engineering a better future for our planet and its people. We create sustainable solutions that connect people, data and technology to transform the world's infrastructure and energy systems. We deploy global capabilities locally to our clients and deliver unique end-to-end services across the whole life cycle of an asset including consulting, advisory & environmental services, intelligent networks & cybersecurity, design & engineering, procurement, project & construction management, operations & maintenance, decommissioning and capital. The breadth and depth of our capabilities are delivered to clients in key strategic sectors such as Engineering Services, Nuclear, Operations & Maintenance and Capital.
News and information are available at www.atkinsrealis.com or follow us on LinkedIn.
Our teams are proud to deliver on some of the most prestigious projects across the world. It's thanks to our talented people and their diverse thinking, expertise, and knowledge. Join us and you'll be part of our genuinely collaborative environment, where everyone is supported to make the most of their talents and expertise.
When it comes to work-life balance, AtkinsRéalis is a great place to be. So, let's discuss how our flexible and remote working policies can support your priorities. We're passionate about are work while valuing each other equally. So, ask us about some of our recent pledges for Women's Equality and being a 'Disability Confident' and 'Inclusive Employer’.
Roles and Requirements:
- Develop ETL using SSIS.
- Design and develop SQL Server stored procedures, functions, views, and triggers to be used during the ETL process.
- Develop complex SQL queries for small to large sets of data, lead query optimization efforts.
- Design and architect artifacts using Data Modelling concepts.
- Designing databases and some data sourcing/ETL requirements for efficient use in reporting and BI.
- Builds data transformations with SSIS including importing data from files, moving data from one database platform to another.
- Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data.
- Design, implement and maintain database objects (tables, views, indexes) considering database security.
- Experience working with SSIS packages.
- Analyse and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations.
- Test and prepare ETL processes for deployment to production and non-production environments.
- Support system and acceptance testing including the development or refinement of test plans.
- Administer all requirements and design various functional specifications for data.
- Evaluate all codes and ensure the quality of all project deliverables.
- Managing resources for the team
- Knowledge on Azure Tech Stack is added advantage. Mainly on ADF, Data Bricks, Python
- Good team player
- Able to work on a project on Individual contributor role.
- Good communication skills
What We Can Offer You:
- Varied, interesting and meaningful work.
- A hybrid working environment with flexibility and great opportunities.
- Opportunities for training and, as the team grows, career progression or sideways moves.
- An opportunity to work within a large global multi-disciplinary consultancy on a mission to change the ways we approach business as usual.
Why work for AtkinsRéalis?
We at AtkinsRéalis are committed to developing its people both personally and professionally. Our colleagues have the advantage of access to a high ranging training portfolio and development activities designed to help make the best of individual’s abilities and talents. We also actively support staff in achieving corporate membership of relevant institutions.
Meeting Your Needs:
To help you get the most out of life in and outside of work, we offer employees ‘Total Reward’.
Making sure you're supported is important to us. So, if you identify as having a disability, tell us ahead of your interview, and we’ll discuss any adjustments you might need.
Additional Information:
We are an equal opportunity, drug-free employer committed to promoting a diverse and inclusive community - a place where we can all be ourselves, thrive and develop. To help embed inclusion for all, from day one, we offer a range of family friendly, inclusive employment policies, flexible working arrangements and employee networks to support staff from different backgrounds. As an Equal Opportunities Employer, we value applications from all backgrounds, cultures and ability.
We care about your privacy and are committed to protecting your privacy. Please consult our Privacy Notice on our Careers site to know more about how we collect, use and transfer your Personal Data.
Link: Equality, diversity & inclusion | Atkins India (atkinsrealis.com)
Accroche
CanadaType de contenu
BlogsDate de publication
10/10/2024
Récapitulatif
Des stages en ingénierie aux postes de direction : Mon parcours chez AtkinsRéalis Découverte du leadership grâce à mes stages en génie civil Allô, je m’appelle Karolane. Je travaille chez Atk
Accroche
CanadaType de contenu
BlogsDate de publication
10/10/2024
Récapitulatif
Des stages en ingénierie aux postes de direction : Mon parcours chez AtkinsRéalis Découverte du leadership grâce à mes stages en génie civil Allô, je m’appelle Karolane. Je travaille chez Atk
Related job roles
Salaire
Localisation
Gurgaon, Haryana
Types d'emploi
Temps plein
Career Area
Engineering (Other)
Marché
Transports
Category
Loan of Personnel
Location
Gurgaon
Description
We’re AtkinsRéalis, a world-leading Design, Engineering and Project Management organization. Created by the integration of long-standing organizations dating back to 1911, we are a world-leading profe
Référence
R-116259
Date d’expiration
01/01/0001
Salaire
Localisation
Vasteras
Types d'emploi
Temps plein
Career Area
Linxon - NewCo
Category
Permanent
Location
Västerås
Description
Job Title: HSE SpecialistLocation: Vasteras, SwedenAs HSE Specialist in Linxon Sweden you will be working within our country HSEQ organization and acting as a direct support to project managers. You
Référence
R-120965
Date d’expiration
01/01/0001
Salaire
Localisation
Bangalore
Types d'emploi
Temps plein
Career Area
Engineering (Other)
Category
Permanent
Location
Bangalore
Description
We’re AtkinsRéalis, a world-leading Design, Engineering and Project Management organization. Created by the integration of long-standing organizations dating back to 1911, we are a world-leading profe
Référence
R-119990
Date d’expiration
01/01/0001
Salaire
Localisation
Site Office
Types d'emploi
Temps plein
Career Area
Finance
Category
Permanent
Location
Saudi Arabia
Description
ESSENTIAL DUTIES AND RESPONSIBILITIES:Accounting:· Review all invoices for appropriate documentation and approval prior to payment· Record supplier invoices and other payment request in the system· Re
Référence
R-121737
Date d’expiration
01/01/0001
Salaire
Localisation
Site Office
Types d'emploi
Temps plein
Career Area
Quantity surveying
Marché
Project, programme & cost management
Category
Permanent
Location
Saudi Arabia
Description
We are currently looking for an experienced Commercial Professional to support AtkinsRéalis in delivering professional design and engineering consultancy services in Saudi Arabia. You will be involved
Référence
R-121211
Date d’expiration
01/01/0001
Salaire
Localisation
Toronto
Types d'emploi
Temps plein
Career Area
Physical hydrogeology & hydrology
Marché
Mines et métallurgie
Category
Permanent
Location
Calgary
Edmonton
Vancouver
Toronto
Description
Hydrotechnical Engineer Are you looking for a company that works on major engineering projects all over the world? Do you want to make a difference by improving the daily lives of communities worldwid
Référence
R-121215
Date d’expiration
01/01/0001
Salaire
Localisation
West Midlands
Types d'emploi
Temps plein
Career Area
Earth sciences
Marché
Villes et développement urbain
Category
Permanent
Location
West Midlands
Description
We have a great opportunity for a dynamic and motivated Contaminated Land / Environmental Consultant / Hydrogeologist to join our Sustainable Land and Resource Management Practice in our Birmingham of
Référence
R-119203
Date d’expiration
01/01/0001
Salaire
Localisation
Vancouver
Types d'emploi
Temps plein
Career Area
Geoscience & materials
Marché
Mines et métallurgie
Category
Permanent
Location
Calgary
Vancouver
Ottawa
Toronto
Description
Advanced Reactive Transport Modeler Are you looking for a company that works on major engineering projects all over the world? Do you want to make a difference by improving the daily lives of communit
Référence
R-120750
Date d’expiration
01/01/0001
Salaire
Localisation
Vancouver
Types d'emploi
Temps plein
Career Area
Physical hydrogeology & hydrology
Marché
Mines et métallurgie
Category
Permanent
Location
Vancouver
Description
Senior Mine Water Engineer Are you looking for a company that works on major engineering projects all over the world? Do you want to make a difference by improving the daily lives of communities world
Référence
R-120749
Date d’expiration
01/01/0001
Salaire
Localisation
Chennai
Types d'emploi
Temps plein
Career Area
Linxon - NewCo
Category
Permanent
Location
Chennai
Description
Join Us!We combine AtkinsRéalis project management expertise and Hitachi Energy’s deep technological knowledge to create a company dedicated to substations – we are Linxon! This role is both tender an
Référence
R-122067
Date d’expiration
01/01/0001
Related articles
Accroche
CanadaType de contenu
BlogsDate de publication
10/25/2023
Récapitulatif
Face à la crise énergétique mondiale et à l’urgence des changements climatiques, l’énergie nucléaire s’impose comme partie essentielle de la solution. Si vous faites carrière dans le domaine nucléaire
Accroche
CanadaType de contenu
BlogsDate de publication
10/25/2023
Récapitulatif
À une époque définie par la conscience environnementale et les pratiques commerciales responsables, le développement durable est devenu un enjeu essentiel pour les entreprises du monde entier. Comment
Accroche
CanadaType de contenu
BlogsDate de publication
10/31/2022
Récapitulatif
Les ingénieurs forment une cohorte curieuse et ambitieuse, qui cherche toujours des moyens d’assurer l’avenir de leur carrière et de relever de nouveaux défis. C’est la raison pour laquelle les
Accroche
CanadaType de contenu
BlogsDate de publication
01/05/2022
Récapitulatif
Les avantages d’un milieu de travail diversifié et inclusif sont innombrables. En établissant une culture d’inclusion, l’engagement est plus élevé, car les collègues sont plus heureux, plus détend
Accroche
CanadaType de contenu
BlogsDate de publication
11/19/2021
Récapitulatif
Il est largement reconnu que le monde traverse une crise climatique et que nous devons agir rapidement pour prévenir d’autres dommages. Le Canada est l’un des 197 pays à avoir signé l’Accord de Paris
Accroche
EuropeType de contenu
BlogsDate de publication
10/10/2019
Récapitulatif
Rencontrez Dhara Sudani, gestionnaire de projet dans l’équipe Ingénierie des infrastructures au bureau de SNC-Lavalin à Toronto. Derrière la façade de la gestionnaire discrète et efficace
Accroche
CanadaType de contenu
BlogsDate de publication
08/16/2019
Récapitulatif
Jonathan Gouin a débuté sa carrière en finances. Il a également consacré de nombreuses heures à divers projets de rénovation avec sa famille et ses amis, acquérant de nouvelles compétences
Accroche
CanadaType de contenu
BlogsDate de publication
08/15/2019
Récapitulatif
Au travail comme dans la vie, Chris Johnson explore de nouvelles frontières. L’occasion d’influencer une discipline d’ingénierie émergente, jumelée à l’objectif important de protéger l
Explorez les possibilités et voyez comment vous pouvez changer le monde en faisant ce que vous aimez chez AtkinsRéalis
Apprenez-en plus