Find similar career opportunities
Data Engineer Category: Software Development/ Engineering
Main location: United States, Remote
Position ID:J1026-2180
Employment Type: Full Time
Position Description: This position can be performed remotely from anywhere within the United States but ideal candidates will be located near a CGI office.
Your future duties and responsibilities: . Design, develop, and maintain Azure Databricks pipelines for credit card data ingestion, transformation, integration, and downstream consumption.
. Develop scalable processing solutions using PySpark, Python, Spark SQL, SQL, Delta Lake, and ADLS for high volume card datasets.
. Build transformation logic for cardholder, account, transaction, authorization, payment, balance, fee, interest, rewards, and servicing data.
. Translate business requirements and source to target mappings into reusable Databricks notebooks, workflows, jobs, and ETL/ELT processes.
. Support credit card platform conversion and modernization, including data mapping, historical/incremental loads, transformation, and reconciliation.
. Implement automated data quality, balancing, reconciliation, cleansing, and exception handling controls across source and target environments.
. Protect sensitive cardholder information, including PAN and PCI sensitive data, through appropriate masking, tokenization, encryption, and data handling practices.
. Troubleshoot and optimize Databricks pipelines while collaborating with credit card SMEs, architects, analysts, and application teams.
Required qualifications to be successful in this role: . 5+ years of Data Engineering, ETL/Data Warehouse, or Big Data experience, including 3+ years of hands on Azure Databricks development.
. Strong hands on development experience with Databricks, PySpark, Python, Spark SQL, SQL, Delta Lake, and ADLS.
. Experience designing and developing scalable ETL/ELT pipelines for large volume transactional and financial datasets.
. Strong experience with data transformation, source to target mapping, cleansing, reconciliation, data quality, and exception handling.
. Credit card/payments domain experience with knowledge of card accounts, transactions, authorizations, payments, balances, billing, and settlement.
. Experience with Azure DevOps, Git, CI/CD, and Agile/Scrum development practices.
. Strong banking/financial services experience and understanding of financial data controls and reconciliation.
Desired Qualifications
. Experience with TSYS or another major credit card processing platform.
. Experience supporting credit card conversions, migrations, or platform modernization.
. Knowledge of the end to end card lifecycle, including authorization, authentication, clearing, settlement, posting, and reconciliation.
. Experience with Mastercard and/or Visa data, interfaces, reporting, rewards, or loyalty programs.
. Understanding of PCI DSS, PAN protection, tokenization/de tokenization, encryption, and sensitive cardholder data management.
. Experience with advanced Databricks capabilities such as Unity Catalog, Workflows, Auto Loader, and Lakeflow/Delta Live Tables.
. Experience modernizing Informatica PowerCenter or SSIS workloads to Databricks/PySpark.
. Azure and/or Databricks certifications and experience with large scale banking conversion initiatives.
CGI anticipates accepting applications for this position through October 31, 2026.
Other Information:
CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. To support the ability to reward for merit based performance, CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $72,500.00 $160,700.00.
CGI's benefits are offered to eligible professionals on their first day of employment to include:
. Competitive compensation
. Comprehensive insurance options
. Matching contributions through the 401(k) plan and the share purchase plan
. Paid time off for vacation, holidays, and sick time
. Paid parental leave
. Learning opportunities and tuition assistance
. Wellness and Well being programs
Skills: - Banking
- ETL
- Informatica
- Microsoft SQL Server
- Spark SQL
