Software Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, and maintain Azure Databricks pipelines for the ingestion, transformation, integration, and downstream consumption of credit card data.

• Create scalable processing solutions utilizing PySpark, Python, Spark SQL, SQL, Delta Lake, and ADLS for handling high-volume card datasets.

• Construct transformation logic for data related to cardholders, accounts, transactions, authorizations, payments, balances, fees, interest, rewards, and servicing.

• Convert business requirements and source-to-target mappings into reusable Databricks notebooks, workflows, jobs, and ETL/ELT processes.

• Assist in the conversion and modernization of the credit card platform, which includes data mapping, historical/incremental loads, transformation, and reconciliation.

• Implement automated controls for data quality, balancing, reconciliation, cleansing, and exception handling across both source and target environments.

• Safeguard sensitive cardholder information, including PAN and PCI-sensitive data, through techniques like masking, tokenization, encryption, and proper data management practices.

• Diagnose and optimize Databricks pipelines.

• Collaborate with credit card subject matter experts, architects, analysts, and application teams.

• Provide expertise in designing, developing, and executing solutions that improve the quality of IT products and services.

⛳️ Requirements

• Over 5 years of experience in Data Engineering, ETL/Data Warehouse, or Big Data, including more than 3 years of direct Azure Databricks development.

• Significant hands-on development experience with Databricks, PySpark, Python, Spark SQL, SQL, Delta Lake, and ADLS.

• Proven experience in designing and developing scalable ETL/ELT pipelines for large-volume transactional and financial datasets.

• Strong background in data transformation, source-to-target mapping, cleansing, reconciliation, data quality, and exception handling.

• Experience in the credit card/payments domain, with knowledge of card accounts, transactions, authorizations, payments, balances, billing, and settlement.

• Familiarity with Azure DevOps, Git, CI/CD, and Agile/Scrum development methodologies.

• Solid experience in banking/financial services and a comprehension of financial data controls and reconciliation.

• Bachelor's Degree required.

• Experience with TSYS or another leading credit card processing platform.

• Involvement in supporting credit card conversions, migrations, or platform modernization.

• Knowledge of the complete 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 management of sensitive cardholder data.

• Experience leveraging advanced Databricks capabilities such as Unity Catalog, Workflows, Auto Loader, and Lakeflow/Delta Live Tables.

• Experience transitioning Informatica PowerCenter or SSIS workloads to Databricks/PySpark.

• Possession of Azure and/or Databricks certifications and experience with extensive banking conversion initiatives.

• Capability to successfully pass a background investigation.

• For applicable positions, ability to meet U.S. government security-clearance standards.

🏝️ Benefits

• Competitive salary.

• Comprehensive insurance packages.

• Matching contributions via the 401(k) plan and share purchase plan.

• Paid time off for vacations, holidays, and sick leave.

• Paid parental leave.

• Opportunities for learning and tuition assistance.

• Wellness and well-being initiatives.

• Ownership opportunity from day one through CGI’s share purchase plan and partnership model.

• Opportunities to enhance skills and expand career pathways.

• Global capabilities and technological expertise.

• Reasonable accommodations for qualified individuals with disabilities.