Description

You will design, develop, and optimize data models, pipelines, and database objects for enterprise data warehousing.

This role is on-site.

Responsibilities

• Design, develop, and optimize PL/SQL procedures, functions, triggers, and packages.
• Write efficient SQL queries, joins, and subqueries for data retrieval across RDBMS.
• Develop and maintain database objects including tables, views, indexes, and sequences.
• Build ETL processes and scripts for data migration and integration.
• Participate in key business, architectural, and technical decisions.

Required Skills

• 5+ years of professional experience in data architecture or modeling.
• Strong programming experience in Python and PySpark.
• Expertise with SQL and analytical functions on RDBMS.
• Hands-on experience with data modeling tools like Erwin or ER Studio.
• Experience with data warehousing concepts (Star schema, Snowflake, Data Vault).
• Proficiency in handling file formats: JSON, Parquet, AVRO, ORC, and XML.
• Familiarity with CI/CD implementation and Build Management strategies.
• Knowledge of enterprise databases such as DB2, Oracle, PostgreSQL, or MySQL.
• Experience working in Agile environments (Scrum, Kanban, Jira).

Key Skills

Education

Any Graduate