We are looking for a resourceful Data Modeler - OLAP/OLTP to join our awesome team at Huquo in Pune.
Growing your career as a Full Time Data Modeler - OLAP/OLTP is an amazing opportunity to develop useful skills.
If you are strong in creativity, leadership and have the right mindset for the job, then apply for the position of Data Modeler - OLAP/OLTP at Huquo today!

Role and responsibilities : - Perform as Data design/modeling lead to support the system designing and construction in data layer and application systems.- Understand the current database system with business operation demands and technical capability.- Develop data models and related designs, from the data architecture concept, logical, to physical data models for application database.- Providing expertise in data modeling tools and techniques for designing data models for applications and related systems.- Assure that the modeling complies with the data modeling standards (normalization, data validation) - Working closely with business stakeholders, as well as potential users of the information system to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.- Ensure compliance with technical processes and standards.- Identify, communicate, and mitigate Risks, Assumptions, Issues, and Decisions throughout the full lifecycle.- Must have a strong understanding of Data modeling principles (3nf/dimensional), methods and techniques.- 8 years data modeling experience preferably in Pharma or life sciences industry, ERStudio or similar experience. Experience with Data Governance tools,



enterprise data management solutions, Modeling best practices, and MDM.- Positive knowledge on data profiling, integrating, and modeling data from different source systems.- Experience in translating/mapping relational data models into XML and Schemas- Should have hands-on experience in relational, dimensional, and analytic data modeling using RDBMS, dimensional, SQL, PL/SQL, NoSQL data platform technologies, and ETL and data ingestion protocols.- Should have strong knowledge in creating the data model for OLAP and OLTP systems.- Strong knowledge of Database Architecture, normalization concepts, and NFR requirements- Good Hands-on expertise in data modeling tools (e.g. Power Designer, Erwin, ER/Studio)- Hands-on expertise in creating Conceptual, Logical Data models and Physical data models Using ERWIN/ER Studio.- Experience with data warehouse, Data Lake, and enterprise big data platforms.- Experience on RDBMS platforms (e.g. Redshift, SQL Server, Oracle, Teradata, Snowflake, Postgres)- Must have hands-on experience on implementing data models on AWS Redshift along with other AWS cloud solutions services including S3, Glacier, RDS, Athena, DynamoDB etc.- Experience working with extracting business rules to develop transformations, data lineage, metadata, and data catalogue.Nice-to-have skills : - Azure Cloud certification- Unix or Shell scripting- Strong delivery background across the delivery of high-value, business-facing technical projects in major organizations (ref:hirist.com)

Benefits of working as a Data Modeler - OLAP/OLTP in Pune:

● Learning opportunities
● Company offers career progression opportunities
● Attractive package

📌 Data Modeler - OLAP/OLTP - with Growth Opportunities (Pune)
🏢 Recognized
📍 Pune