Software Developer

CGI•Atlanta, GA

2d•Hybrid

About The Position

Are you fascinated by information technology and its role in innovative business solutions? Are you a collaborative problem solver who wants to build a dynamic career making an impact for some of the most influential companies and government agencies in the world? If so, we think CGI is just the place for you. As a Databricks Data Engineer on our team, you'll work in a highly collaborative environment to provide expertise in designing, developing, and executing solutions to enhance the quality of IT products and services. At CGI, you can explore your full potential – not confined by borders or pre defined paths. You're empowered to solve problems in your own unique way which is not only valued and respected but encouraged. We're a close knit team that has access to global resources. You'll have the opportunity to explore a wide range of tools, technologies, and cutting edge solutions, all while enjoying the personal touch that our local operating approach offers. This position is located in Atlanta, GA in a hybrid working environment.

Requirements

2+ years of data engineering or software development experience with exposure to enterprise data solutions.
Hands on experience with Databricks, PySpark, Python, Spark, and SQL.
Experience developing ETL/ELT pipelines and performing data ingestion, transformation, mapping, and validation.
Understanding of Delta Lake, medallion architecture, and Bronze/Silver/Gold data processing patterns.
Strong SQL skills with experience working with relational databases such as SQL Server, PostgreSQL, or MySQL.
Understanding of data modeling, including dimensional models, fact/dimension structures, star schemas, and SCD concepts.
Experience with Git, CI/CD, REST APIs, and Agile/Scrum development practices.
Strong analytical and troubleshooting skills with the ability to learn new banking systems, datasets, and technologies.

Nice To Haves

Experience working with banking, core banking, credit card, or payment data.
Experience with ARGO or similar banking platforms.
Knowledge of ISO 8583, card authorization, settlement, ledger reconciliation, Visa/Mastercard processing, or BIN configuration.
Experience with Databricks Unity Catalog and data governance concepts.
Exposure to streaming technologies such as Kafka and Spark Structured Streaming.
Experience with cloud technologies such as AWS and/or Azure.
Understanding of automated data quality, reconciliation, and data profiling frameworks.
Exposure to AI/GenAI enabled data engineering, including Azure OpenAI or LLM assisted data profiling.

Responsibilities

Develop and maintain Databricks/PySpark data pipelines supporting banking, payment, and enterprise data initiatives.
Build Bronze, Silver, and Gold data layers using Databricks, Delta Lake, and medallion architecture patterns.
Develop ingestion, cleansing, transformation, and integration logic using Python, PySpark, Spark, and SQL.
Translate source system data and business rules into data mappings, governed data structures, and reusable transformation logic.
Support integration of core banking, card/payment, relational database, file, API, and streaming data sources into the lakehouse.
Develop data quality, reconciliation, validation, and exception handling processes to ensure accurate downstream data.
Assist with performance tuning, troubleshooting, deployment, and production support of Databricks pipelines and jobs.
Collaborate with senior developers, architects, business analysts, and banking SMEs throughout design, development, implementation, and support.