Description

Design and maintain relational, dimensional, and analytic data models. Manage data ingestion protocols and ETL processes. Build and maintain infrastructure for data warehouses, data lakes, and enterprise big data platforms. Perform performance tuning and PL/SQL optimization. Execute QA testing and create technical diagrams for data architecture.

Responsibilities

• Design and maintain relational, dimensional, and analytic data models.
• Manage data ingestion protocols and ETL processes.
• Build and maintain infrastructure for data warehouses, data lakes, and enterprise big data platforms.
• Perform performance tuning and PL/SQL optimization.
• Execute QA testing and create technical diagrams for data architecture.

Required Skills

• 5+ years of experience in data modeling and architecture.
• Hands-on experience with RDBMS, dimensional modeling, and ETL.
• Proficiency in Python and AWS.
• Strong knowledge of Oracle and PostgreSQL.
• Expertise in PL/SQL and performance tuning.
• Experience with metadata management and data warehousing concepts.
• Proficiency with modeling tools such as Erwin or ER Studio.
• Experience working in multi-data-center contexts.

Preferred Skills

• Ability to handle diagramming and infrastructure design.

Key Skills

Education

Any Graduate