Skip to main content

Data Modeler & Python

Technology
CGI
Mumbai City, IndiaTodayUntil 16/12/2026
Full timeOn-site

Job description

Position Description

Company Profile

At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed.

We have the global resources, expertise, stability and dedicated professionals needed to achieve. At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries.

Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us.

Learn more at www.cgi.com.

This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development.

Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please.

Direct Responsibilities

  • 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 efficient 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.
  • Project Coordination and Stakeholder Collaboration
Collaborate with project managers, business analysts, and stakeholders to understand business requirements and translate them into technical solutions. Communicate project status, timelines, and potential risks to stakeholders, ensuring alignment with project goals.
  • Quality Assurance and Testing
Develop and oversee testing strategies for PL/SQL and Python code (e.g., unit tests with utPLSQL and pytest), ensuring high quality, performance, and compliance with business requirements. Collaborate with QA teams to validate data quality, ensure accuracy, and troubleshoot issues identified during testing.

Define and document acceptance criteria for database functions and processes.

  • Documentation and Standards
Create and maintain comprehensive documentation for database designs, PL/SQL and Python code, and data flow processes. Ensure adherence to data governance and regulatory requirements, including security and compliance standards.

Maintain version control and change management processes to ensure data integrity and consistency.

Participate in code reviews and follow CI/CD practices to ensure high quality deliverables.

Contributing Responsibilities

  • Good knowledge of logical and physical Data Modeling using normalizing techniques.
  • Oracle PL/SQL programming experience, SQL experience – at least 5 years.
  • Python programming experience (Pandas, NumPy, cx_Oracle / python oracledb or SQLAlchemy) – at least 3 years.
  • Write clean, maintainable, and well tested Python following PEP 8, type hints, and code quality tooling (flake8 / pylint, black, SonarQube).
  • Proficiency in business analysis tools (e.g., JIRA).
  • Deliver simple & medium work on time, with optimum utilization of time; implemented solution is performant, robust, efficient, pragmatic (design & implementation).
  • Experience in manipulating and analyzing data from varying sources.
  • All new components and/or changes to existing components are well documented.
  • Results oriented, team player and self motivated with a strong initiative to deliver.
  • Excellent communication and listening skills; attention to detail is a must.
Technical &
  • Behavioral Competencies
  • Data Modeler (at least 3 years) Strong command of SQL, Relational Database Management Systems (RDBMS like Oracle, MySQL, SQL Server)
  • Oracle PL/SQL (at least 5 years)
  • Python (at least 3 years), with the following technical depth:
Core Python: OOP, decorators, generators, context managers, exception handling, type hints, virtual environments and dependency management (pip / poetry) Concurrency and performance: asyncio, multithreading / multiprocessing, profiling and memory efficient processing of large datasets

Data libraries: Pandas, NumPy, Polars (NTH), PySpark (NTH)

Frameworks and APIs: FastAPI / Flask / Django REST, Pydantic, OpenAPI / Swagger, SOAP / REST integration, JSON / XML parsing

Database connectivity: python oracledb (cx_Oracle), SQLAlchemy, connection pooling, bulk DML, transaction handling, calling PL/SQL from Python

Messaging and integration: Kafka / IBM MQ / RabbitMQ client exposure (NTH)

Testing: pytest, unittest, mocking, test data management, coverage reporting

DevOps and tooling: Git, Jenkins / Azure DevOps CI/CD, Docker, Linux shell scripting

Orchestration and observability: Airflow / Control M, logging frameworks, monitoring and alerting (NTH)

  • Data Blending, High volume, and Multidimensional Data Processing
  • Experience in manipulating and analyzing simple and medium, high volume, high dimensionality data from varying sources
  • Query optimization and performance enhancements
  • Team Player, Self motivated, and Quick Learner
  • Good analytical skills and attention to detail
  • Independent and strong sense of ownership

Experience Level: 7+ years Skills Referential (Required Knowledge, Skills And Abilities)

Transversal Skills

  • Active Listening
  • Client Focused
  • Ability to deliver / Result driven

Behavioral Skills
  • Analytical Thinking &
    • Structured Problem Solving
    • Ownership &
    • Accountability under Governance Gates
    • Stakeholder Management &
    • Clear Communication
    • Attention to Detail in Compliance Sensitive Work
Your future duties and responsibilities Required Qualifications To Be Successful In This Role

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

Come join our team—one of the largest IT and business consulting services firms in the world.

Keywords
Data ModelingOracle PL/SQLPythonSQLRelational Database ManagementDatabase Performance OptimizationETLREST APIsPandasNumPySQLAlchemyFastAPIFlaskData QualitypytestAirflowOracleRDBMSMySQLSQL Server

Interested in this role?