AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Accenture
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Accenture Technical Lead Interview Questions, Process, and Tips
Top Accenture Technical Lead Interview Questions and Answers
- Q1. Methods of migrating data from Legacy system to EBS
- Q2. 1. How to upload large volume of data in sap
- Q3. Load data into multiple table using SQL*Loader
Accenture Technical Lead Interview Experiences
22 interviews found
Anonymous
I applied via Referral and was interviewed in May 2021. There was 1 interview round.
Interview Questionnaire
6 Questions
- Q1. What is SQL* Loader?
- Ans.
SQL*Loader is a utility tool provided by Oracle to load data from external files into Oracle database tables.
SQL*Loader uses control files to specify the format of the data to be loaded.
It can load data from various file formats like CSV, fixed-length, etc.
It can also perform data transformations and validations during the loading process.
SQL*Loader is a command-line tool and can be invoked using the sqlldr command.
It ...
- Q2. Use of DB Link
- Ans.
DB Link is a feature in Oracle database that allows communication between two databases.
DB Link is used to access data from a remote database as if it were local.
It allows for distributed queries and transactions.
DB Link can be created using a database link object.
It is commonly used in data warehousing and reporting applications.
DB Link can also be used for cross-database joins and updates.
- Q3. Methods of migrating data from Legacy system to EBS
- Ans.
Various methods can be used to migrate data from Legacy system to EBS.
Extract, Transform, Load (ETL) process can be used to migrate data
Data can be migrated using APIs provided by EBS
Manual data entry can be done for small amounts of data
Third-party tools can be used for data migration
Data can be migrated in batches to avoid any errors
- Q4. Load data into multiple table using SQL*Loader
- Ans.
SQL*Loader can load data into multiple tables using control files and mapping data to columns.
Create a control file with the mapping of data to columns in each table
Use the INFILE parameter to specify the data file to be loaded
Use the INTO TABLE parameter to specify the target table for each set of data
Use the APPEND parameter to add data to existing tables
Example: sqlldr control=example.ctl data=example.dat log=exampl
- Q5. Oracle Interface VS API
- Ans.
Oracle Interface is a way to interact with Oracle database while API is a set of protocols for building software applications.
Oracle Interface is specific to Oracle database while API can be used with any software application
Oracle Interface is used to access data from Oracle database while API is used to interact with software applications
API provides a standard way for different software applications to communicate w...
- Q6. Basics of Form and Report Builder
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(3 Questions)
- Q1. Tell me about your overall experience
- Ans.
I have over 10 years of experience in software development, with a focus on leading teams and delivering high-quality products.
Led multiple cross-functional teams in developing and launching successful products
Extensive experience in full stack development, including front-end and back-end technologies
Strong background in Agile methodologies and project management
Collaborated with stakeholders to define project require
- Q2. Explain Projects you have worked on
- Ans.
I have worked on various projects including a mobile app for tracking fitness goals and a web application for managing inventory.
Developed a mobile app using React Native to track fitness goals and provide workout plans
Built a web application using Angular for managing inventory and tracking sales
Implemented RESTful APIs for communication between front-end and back-end systems
- Q3. Situation based questions, how to handle conflict in the team
Interview Preparation Tips
- Agile Methodology
- Scrum
- Project Management
Scenarios
Usecases
Aptitude algorithm
Parking lot algorithm design
(1 Question)
- Q1. Salary expectation Role resp
What people are saying about Accenture
(2 Questions)
- Q1. What is OOPS concept
- Ans.
OOPS (Object-Oriented Programming) concept is a programming paradigm based on the concept of objects, which can contain data and code.
OOPS focuses on creating objects that interact with each other to solve a problem
It involves concepts like encapsulation, inheritance, polymorphism, and abstraction
Encapsulation is the bundling of data with the methods that operate on that data
Inheritance allows a class to inherit proper...
- Q2. What is rest services
- Ans.
REST services are a type of web service that uses HTTP methods to access and manipulate data.
REST stands for Representational State Transfer
Uses standard HTTP methods like GET, POST, PUT, DELETE
Data is typically exchanged in JSON or XML format
Stateless communication between client and server
Example: accessing user information from a database using a REST API
Skills evaluated in this interview
Accenture interview questions for designations
pradeep
(1 Question)
- Q1. What is scaffolding
- Ans.
Scaffolding is a temporary structure used to support workers and materials during construction or maintenance of buildings.
Scaffolding provides a safe working platform for workers at heights
It helps in accessing hard-to-reach areas during construction
Different types of scaffolding include tube and coupler, frame, and system scaffolding
Get interview-ready with Top Accenture Interview Questions
(2 Questions)
- Q1. Asked to write query in sql
- Q2. Asked to write collection in dot net
Interview Preparation Tips
Technical Lead Jobs at Accenture
(2 Questions)
- Q1. Angular Architecture
- Q2. Explain about material
- Ans.
Material refers to the substance of which something is made or composed.
Material can refer to physical substances like wood, metal, plastic, etc.
In the context of design and art, material can also refer to textures, colors, and patterns used in creating a piece.
Materials can have different properties like strength, flexibility, durability, etc.
Examples: Steel is a material used in construction, cotton is a material use...
(2 Questions)
- Q1. 1. How to upload large volume of data in sap
- Ans.
Use SAP Data Services or LSMW to upload large volume of data in SAP
Use SAP Data Services to extract, transform, and load data into SAP systems
Utilize LSMW (Legacy System Migration Workbench) for mass data uploads
Split large data files into smaller chunks for easier processing
Optimize data upload processes for better performance
- Q2. One critical disadvantage of using BDC.
- Ans.
One critical disadvantage of using BDC is the complexity of configuration and maintenance.
Complexity of configuration and maintenance can lead to errors and inefficiencies
Requires specialized knowledge and training to set up and troubleshoot
Changes in underlying systems can impact BDC functionality
Difficult to scale and adapt to evolving business needs
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
(2 Questions)
- Q1. STP, OSPF, BGP, EIGRP
- Q2. Day to day activities
(1 Question)
- Q1. Current salary and education certificates
Interview Preparation Tips
I was interviewed in Oct 2024.
(1 Question)
- Q1. Questions about technology
I applied via Job Portal and was interviewed in Apr 2024. There was 1 interview round.
Javascript sorting the values of the array without using inbuilt function
Accenture Interview FAQs
Tell us how to improve this page.
Accenture Interviews By Designations
- Accenture Associate Software Engineer Interview Questions
- Accenture Application Developer Interview Questions
- Accenture Application Development Analyst Interview Questions
- Accenture Software Developer Interview Questions
- Accenture Software Engineer Interview Questions
- Accenture Analyst Interview Questions
- Accenture Application Development Associate Interview Questions
- Accenture Senior Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Technical Lead Interview Questions
- Technical Specialist Interview Questions
- Member Technical Staff Interview Questions
- Technical Analyst Interview Questions
- Technical Consultant Interview Questions
- Technical Architect Interview Questions
- Associate Technical Consultant Interview Questions
- Associate Technical Leader Interview Questions
- Show more
Accenture Technical Lead Interview Process
based on 16 interviews
1 Interview rounds
- Technical Round
Technical Lead Interview Questions from Similar Companies
Fast track your campus placements
Accenture Technical Lead Reviews and Ratings
based on 104 reviews
Rating in categories
|
Application Development Analyst
38.9k
salaries
|  ₹3 L/yr - ₹12 L/yr |
|
Application Development - Senior Analyst
26.2k
salaries
| ₹6.9 L/yr - ₹20.2 L/yr |
|
Team Lead
24.2k
salaries
| ₹7.1 L/yr - ₹25.5 L/yr |
|
Senior Software Engineer
18.3k
salaries
| ₹6 L/yr - ₹19.4 L/yr |
|
Software Engineer
17.5k
salaries
| ₹3.6 L/yr - ₹13.3 L/yr |
TCS
Cognizant
Capgemini
Infosys
- Home >
- Interviews >
- Accenture Interview Questions >
- Accenture Technical Lead Interview Questions
