Data Warehouse Architect

Essential Services: Role & Location fungibility

At ICICI Bank, we believe in serving our customers beyond our role definition, product boundaries, and domain limitations through our philosophy of customer 360-degree. In essence, this captures our belief in serving the entire banking needs of our customers as One Bank, One Team. To achieve this, employees at ICICI Bank are expected to be role and location-fungible with the understanding that Banking is an essential service. The role description gives you an overview of the responsibilities; it is only directional and guiding in nature.

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 the data warehouse i.e. Vertica. In this role, you will manage a team of data warehouse engineers to develop data modelling, design ETL data pipeline, manage the issues and upgrades, fine-tune performance, migrate, govern and maintain 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 warehouse 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 organization’s data is properly structured and organized for analysis.

Key Qualifications & Skills:

• Education Qualification:

  B.E./B. Tech. in Computer Science, Information Technology or equivalent domain with 10 to 12 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 like OLTP, OLAP (Oracle / MSSQL). Data Modelling, Data Analysis and Visualization experience (Analytical tools experience like Power BI / SAS / ClickView / Tableau etc.). Good to have exposure to Azure Cloud Data platform services like COSMOS, Azure Data Lake, Azure Synapse, and Azure Data factory.

• Certification:

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

About the Business Group:

The Technology Group at ICICI Bank is at the forefront of our operations and offerings, which is focused on leveraging state-of-the-art technology to provide customer-centric solutions. This group plays a pivotal role in our vision of the transition from Bank to Bank Tech. Further, the group offers round-the-clock support to our entire banking ecosystem. In our persistent efforts to offer products and solutions that truly benefit customers, we believe unlocking the potential of technology in every single engagement would go a long way in creating customer delight. In this endeavour, we also tirelessly ensure all our processes, systems, and infrastructure are very well within the guardrails of data security, privacy, and relevant regulations.