KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
N #2402
Applications open Full-Time Job

Cloud Data Engineer with AI

CGI

  • Hyderabad, India
  • Competitive Package (Best in Industry)
  • 5-9 Yrs
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

โ€ข Design, develop, and maintain AI-powered applications using Python, Generative AI, and LLMs. โ€ข Develop and integrate LLM-based solutions for business applications and automation. โ€ข Build and maintain RAG pipelines to retrieve relevant information from enterprise data sources. โ€ข Implement prompt engineering techniques to improve AI response quality and accuracy. โ€ข Work with vector databases and vector stores for embeddings, semantic search, and information retrieval. โ€ข Develop and integrate AI gateways, MCP services, and guardrails for secure AI application development. โ€ข Integrate AI models using AWS Bedrock, Azure AI, or Google Cloud AI services. โ€ข Develop and maintain secure REST APIs using Python, AWS Lambda, and API Gateway. โ€ข Use AWS services such as S3, EC2, IAM, KMS, and container technologies to build and deploy applications. โ€ข Implement Infrastructure as Code using Terraform to automate cloud infrastructure provisioning. โ€ข Follow cloud-native development practices to build scalable, reliable, and secure applications. โ€ข Implement authentication, authorization, encryption, and access control mechanisms. โ€ข Develop and maintain CI/CD pipelines for automated application testing and deployment. โ€ข Work with Docker and container technologies for application deployment. โ€ข Monitor application performance, troubleshoot issues, and optimize cloud resource utilization. โ€ข Collaborate with developers, architects, DevOps teams, and business stakeholders to deliver technical solutions. โ€ข Participate in code reviews, technical discussions, and Agile/Scrum activities. โ€ข Maintain technical documentation and follow software development and cloud security best practices. Must-Have Skills โ€ข Python: Strong programming skills in Python for application development and automation. โ€ข Generative AI & LLMs: Experience developing applications using Generative AI and Large Language Models. โ€ข RAG: Knowledge of Retrieval-Augmented Generation, document processing, embeddings, and information retrieval. โ€ข Vector Databases: Experience with vector stores, semantic search, and similarity search. โ€ข AI Gateway, MCP & Guardrails: Understanding of AI gateways, Model Context Protocol, and AI security guardrails. โ€ข AWS Cloud Services: Hands-on experience with AWS Lambda, S3, API Gateway, EC2, IAM, KMS, and containers. โ€ข Cloud AI Platforms: Experience with AWS Bedrock, Azure AI, or Google Cloud AI. โ€ข Prompt Engineering: Ability to create and optimize prompts for LLM-based applications. โ€ข API Development: Experience developing and integrating RESTful APIs. โ€ข Terraform: Experience with Terraform for Infrastructure as Code and cloud resource management. โ€ข Cloud-Native Development: Understanding of scalable application architecture, cloud services, and distributed systems. โ€ข Cloud Security: Knowledge of authentication, authorization, encryption, and access management. โ€ข Software Engineering: Understanding of coding standards, testing, debugging, version control, and application development best practices. Good-to-Have Skills โ€ข Experience with CI/CD tools such as Jenkins, GitHub Actions, and GitLab CI. โ€ข Knowledge of Docker and container technologies. โ€ข Familiarity with AI productivity tools such as Cursor and GitHub Copilot. โ€ข Experience with Agile/Scrum methodologies and Jira. โ€ข Knowledge of cloud monitoring, logging, and deployment automation. โ€ข Experience with multi-region and multi-currency applications. โ€ข Understanding of security, governance, compliance, and data protection. โ€ข Good communication, problem-solving, and collaboration skills. โ€ข Ability to provide technical guidance and work effectively with cross-functional teams.

Eligibility & process

Who can apply

Experience: 5-9 Yrs. Open to matching qualifications.

Skills & stack

Python Bricks Artificial Intelligence Terraform SQL Cloud AWS Pyspark

Selection process

  1. Online Assessment / Technical Interview Rounds / HR Review

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (Python, Bricks, Artificial Intelligence, Terraform, SQL, Cloud, AWS, Pyspark) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion CGI Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join CGI as a Cloud Data Engineer with AI?
Highlight CGI's market reputation, recent tech innovations, and how your skills in Python directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
CGI Competitive Package (Best in Industry)
Recruiter Resume Apply
Chat Chat with Kashii