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