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 CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs. 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