At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve. At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com.
This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please.
Job Title: Software Engineer- Python ETL / Airflow
Position: Software Engineer
Experience: 3+ Years
Category: Development
location: Chennai / Bangalore/Hyderabad/Pune
Position ID: J0125-1353
Employment Type: Full Time
1. ETL Development:
o Design, develop, and optimize scalable ETL workflows and pipelines using Python and Apache Airflow.
o Handle data extraction, transformation, and loading from various sources into GCP services like Cloud Storage and BigQuery.
2. Airflow Implementation & Management:
o Set up, configure, and maintain Apache Airflow in production preferably on GCP (Composer or on VM).
o Develop dynamic and reusable DAGs and workflows for complex ETL processes.
o Monitor and debug Airflow workflows to ensure reliability and performance.
3. GCP Integration.
o Utilize GCP services for ETL processes, including BigQuery, Cloud Storage, Dataflow, and Pub/Sub.
o Implement and manage secure connections to GCP services using IAM roles and service accounts.
4. Optimization & Scaling:
o Handle large-scale data processing efficiently, optimizing for performance and cost.
o Automate data quality checks, error handling, and retry mechanisms in workflows.
5. Collaboration & Documentation:
o Collaborate with Architects, analysts, and other stakeholders to understand ETL requirements.
o Document workflows, configurations, and best practices for Airflow pipelines.
Required Skills & Qualifications:
• Technical Skills:
o Strong proficiency in Python programming with experience in handling large datasets.
o In-depth knowledge of Apache Airflow in production environments.
o Familiarity with Airflow operators, hooks, XComs, task dependencies, and dynamic DAG creation.
o Hands-on experience with GCP services like BigQuery, Cloud Storage, Dataflow, and Cloud SQL.
o Proficiency in SQL for data extraction, transformation, and aggregation.
• Experience:
o 3+ years of experience in ETL development and data engineering.
o 1+ years of experience setting up and managing Airflow on GCP (e.g., Composer or manual setup).
o Experience in handling data security, encryption, and IAM policies on GCP.
o Excellent debugging, problem-solving, and performance optimization skills.
Education: Computer Science (BE / BTech / MTech / MS) from Tier I Premier institutes
CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodations for people with disabilities in accordance with provincial legislation. Please let us know if you require a 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.
Come join our team—one of the largest IT and business consulting services firms in the world.