Role & responsibilities

- Data Modeling and Design:
- Design and develop efficient data marts using PostgreSQL, adhering to best practices in data warehousing and dimensional modeling.
- Translate business requirements into effective data models and structures.
- Create and maintain metadata documentation for data marts.
- Data Extraction, Transformation, and Loading (ETL):
- Develop and maintain productive ETL processes using PostgreSQL, PL/SQL, or other relevant tools.
- Extract data from various sources (databases, flat files, APIs) and transform it into a suitable format for analysis.
- Load data into data marts efficiently and reliably.
- Data Quality Assurance:
- Implement and monitor data quality checks and validation rules to ensure data accuracy and integrity.
- Performance Tuning:

Optimize data mart performance through indexing, partitioning, and other techniques.

Preferred candidate profile

Min 3 years on SQL / Postgres SQL (preferred), Data Warehouse, Data Mart Design, DB development & maintenance

Immediate availability is preferred

Perks and benefits

📌 Manager/ Sr Manager - Postgres SQL Developer, Analytics (Chennai)
🏢 Galaxy Health Insurance
📍 Chennai