ETL Support

Position Description:

Company Profile:

At CGI were a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72000 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 were a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72000 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 .
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: ETL Support
Position: Senior Software Engineer
Experience: 4 Years
Category: Software Development/Engineering
Job Location: Bangalore Hyderabad Chennai and Pune
Mode of Work: Hybrid (3 Days WFO)
Position ID: J1025-0482
Shift timing: Readiness to work and support until 12 AM IST and work in rotational shifts including weekend

Technical Skills Required:
1. Database Management and SQL experience: Experience with data extraction transformation and loading (ETL) processes. Proficient in DB2: writing simple to complex queries troubleshooting and performance tuning Strong knowledge of SQL: joins subqueries stored procedures triggers and indexing.
5. Application Support and Maintenance activities: Understanding of batch processing job scheduling tools (e.g. Tidal Autosys etc). Ability to support real-time and batch applications including log analysis and error handling.
8. Monitoring & Incident Management: Familiarity with monitoring applications. Nice to have experience working with Financials systems. Experience in incident triage root cause analysis and resolution within SLAs. Knowledge of ITIL practices and ticketing systems (e.g. ServiceNow JIRA).
12. Operating Systems: Advanced proficiency in Unix/Linux: shell scripting process management file system navigation and cron jobs. Ability to analyze and resolve system-level issues using command-line tools.
15. Version Control & Deployment: Experience with version control systems. Nice to have Familiarity with CI/CD pipelines and deployment tools.
18. Enterprise Data lake experiance: Nice to have application supporting knowledge with EDL methodologies. Nice to have knowledge of HDFS Big data Hadoop systems.

Soft Skills Required:

1. Analytical Thinking: Strong problem-solving skills with the ability to analyze complex systems and data flows.
3. Communication: Clear and concise verbal and written communication. Ability to interact effectively with cross-functional teams including developers QA and business users.
6. Team Collaboration: Experience working in agile or DevOps environments. Willingness to share knowledge and mentor junior team members.
9. Adaptability & Ownership: Ability to work under pressure and manage multiple priorities. Proactive attitude with a sense of ownership and accountability.
12. Customer Focus: Commitment to delivering high-quality support and ensuring user satisfaction.

Readiness to work and support until 12 AM IST and work in rotational shifts including weekend

Your future duties and responsibilities:

1. Analytical Thinking: Strong problem-solving skills with the ability to analyze complex systems and data flows.
3. Communication: Clear and concise verbal and written communication. Ability to interact effectively with cross-functional teams including developers QA and business users.
3. Team Collaboration: Experience working in agile or DevOps environments. Willingness to share knowledge and mentor junior team members.
4. Adaptability & Ownership: Ability to work under pressure and manage multiple priorities. Proactive attitude with a sense of ownership and accountability.
5. Customer Focus: Commitment to delivering high-quality support and ensuring user satisfaction.

Required qualifications to be successful in this role:

Must have skills:
Database Management and SQL experience: SQL ETL processes
Proficient in DB2
Application Support and Maintenance activities
Monitoring & Incident Management:

Nice to have:
Experience working with Financials systems. Experience in incident triage root cause analysis and resolution within SLAs. Knowledge of ITIL practices and ticketing systems (e.g. ServiceNow JIRA).
Enterprise Data lake experiance: Nice to have application supporting knowledge with EDL methodologies. Nice to have knowledge of HDFS Big data Hadoop systems.

Skills:

• Analytical Thinking
• ETL
• SQL
• Unix
• DB2
• Hadoop Ecosystem (HDFS)

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll 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. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll 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.

Youll shape your career by joining a company built to grow and last. Youll 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 teamone of the largest IT and business consulting services firms in the world.