CGI
Website:
cgi.com
Company:
https://www.linkedin.com/company/cgi
Seniority: Entry level
Industries: IT Services and IT Consulting
Job details:
Position Description
Company:
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.
Position: Software Engineer /Senior Software Engineer - Azure Data Brick with ETL and Power BI
Experience: 3-6 years
Category: Software Development/ Engineering
Shift Timing: 12:00 PM to 10:00 PM
Location: Chennai /Bangalore/Hyderabad/Pune/Mumbai
Position ID: J1125-1382
Employment Type: Full Time
The ETL Developer will be responsible for designing, developing, and implementing robust and scalable data architectures and ETL solutions. This role requires expertise in Databricks for data processing and Lakehouse architecture, Kimball dimensional modelling for data warehousing, and Power BI and Microsoft Fabric for data visualization and analytics platform implementation. As an ETL Developer, you will design, develop and implement scalable, secure, and high-performance data solutions using the Databricks Lakehouse Platform. You will work with ETL Architects to on architectural standards and collaborate with stakeholders to align data strategies with business goals. Your role will focus on leveraging Databricks' unified analytics capabilities to build enterprise-grade data platforms that support advanced analytics, machine learning, and real-time data processing.
Your future duties and responsibilities
Develop and build ingestion, transformation, storage, and consumption layers on Databricks
- Develop and maintain data models, data flow diagrams, and other solution documentation based on Kimball dimensional modelling principles.
- Develop and implement Lakehouse solution using Delta Lake, Unity Catalog, and structured streaming.
- Proven experience in implementing data governance using Unity Catalog, including fine-grained access control, column-level lineage, data classification, audit logging, and centralized metadata management across workspaces and cloud environments
- Develop scalable ETL/ELT pipelines using Apache Spark, PySpark, and Databricks Workflows.
- Development of integration of Databricks with enterprise systems such as data catalogs, data quality frameworks, ML platforms, and BI tools.
- Design and development of high-performance reporting models and paginated reports, configurable inquiries and interactive dashboards using Power BI.
- Experience with CI/CD pipelines, version control, and automated testing for Databricks notebooks and jobs.
- Experience in performance tuning and cluster configuration.
- Participate in architectural reviews, code audits, to ensure adherence to standards and scalability.
- Collaborate closely with clients, business stakeholders, and internal teams to translate business requirements into technical solutions.
- Stay current with Databricks innovations and advocate for adoption of new features and capabilities.
Required Qualifications To Be Successful In This Role
Education Qualification: Bachelor’s degree in computer science or related field or higher with minimum 3 years of relevant experience.
3 to 6 years of experience in ETL/Power BI, with 3+ years in Databricks and Apache Spark. Strong proficiency in SQL & DAX
- Experience in project migrating Snowflake and other custom EDW/ ETL solutions to Databricks.
- Experience of migrating different reporting solutions like Cognos, SAP BO etc to Power BI and Databricks.
- Experience with Kimball dimensional modelling and data warehousing concepts
- Experience in designing and deploying ETL/ELT pipelines for large-scale data integration.
- Proficiency in Power BI for paginated report and dashboard development, including DAX.
- Strong experience in Delta Lake, structured streaming, PySpark, and SQL.
- Strong understanding of Lakehouse architecture, data mesh, and modern data stack principles.
- Experience with Unity Catalog, Databricks Repos, Jobs API, and Workflows.
- Proven ability to design and implement secure, governed, and highly available data platforms.
- Familiarity with cloud platforms (Azure, AWS, GCP) and their integration with Databricks.
- Experience with CI/CD, DevOps, and infrastructure-as-code tools (Terraform, GitHub Actions, Azure DevOps).
- Knowledge of machine learning lifecycle, MLflow, and model deployment strategies.
- An understanding of E-R data models (conceptual, logical, and physical).
- Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions.
- Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions, roles and able to interact effectively with all levels.
- Strong problem-solving skills. Ability to identify where focus is needed and bring clarity to business objectives, requirements, and priorities.
Must to Have :
- Azure Databricks, Databricks Lakehouse Architecture
- ETL / ELT, Data Architecture
- Apache Spark / PySpark, Delta Lake, Delta Live Tables (DLT)
- Unity Catalog, Medallion Architecture
- Dimensional Modeling (Star & Snowflake), Kimball, Data Vault
- Slowly Changing Dimensions (SCD Types 1, 2, 3)
- Data Governance, RBAC, Data Lineage, Metadata Management
- CI/CD & DevOps (Azure DevOps, GitHub Actions, Terraform)
- SQL, Power BI, Self-Service Analytics, Semantic Model, Paginated Reports
- Data Quality (Great Expectations), Performance Tuning, Cost Optimization
- Cloud Platforms (Azure, AWS, GCP), Azure Data Factory, Synapse, Event Hubs
Nice-to-Have Skills:
- Streaming frameworks (Kafka, Event Hubs), workspace automation
- Advanced data modeling for Finance, Performance Budgeting, HRM systems
- Subject-area models for financial reporting, workforce analytics, payroll insights
- Delta Change Data Feed (CDF) and real-time data marts
- Certifications:
- Databricks Certified Data Engineer Associate / Professional
- Databricks Certified Associate Developer for Apache Spark
- Azure / Power BI certifications
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
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.
Click on Apply to know more.
