last login:
25 Jan 2023

06/12 Abhishek Dhuria
Manager - TA at CaptiveAide Advisory Pvt Ltd Posted in
IT & Systems Jobs

06 Dec 2022; Job Code: 1189907; Location: Bangalore/Chennai

Views:76 Applications:10 Rec. Actions:Recruiter Actions:5

CaptiveAide Advisory - Senior Manager - Data Modelling (12-15 yrs)

Bangalore/Chennai Job Code: 1189907

Must have:

- 10+ years of strong Data Analysis and Data Profiling skills

- 6+ years of strong Conceptual, Logical and Physical data modelling

- Have strong experience in data modelling, big data or data profiling tools

- Strong Experience in Data Analysis, Data Modelling and Data Profiling using ERWIN or another industry standard tool for databases like Oracle, Teradata, AWS type databases

- Worked in Mortgage and Wealth domain data modelling projects

- Experience in modelling Datawarehouse and Data Lake environments

- Hands on experience with SQL (HQL, Spark SQL, Sybase, Oracle) and PL/SQL

- Data-driven mentality. Self-motivated, responsible, conscientious, and detail oriented

Good to have:

- Exposure to ETL tools (Informatica, Teradata, Ab Initio) and Spark (Python or Scala) or other industry leading tools

- Good knowledge or experience with Snowflake, Other Cloud base Datawarehouse design and management

- Exposure to AWS, OpenShift, Snowflake would be added advantage

- Experience on project management framework Agile (Jira toolset)

- Experience in Ontology based data modelling

Job Role:

- Should work with the client SMEs, business users and onsite data modeller to gather the requirements and build an Ontology model

- Do the data exploration and identify the data elements and do the data mapping to the Ontology model

- Work with the development team (data engineers and AIML engineers) for building the data pipelines and preparing analytical reports

- Preparing data catalog and taxonomy

- Effective contribution for building the enterprise architecture