Tata Consultancy Services Software Developer interview questions

Software engineer plsql development SQL IBM DB2 TOAD ORACLE procedure function triggered react js SAP MSSQL join inner join right join JAVA PYthon jdk jre Apache tomact jera PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. It allows you to write full programs to interact with Oracle databases, including control structures like loops, if/else, and exception handling — something standard SQL doesn't support

1. Initial Screening A brief discussion with a recruiter or technical screener. Covered my background, experience, and suitability for the role. Basic questions around cloud platforms, DevOps tools, and CI/CD practices. 2. Technical Assessment (Take-home Assignment) I was given a scenario-based assessment focused on designing a cloud infrastructure for a web application with: Multi-region deployment Low latency and high availability Data synchronization across regions Backend and frontend stack integration Required to submit a detailed architecture document and diagram. 3. Technical Interview / Review (Expected) A deeper discussion around the submitted architecture: Design decisions and trade-offs Services selected (e.g., RDS vs DynamoDB, CloudFront vs alternatives) Handling scalability, latency, security, and consistency Likely includes questions on: Infrastructure as Code (Terraform) CI/CD pipeline setup Observability, cost optimization, and automation 4. Final Round (Culture/Team Fit) (if applicable) Interaction with team members or leadership Focus on collaboration style, problem-solving approach, and long-term fit