Senior Data Scientist - Data Science and Analytics (Mysuru)

Senior Data Scientist - Data Science and Analytics (Mysuru)

17 Nov
|
HDFC Life
|
Mysuru

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

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior data scientist - data science and analytics (mysuru) / mysuru