Data Modeler (Oracle Database/Data Warehouse) (to work in W2 only)

Raag Solutions; Plano, Jersey City (TX, NJ); On-site; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Data Modeler with expertise in Oracle databases. This pivotal role involves creating and optimizing data models, ensuring efficient database performance, and collaborating with a distributed team. The ideal candidate will possess strong analytical skills and a deep understanding of data modeling concepts such as normalization and star schema. Join a dynamic environment where your contributions will shape data strategies and drive impactful solutions. If you thrive in a collaborative setting and are eager to tackle complex data challenges, this opportunity is perfect for you.

Qualifications

• Proven experience in data modeling for Oracle databases.
• Strong understanding of normalization and denormalization concepts.

Responsibilities

• Develop and modify database tables, views, and stored procedures.
• Perform performance tuning and explain plan analysis.

Skills

Data Modeling

PL/SQL

SQL

Performance Tuning

Analytical Skills

Problem-Solving Skills

Communication Skills

Collaboration Skills

Tools

Informatica ETL

Job description

TO WORK IN W2 ONLY

• Proven experience in data modeling for Oracle databases and data warehouses.
• Strong understanding of data modeling concepts, including normalization, denormalization, star schema, and snowflake schema.
• Proficiency in PL/SQL and SQL for Oracle databases.
• Experience with performance tuning and explain plan analysis.
• Ability to develop and modify database tables, views, indexes, and stored procedures.
• Excellent communication and collaboration skills.
• Ability to work independently and as part of a distributed team.
• Strong analytical and problem-solving skills.

Preferred Qualifications:

• Experience with Informatica ETL tools.
• Familiarity with Agile methodologies.
• Relevant certifications in data modeling or Oracle database management.