17 Nov
|
HDFC Life
|
Mysuru
What are we looking for?
A seasoned Enterprise Data Warehouse (EDW) Developer with deep expertise in Oracle and strong hands-on experience in designing, modeling, and managing large-scale data environments. The ideal hire should also possess advanced knowledge of Google Cloud Platform (GCP), particularly BigQuery-based data modeling. We are looking for someone who can translate complex business requirements into scalable, high‑performance data architectures across on‑prem and cloud platforms.
What does the job entail?
- Designing relational, dimensional (Star/Snowflake), and Data Vault data models for enterprise analytics.
- Building and maintaining robust ETL/ELT pipelines using ODI, Informatica, PL/SQL, and other tools.
- Optimizing Oracle databases through indexing, partitioning, materialized views, and SQL/PLSQL tuning.
- Ensuring data quality, lineage, governance, and troubleshooting across multi-terabyte data environments.
- Collaborating with BA, BI, and Data Science teams to deliver structured, analysis-ready datasets.
- Monitoring warehouse load jobs and assisting DBAs with upgrades and migrations.
- Designing conceptual, logical, and physical data models on GCP using BigQuery (nested fields, partitioning, clustering).
- Modernizing legacy on-premise data models into cloud-native architectures such as Data Mesh or Data Vault 2.0.
- Managing BigQuery performance and cost through slot optimization and storage tuning.
- Implementing metadata standards, Dataplex tagging, IAM-based security, and documentation
Work Experience
5 to 8 years of experience in data warehousing, business intelligence, and enterprise-scale data modeling. Strong background in handling multi-terabyte databases, identifying performance bottlenecks, and resolving data anomalies. Experience working cross-functionally with business, analytics, and technology teams.
Essential Qualification
- Expert-level proficiency in:
- Oracle Database (19c/21c/23c) and Oracle Exadata.
- Oracle SQL and advanced PL/SQL (bulk collects, analytic functions, collections).
- ETL tools like Oracle Data Integrator (ODI), Oracle GoldenGate, or Informatica PowerCenter.
- Version control and DevOps: Git, CI/CD pipelines.
- Strong knowledge of Oracle Cloud Infrastructure (OCI), Autonomous Data Warehouse, or hybrid cloud setups.
- Proven ability to design high-performance data models and optimize enterprise data warehouse environments.
Preferred Skills
- Deep expertise in GCP Data Stack, including:
- BigQuery, Dataplex, Cloud Storage
- Cloud Composer (Apache Airflow)
- Experience with:
- Data Mesh, Data Vault 2.0 architectures.
- Migrating on‑prem data warehouses to cloud-native solutions.
- Implementing column-level and row-level security on GCP.
- Enterprise documentation such as data dictionaries, lineage maps, and modeling guidelines.
- Excellent communication skills to explain technical concepts to non-technical stakeholders.
- Robust analytical and problem‑solving ability for debugging complex data and performance issues.
📌 Senior Data Scientist - Data Science and Analytics (Mysuru)
🏢 HDFC Life
📍 Mysuru