Job Description

Data Architect/Data Modeler Role-(8-12yrs)

- Data Modeling, Enterprise Data Warehouses(Structured and Unstructured data) , Relational Databases, ETL , Big Data, Cloud platforms.

- Experienced in multiple domains like Financial domain (Royal Bank Of Scotland, NatWest), US Healthcare(United Health Group).

- Hands-on experience in end to end life cycle of Enterprise Data Warehouse implementation.

- Exposure in BigData/ Hadoop Ecosystem.

- Having US B1 US visa till 2027. (6 months of experience of On-Site in Chicago (US) with RBSI)

- Experience of database design, development, deployment and Performance.

- Good understanding of structured and unstructured data.

- Experience in a globally distributed team and large scale databases.

- Worked on Agile Methodology and Scrum Methodology of software development.

- Data Modeling with Erwin tool for Finance/Healthcare Domain.

- Data Modeling for OLTP/OLAP systems.

- Data Modeling for End to End project for Data Streaming platform (Kafka) with Canonical modeling and for Enterprise Data Warehouse (Snowflake) with Data Vault 2.0 Modeling (Creation of EDWH using dbtvault).

- Data Modeling for Relational systems with Relational modeling (3 NF).

- Data Modeling for Enterprise Data Warehouse using Dimensional Modeling.

- Worked on Big Data technology like Map Reduce, Sqoop , Hive , Spark with Scala , Kafka.

- Good understanding of AWS/Azure Data Services.

- Worked on Big Data on top of AWS.

- Worked on Migration of Oracle Enterprise Data Warehouse to AWS.

- Lead end to end Oracle database (OLTP and OLAP databases) migration from physical infra to cloud (IAAS).

- Experience on database migration from on-premise database to PCF Cloud (Pivotal Cloud Foundry) (IAAS).

- Worked on ODS(Operation Data Store)/Result-Store/History-Store Database.

- Worked on Oracle database projects end to end with all concepts of Oracle architecture with PLSQL.

- Lead end to end Autosys batch Migration from physical infra to cloud (IAAS).

- Good in understanding Business logic and work well as a part of a team and as an individual.

- Excellent communication and interpersonal skills.

- Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, QA, testing, implementation and maintenance with timely delivery against aggressive deadlines.

- Experience to convert monolithic Oracle database into micro-service architecture database.

- Experience to implement ACTIFIO as a database virtualization as part of cost saving (DELHIX).

- Experience of end to end Change request deployment from Dev, SIT, BAAT, UAT, Performance to Production (Performed both role Release Manager and Release Implementer role.).

- Explored queue solution as a RabbitMQ , Kafka, IBM MQ as a replacement of ORACLE AQ.

IIM Jobs