Data Modeler Lead

Job Description

Role Purpose

The purpose of this role is to interpret data and turn into information (reports, dashboards, interactive visualizations etc) which can offer ways to improve a business, thus affecting business decisions.

J͏ob Description:-

Design and maintain conceptual, logical, and physical data models.

• Analyze business requirements and translate them into effective database designs.

• Develop and enforce data modeling standards, naming conventions, and best practices.

• Create Entity Relationship Diagrams (ERDs) and database documentation.

• Perform data normalization and denormalization based on business and performance requirements.

• Collaborate with data architects and business analysts to define data structures and relationships

• Develop, test, and optimize complex SQL queries, stored procedures, views, functions, and triggers.

• Troubleshoot and resolve database performance issues.

• Perform query tuning, indexing strategies, and database optimization.

• Ensure data quality, consistency, and accuracy across systems.

• Support reporting, analytics, and business intelligence initiatives.

• Monitor database performance and storage utilization.

• Assist with database migrations, upgrades, and deployments.

• Implement backup, recovery, and security procedures.

• Support Agile/Scrum development processes.

• Experience with database platforms:

o   Oracle and SQL Server

• Data Modelling tools:

o  ERwin Data Modeler,  ER/Studio,  Oracle SQL Developer Data Modeler and PowerDesigner

͏

Deliver

NoPerformance ParameterMeasure1.Analyses data sets and provide relevant information to the clientNo. Of automation done, On-Time Delivery, CSAT score, Zero customer escalation, data accuracy͏ ͏

Mandatory Skills: Toad Data Modeler

.

Experience: 5-8 Years

.

Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.