DWH Architect

Job description

Mission

Strong working experience as a Data Architect
Experience on Data Modeling, Schema Design, ETL Design, Informatica, BO, Data lake
In-depth understanding of database and Data Warehouse structure principles
10+ years of experience in Data analytics
Experience to Work with ETL tools to import data into Snowflake, Create simple BI reports
Experience on ETL + DWH Hand on Architect role.
Nice to have experience on cloud databases like Redshift, SQL Server Azure, EMR/Athena and new ETL tools like Matillion
Experience gathering and analyzing system requirements
Develop database solutions to store and retrieve information
Analyze structural requirements for new software and applications

Migrate data from legacy systems to new solutions

Design conceptual and logical data models and flowcharts

Expertise in SQL and Oracle.

Establish best practices on database designs / SQL across the organization.

Experience in Toad Data Modeler/SAP Power Designer.

Experience with DWH Technologies like Informatica/SSIS.

Improve system performance by conducting tests, troubleshooting and integrating new elements

Optimize new and current database systems

Define security and backup procedures

Coordinate with the Data Science department to identify future needs and requirements

Knowledge of data mining and segmentation techniques

Familiarity with familiar with predictive analysis and data visualization techniques and tools (e.g. Tableau, D3.js and R)

Familiarity with Big Data Technologies complementary with DWH Technologies

Proven analytical skills

Problem-solving attitude

All our positions are open to people with disabilities

Profile

Strong working experience as a Data Architect
Experience on Data Modeling, Schema Design, ETL Design, Informatica, BO, Data lake
In-depth understanding of database and Data Warehouse structure principles
10+ years of experience in Data analytics
Experience to Work with ETL tools to import data into Snowflake, Create simple BI reports
Experience on ETL + DWH Hand on Architect role.
Nice to have experience on cloud databases like Redshift, SQL Server Azure, EMR/Athena and new ETL tools like Matillion
Experience gathering and analyzing system requirements
Develop database solutions to store and retrieve information
Analyze structural requirements for new software and applications

Migrate data from legacy systems to new solutions

Design conceptual and logical data models and flowcharts

Expertise in SQL and Oracle.

Establish best practices on database designs / SQL across the organization.

Experience in Toad Data Modeler/SAP Power Designer.

Experience with DWH Technologies like Informatica/SSIS.

Improve system performance by conducting tests, troubleshooting and integrating new elements

Optimize new and current database systems

Define security and backup procedures

Coordinate with the Data Science department to identify future needs and requirements

Knowledge of data mining and segmentation techniques

Familiarity with familiar with predictive analysis and data visualization techniques and tools (e.g. Tableau, D3.js and R)

Familiarity with Big Data Technologies complementary with DWH Technologies

Proven analytical skills

Problem-solving attitude

Environment

Societe Generale Global Solution Centre (SG GSC), a 100% owned subsidiary of European banking major Societe Generale (SG), Our role and purpose is to enable the strategic vision of Societe Generale Group. We are doing this by pioneering cutting edge innovation from Design Thinking to Smart Automation & Artificial Intelligence, and applying it to banking.

SG Global Solution Centre provides services in the areas of Application Development and Maintenance, Infrastructure Management, Business Process Management, and Knowledge Process Management, to Societe Generale's business lines around the world.

“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”.

Job code: 19000IZ0
Business unit: SG Global Solution Centre
Starting date: Immediate
Date of publication: 12/07/2019

Apply

Share on

DWH Architect

Permanent contract | Bangalore - India | Information Technology

Apply

·  Home Job Offers DWH Architect

Discover
·  All our job offers
·  Advice to candidates
·  Group Société Générale website

Useful links
·  Contact form
·  FAQ
·  Profiles wanted

Legal information
·  Legal information
·  Privacy policy
·  Cookie policy

Follow Us :

· 
· 
· 
· 
· 

Recruitment - Société Générale
website: careers.societegenerale.com