Data Modeller

Fractal; Bengaluru; On-site; INR 3,500,000 - 4,500,000; Full time

Job summary

Fractal currently seeks a Data Architect to design and optimize data models across Dimensional, NoSQL, and Graph paradigms. You will lead business discussions, map requirements to scalable data models, and ensure integration with ETL pipelines and BI needs.

Ideal candidates have 3+ years in large-scale data architectures, strong Oracle SQL/PLSQL or Cypher, and hands-on experience with ERWIN, Databricks Spark, and AWS cloud services. Bengaluru-based position with growth opportunities.

Qualifications

• Bachelor's degree in Computer Science, Engineering or related field.
• 3+ years in Data and Solution Architecture for large-scale enterprise solutions.
• Experience with Dimensional/NoSQL/Graph modeling and VLDB environments.
• Experience with Oracle SQL, PL/SQL or Cypher.
• Exposure to AWS services (VPC/EC2/S3/Glue/DMS).

Responsibilities

• Participate in requirements analysis and design of data models (Dimensional/NoSQL/Graph).
• Lead data discovery sessions and map requirements to models.
• Review data models with project teams and maintain metadata documentation.
• Collaborate with ETL/Data Eng teams to build ingestion pipelines.
• Ensure designs meet BI end-user needs and improve existing systems.

Skills

Data modeling

VLDB Data Warehouse

Graph DB

ERWIN

Oracle SQL/PLSQL

Databricks Spark

AWS Cloud

JAD discussions

Data analysis

Communication skills

Education

Bachelor's degree in CS/Engineering/IS

AWS Solutions Architect Professional

3+ years in Big Data / Data Architecture

Tools

ERWIN

Databricks

Informatica ETL

Job description

It's fun to work in a company where people truly BELIEVE in what they are doing!

We're committed to bringing passion and customer focus to the business.

Responsibilities

• Participate in requirements definition, analysis, and the design of logical and physical data models for Dimensional Data Model, NoSQL, or Graph Data Model.
• Lead data discovery discussions with Business in JAD sessions and map the business requirements to logical and physical data modeling solutions.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Ensure database designs efficiently support BI and end user requirements.
• Drive continual improvement and enhancement of existing systems.
• Collaborate with ETL/Data Engineering teams to create data process pipelines for data ingestion and transformation.
• Collaborate with Data Architects for data model management, documentation, and version control.
• Maintain expertise and proficiency in the various application areas.
• Maintain current knowledge of industry trends and standards.

Required Skills

• Strong data analysis and data profiling skills.
• Strong conceptual, logical, and physical data modeling for VLDB Data Warehouse and Graph DB.
• Hands-on experience with modeling tools such as ERWIN or another industry-standard tool.
• Fluent in both normalized and dimensional model disciplines and techniques.
• Minimum of 3 years' experience in Oracle Database.
• Hands-on experience with Oracle SQL, PL/SQL, or Cypher.
• Exposure to Databricks Spark, Delta Technologies, Informatica ETL, or other industry-leading tools.
• Good knowledge or experience with AWS Redshift and Graph DB design and management.
• Working knowledge of AWS Cloud technologies, mainly on the services of VPC, EC2, S3, DMS, and Glue.
• Bachelor's degree in Software Engineering, Computer Science, or Information Systems (or equivalent experience).
• Excellent verbal and written communication skills, including the ability to describe complex technical concepts in relatable terms.
• Ability to manage and prioritize multiple workstreams with confidence in making decisions about prioritization.
• Data-driven mentality. Self-motivated, responsible, conscientious, and detail-oriented.
• Effective oral and written communication skills.
• Ability to learn and maintain knowledge of multiple application areas.
• Understanding of industry best practices pertaining to Quality Assurance concepts and procedures.

Education/Experience Level

• Bachelor's degree in Computer Science, Engineering, or relevant fields with 3+ years of experience as a Data and Solution Architect supporting Enterprise Data and Integration Applications or a similar role for large-scale enterprise solutions.
• 3+ years of experience in Big Data Infrastructure and tuning experience in Lakehouse Data Ecosystem, including Data Lake, Data Warehouses, and Graph DB.
• AWS Solutions Architect Professional Level certifications.
• Extensive experience in data analysis on critical enterprise systems like SAP, E1, Mainframe ERP, SFDC, Adobe Platform, and eCommerce systems.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

Hiring Related Queries

India: [e-mail]

Outside India: [e-mail]