SQL Data Engineer (Oracle, C#, PL/SQL & SQL Loader)

Cognizant

Toronto, Ottawa

Hybrid

CAD 142,000 - 178,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical Insurance
ESPP
EAP
PTO
Parental Leave
Learning & Development
Wellness Resources
Career Growth

Job summary

Cognizant is seeking an AI-Aware Data Engineer to design, develop, and optimize enterprise data solutions for analytics, reporting, and AI-ready initiatives. You will work with Oracle, PostgreSQL, Azure Data Factory, SSIS, and C# to deliver scalable data platforms for Life & Annuities business processes.

You will design data models, build pipelines, implement governance, and prepare AI-ready datasets while collaborating with architects, developers, and stakeholders in a hybrid work environment.

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering or related field.
  • 8-12 years of experience designing, developing, and supporting enterprise data solutions.
  • Strong Oracle database development, PL/SQL, and performance tuning expertise.
  • Advanced Azure Data Factory experience including pipelines and parameterization.
  • Solid SSIS experience and enterprise ETL workflows.
  • PostgreSQL administration, tuning, and query optimization.
  • Proficient in C# development of data-centric services and APIs.
  • Understanding of data governance, security, and compliance.
  • Experience with cloud/hybrid data environments.
  • Excellent English communication skills.

Responsibilities

  • Design and implement efficient data models and integration patterns across Oracle and PostgreSQL.
  • Develop C# data services and APIs interacting with relational databases and data platforms.
  • Build and optimize scalable data pipelines using Azure Data Factory.
  • Configure and support SSIS packages for complex ETL processes.
  • Develop PL/SQL procedures, functions, and packages for business logic and processing.
  • Monitor and optimize end-to-end data workflows across multiple environments.
  • Collaborate with architecture and application teams on secure, scalable data solutions.
  • Create technical documentation, data flow diagrams, and procedures.
  • Prepare AI-ready datasets and metadata assets for analytics and ML projects.
  • Implement data quality controls, validation, reconciliation, and governance.
  • Translate Life & Annuities concepts into scalable data models and reporting.
  • Support deployment planning, release validation, and day-shift operations.
  • Communicate with stakeholders on design, status, and issue resolution.

Skills

Oracle
PostgreSQL
Azure Data Factory
SSIS
C#
Data Modeling
ETL
SQL
Data Governance
English Communication

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering

Tools

Azure Data Factory
SSIS

Job description

AI-Aware Data Engineer (Oracle, PostgreSQL & Azure)
About the Role

As an AI-Aware Data Engineer, you will make an impact by designing, developing, and optimizing enterprise data solutions that support analytics, reporting, and AI-ready data initiatives. You will be a valued member of the Data Engineering team and work collaboratively with architects, developers, business stakeholders, testers, and operations teams to build scalable, secure, and high-performing data platforms.

In this role, you will leverage your expertise in Oracle, PostgreSQL, Azure Data Factory, SSIS, and C# to deliver modern data integration solutions while supporting Life & Annuities insurance business processes and enabling AI-driven insights.

In This Role, You Will
  • Design and implement efficient data models and integration patterns across Oracle and PostgreSQL environments to support enterprise analytics and reporting.
  • Develop and optimize C#-based data services and APIs that interact with relational databases and enterprise data platforms.
  • Build, maintain, and optimize scalable data pipelines using Azure Data Factory for ingestion, transformation, and loading of structured and semi-structured data.
  • Configure, enhance, and support Microsoft SSIS packages for complex data integration and transformation processes.
  • Develop advanced PL/SQL procedures, functions, and packages that support business logic, data validation, and high-volume transactional processing.
  • Monitor, troubleshoot, and optimize end-to-end data workflows across Oracle, PostgreSQL, Azure Data Factory, and SSIS environments.
  • Collaborate with architecture and application teams to develop secure, scalable, and compliant data solutions aligned with enterprise standards.
  • Create and maintain technical documentation, data flow diagrams, process documentation, and operational procedures.
  • Prepare high-quality, AI-ready datasets, metadata assets, and curated data structures to support analytics, machine learning, and predictive modeling initiatives.
  • Implement data quality controls, validation checks, reconciliation processes, and governance standards that support regulatory and business requirements.
  • Translate Life & Annuities insurance concepts, including policies, premiums, claims, and reserves, into scalable data models and reporting solutions.
  • Support deployment planning, release validation, production monitoring, and operational support activities within a day-shift environment.
  • Communicate effectively with technical and business stakeholders through design discussions, project updates, and issue-resolution activities.
Work Model

We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role's business requirements, this is a hybrid position requiring 3 days per week in a client or Cognizant office.

Regardless of your working arrangement, we are here to support a healthy work-life balance through our various wellbeing programs.

The working arrangements for this role are accurate as of the date of posting. This may change based on the project you're engaged in, as well as business and client requirements. Rest assured, we will always be clear about role expectations.

What You Need to Have to Be Considered
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field.
  • 8-12 years of experience designing, developing, and supporting enterprise data solutions.
  • Strong expertise in Oracle database development, schema design, performance tuning, partitioning, and PL/SQL programming.
  • Advanced experience with Azure Data Factory, including pipeline development, orchestration, scheduling, and parameterization.
  • Strong experience developing and maintaining Microsoft SSIS packages and enterprise ETL workflows.
  • Hands‑on experience with PostgreSQL administration, performance optimization, and query tuning.
  • Strong C# development experience building data‑centric services, APIs, and integration solutions.
  • Experience designing and implementing scalable data integration and transformation architectures.
  • Strong understanding of data governance, data quality, security, and compliance practices.
  • Experience working with enterprise cloud and hybrid data environments.
  • Strong analytical, problem‑solving, and stakeholder management skills.
  • Excellent written and verbal communication skills in English.
These Will Help You Stand Out
  • Experience supporting Life & Annuities insurance platforms and business processes.
  • Knowledge of policy administration, premiums, claims, reserves, underwriting, and insurance reporting.
  • Experience preparing AI‑ready datasets and supporting machine learning, predictive analytics, or AI initiatives.
  • Familiarity with modern data architecture patterns, including Data Lakes, Data Warehouses, and Lakehouse platforms.
  • Experience implementing data observability, monitoring, and automated quality controls.
  • Exposure to cloud‑native analytics and reporting solutions on Azure.
  • Experience working within Agile delivery environments.
  • Knowledge of responsible AI, metadata management, and data lineage concepts.
Salary and Other Compensation

The annual salary for this position is anticipated to be between $100,000 and $125,000, depending on experience, qualifications, geographic location, skills, and other job‑related factors.

This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits

Cognizant offers a comprehensive and competitive benefits package designed to support the health, wellbeing, and financial security of our associates and their families, including:

  • Medical, dental, vision, and life insurance

  • Employee Stock Purchase Plan (ESPP)
  • Employee Assistance Program (EAP)
  • Paid holidays and paid time off (PTO)
  • Paid parental leave and fertility assistance programs
  • Learning and development programs, certifications, and career advancement opportunities
  • Wellness and mental health resources
  • Career growth and internal mobility opportunities

Benefits may vary by location and employment status and are subject to change.

Application Deadline

Applications will be accepted until October 30, 2026.

Cognizant reserves the right to close this posting earlier based on application volume, business needs, or hiring timelines.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Azure Cloud and AI Lead - 69858401
Azure Cloud and AI Lead - 69858401

Cognizant • Toronto

On-site
CAD 117,045 - 133,866
Medical/Dental/Vision/Life Insurance
Paid holidays plus Paid Time Off
401(k) plan and contributions
+3
Enterprise Knowledge Architect (SEG)
Enterprise Knowledge Architect (SEG)

Cognizant • Mississauga

On-site
CAD 150,000 - 170,000
Azure Integration Tech Lead - 70905781
Azure Integration Tech Lead - 70905781

Cognizant • Toronto

Remote
CAD 127,000 - 145,000
Medical/Dental/Vision/Life Insurance
Paid holidays + PTO
401(k) plan and contributions
+3
Applications Development Sr Programmer Analyst - Assistant Vice President
Applications Development Sr Programmer Analyst - Assistant Vice President

Citi • Mississauga

On-site
CAD 133,000 - 200,000
Master Data Management (MDM) Data Architect
Master Data Management (MDM) Data Architect

Cognizant • Mississauga

Remote
CAD 100,000 - 125,000
Medical/Dental/Vision/Life Insurance
Paid holidays plus Paid Time Off
Long-term/Short-term Disability
+1
Senior Test Manager - AI Testing
Senior Test Manager - AI Testing

Cognizant • Toronto

Hybrid
CAD 110,000 - 141,000
VP Senior Applied AI Full-Stack Engineer
VP Senior Applied AI Full-Stack Engineer

Citi • Mississauga

On-site
CAD 170,500 - 241,072
Azure Business Data Analyst (Hybrid)
Azure Business Data Analyst (Hybrid)

Cognizant • Toronto

Hybrid
CAD 75,000 - 100,000
Azure BSA ( Hybrid )
Azure BSA ( Hybrid )

Cognizant • Toronto, Ottawa

On-site
CAD 80,000 - 115,000
Associate Director, Generative AI and Agentic AI Architecture
Associate Director, Generative AI and Agentic AI Architecture

Cognizant • Mississauga

Remote
CAD 152,000 - 170,000
Medical/Dental/Vision/Life Insurance
Paid holidays plus Paid Time Off
401(k) plan and contributions
+3