Data Modeller (Mumbai)

Data Modeller (Mumbai)

17 Nov
|
CGI
|
Mumbai

17 Nov

CGI

Mumbai

Role & responsibilities

Preferred candidate profile

Data Design: Build and maintain conceptual (high level business concepts), logical (attributes and relationships), and physical (database specific schemas) models.

. Design and implement database schemas, tables, views, indexes, and other structures that align with application requirements.

. Design, develop, and maintain Python applications, services, and automation scripts that work alongside the PL/SQL layer (e.g., data processing, batch jobs, and API based integrations).

. Design, develop, and maintain complex PL/SQL packages, procedures, functions, triggers, and views to support data driven applications.

. Build and consume REST APIs (FastAPI / Flask) that expose CRM data and services to the 60+ connected systems, with proper validation, error handling, and versioning.

. Develop Oracle connected Python components using python oracledb / SQLAlchemy, with connection pooling, bulk operations (executemany), ref cursors, and calls to PL/SQL packages.

. Build batch and data pipelines in Python (Pandas / Polars) for transformation, reconciliation, and data quality checks, scheduled through Control M or Airflow (NTH).

. Apply secure coding practices in Python: secrets management,



OAuth2 / JWT based service authentication, input validation, and dependency vulnerability scanning.

. Implement structured logging, error handling, and monitoring for Python services and jobs to support production operations and L3 support.

. Write, optimize, and troubleshoot advanced SQL queries to ensure efficient data processing and retrieval.

. Performance Optimization: Tune database performance using indexing, partitioning, and productive normalization or dimensional techniques

. Define and enforce data integrity and quality standards within the database design.

. Design, implement, and maintain ETL processes to integrate data from multiple sources, using PL/SQL and Python to transform and validate data (NTH).

. Create Python based API led services under the strangler pattern, in line with the target architecture.

. Ensure data consistency, accuracy, and completeness across different systems and processes.

. Support large scale data migrations and database transformations.

. Act as a technical point of contact for complex database issues, offering solutions and recommendations to resolve them.

📌 Data Modeller (Mumbai)
🏢 CGI
📍 Mumbai

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: data modeller (mumbai) / mumbai

Subscribe to this job alert:

Get the latest job offers by email for: data modeller (mumbai) / mumbai