Software Data Engineer

Company Profile:

Founded in 1976, CGI is among the largest independent IT and business consulting services firms in the world. With 94,000 consultants and professionals across the globe, CGI delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at cgi.com.

Job Title: Databricks

Position: Software Engineer/SSE

Experience: 4-6 Years

Category: Software Development/ Engineering

Shift: 1 PM to 10 PM

Main location: India, Telengana, Hyderabad

Position ID: J0726-0634

Employment Type: Full Time

Education Qualification: Bachelor's degree in Computer Science or related field or higher with minimum 3 years of relevant experience.

Position Description: Design, develop, and maintain scalable ETL/ELT pipelines using Databricks and PySpark.

Develop data processing solutions using Python and Spark for large-scale data transformation.

Write complex SQL queries for data extraction, transformation, validation, and reporting.

Build and optimize data workflows to improve performance, scalability, and reliability.

Work with structured and semi-structured data from multiple data sources.

Collaborate with data analysts, business stakeholders, and development teams to understand data requirements.

Perform data quality checks, troubleshooting, and root cause analysis for data issues.

Optimize Spark jobs and SQL queries for improved performance.

Follow coding standards, documentation, and best practices for data engineering.

Participate in code reviews and support production deployments.

Responsibilities:

Minimum 3 years of experience in Data Engineering.

Strong hands-on experience with Databricks.

Good experience in PySpark and Apache Spark.

Strong programming skills in Python.

Proficiency in SQL, including complex queries, joins, window functions, and performance tuning.

Experience in developing ETL/ELT pipelines.

Knowledge of data warehousing concepts and data modeling.

Experience with Git or other version control systems.

Strong analytical, problem-solving, and debugging skills.

#LI-IP2

Must-Have Skills:

Strong experience Databricks

Hands-on experience Data & Delta Lake

Experience with PySpark and Apache Spark.

Experience with Python.

Experience with ETL/ELT pipelines.

Excellent communication and leadership skills

Good-to-Have Skills:

data warehousing concepts

Experience with Git or other version control systems.

Background in software development or system architecture

Life at CGI:

It 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. Come join our team, one of the largest IT and business consulting services firms in the world

Key Responsibilities

. Design, develop, and optimize data pipelines using Databricks, PySpark, and Python.

. Build scalable ETL/ELT processes to ingest, transform, and load data from multiple sources.

. Develop and maintain Delta Lake architectures and data lakehouse solutions.

. Implement data quality, validation, and monitoring frameworks.

. Collaborate with Data Analysts, Data Scientists, and business stakeholders to understand data requirements.

. Optimize Spark jobs for performance, scalability, and cost efficiency.

. Work with structured, semi structured, and unstructured data sources.

. Implement CI/CD practices and deployment automation for data engineering workloads.

. Ensure data security, governance, and compliance standards are followed.

. Troubleshoot and resolve data pipeline and processing issues.

Technical Skills

. Strong experience with Databricks

. Proficiency in Python

. Hands on experience with PySpark

. Strong SQL development skills

. Experience with Delta Lake

. Knowledge of Data Lake and Lakehouse architectures

. Experience building ETL/ELT pipelines

. Understanding of Spark optimization techniques

. Experience with Git/version control systems

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.