Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Datawarehouse Architect @ ICICI Bank

Home > DBA / Data warehousing

 Datawarehouse Architect

Job Description

About the role

As a Data Warehouse Architect, you will be responsible for managing and enhancing data warehouse that manages large volume of customer-life cycle data flowing in from various applications within guardrails of risk and compliance.You will be managing the day-to-day operations of data warehouse i.e. Vertica. In this role responsibility, you will manage a team of data warehouse engineers to develop data modelling, designing ETL data pipeline, issue management, upgrades, performance fine-tuning, migration, governance and security framework of the data warehouse. This role enables the Bank to maintain huge data sets in a structured manner that is amenable for data intelligence. The data warehouse supports numerous information systems used by various business groups to derive insights.As a natural progression, the data warehouses will be gradually migrated to Data Lake enabling better analytical advantage. The role holder will also be responsible for guiding the team towards this migration.

Key Responsibilities
Data Pipeline Design

Responsible for designing and developing ETL data pipelines that can help in organising large volumes of data. Use of data warehousing technologies to ensure that the data warehouse is efficient, scalable, and secure.

Issue Management

Responsible for ensuring that the data warehouse is running smoothly. Monitor system performance, diagnose and troubleshoot issues,and make necessary changes to optimize system performance.

Collaboration

Collaborate with cross-functional teams to implement upgrades, migrations and continuous improvements.

Data Integration and Processing

Responsible for processing, cleaning, and integrating large data sets from various sources to ensure that the data is accurate, complete, and consistent.

Data Modelling

Responsible for designing and implementing data modelling solutions to ensure that the organizations data is properly structured and organized for analysis.

Key Qualifications & Skills
Educational Qualification

B.E./B. Tech. in Computer Science, Information Technology or equivalent domain with 6 to 10 years of experience and at least 5 years or relevant work experience in Datawarehouse/mining/BI/MIS.

Experience in Data Warehousing

Knowledge on ETL and data technologies and outline future vision in OLTP, OLAP (Oracle / MSSQL). Data Modelling, Data Analysis and Visualization experience (Analytical tools experience like Power BI / SAS / ClickView / Tableu etc). Good to have exposure to Azure Cloud Data platform services like COSMOS, Azure Data Lake, Azure Synapse, and Azure Data factory.

Synergize with the Team

Regular interaction with business/product/functional teams to create mobility solutions.

Certification

Azure certified DP 900, PL 300, DP 203 or any other Data platform/Data Analyst certifications..

Communication skills

Good oral and written communication skills.

Job Classification

Industry: Banking
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Data warehouse Architect / Consultant
Employement Type: Full time

Contact Details:

Company: ICICI Bank
Location(s): Mumbai

+ View Contactajax loader


Keyskills:   Data Warehousing Data Modelling Power BI SAS Data Analysis OLAP OLTP Oracle MSSQL

 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Data Architect

  • Facctum
  • 10 - 15 years
  • Bengaluru
  • 1 day ago
₹ Not Disclosed

AEP Data Architect

  • Railscarma
  • 3 - 4 years
  • Mumbai
  • 1 day ago
₹ Not Disclosed

Data Architect

  • CGI
  • 10 - 15 years
  • Hyderabad
  • 1 day ago
₹ 11-21 Lacs P.A.

Data Architect

  • BNP Paribas
  • 7 - 12 years
  • Mumbai
  • 1 day ago
₹ Not Disclosed

ICICI Bank

ICICI Bank Ltd ICICI Bank Ltd