Azure Data Engineer

Position Description
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: Azure Data Engineer
Position: SSE/LA
Experience: 5 to 7 years
Category: Software Development/ Engineering
Shift: 24/7 Rotational Shift
Main location: Bangalore
Position ID: J0626-0134
Employment Type: Full Time
Education Qualification: Bachelor's degree in Computer Science or related field or higher with minimum 5 years of relevant experience.

Job Summary
Position Description
Azure ETL Data Engineer - 5-7 Years
Job Description for Azure ETL Data Engineer:

• Design and develop ETL processes based on functional and non-functional requirements in Azure platform
• Design and develop migration process from SQL Server to Azure platform
• Understand the full end to end development activities from design to go live for ETL development in Azure platform
• Recommend and execute improvements
• Document component design for developers and for broader communication.
• Understand and adopt an Agile (SCRUM like) software development mindset
• Follow established processes/standards, business technology architecture for development, release management and deployment process
• Execute and provide support during testing cycles and post-production deployment, engage in peer code reviews.

Job Requirement for Azure ETL Data Engineer:

Must-have skills

• Undergraduate Degree or Technical Certificate.
• Microsoft Azure certified – Data Engineer
• Working experience (> 3 years) in Azure Data Factory, Azure Databricks, ADLS, Datadog, Azure SQL DB, Azure Synapse
• Hands-on experience in Python / Spark / Pyspark / JSON
• SQL Server (SSIS)
• Working experience with data modeling, relational modeling and dimensional modeling
• General knowledge about file formats (e.g. XML, CSV, JSON), databases (e.g. MS SQL, Oracle) and different type of connectivity is also very useful.
• Data files movement via mailbox
• Source-code versioning/promotion tools, e.g. Git/Jenkins
• Orchestration tools in Azure platform

Nice-to-have skills

• Sqoop / Hadoop / Shell Script
• Java / Scala
• Experience in Agile environment
• Tracking and collaboration tools (e.g. JIRA, Confluence, MS Teams)

Skills:

• Azure Data Factory
• Azure Databricks
• Azure Data Lake
• Data Engineering
• Azure SQL Data Warehouse
• SQL
• PowerShell
• Python
• Pyspark

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.

Come join our team—one of the largest IT and business consulting services firms in the world.