Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by TimesPro Team. If you also belong to the team, you can get access from here

TimesPro Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

TimesPro Assistant Manager Information Technology Interview Questions and Answers

Updated 30 Jan 2024

TimesPro Assistant Manager Information Technology Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Techinal question and about provious experience

Interview questions from similar companies

QA Engineer Interview Questions & Answers

Genpact user image Skumar test user4

posted on 5 Sep 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL query with join
  • Ans. 

    SQL query with join

    • Use JOIN keyword to combine rows from two or more tables based on a related column between them

    • Specify the columns to select from each table in the SELECT statement

    • Use ON keyword to specify the join condition

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. SQL query with join
  • Ans. 

    SQL query with join

    • Use JOIN keyword to combine rows from two or more tables based on a related column between them

    • Specify the columns to select from each table

    • Use ON keyword to specify the join condition

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. HR Round for Company review & offer

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Testing related questions
  • Q2. Introduction about your self

I applied via Referral and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions on eloqua, email marketing

Interview Preparation Tips

Interview preparation tips for other job seekers - Be comfident while answering

I applied via Approached by Company and was interviewed before May 2021. There were 4 interview rounds.

Round 1 - Coding Test 

Online questions were based on scenarios to write SQL queries. Also got few questions on Python as well for which I had only limited knowledge.

Round 2 - Technical 

(8 Questions)

  • Q1. I'm listing some of the questions here which the interviewers (2 panel resources) asked me regarding Informatica ETL, Oracle DB and I might have missed some of them. What types of indexes are used on Orac...
  • Q2. What happens if Treat source row property as "Update" at session level but at target object "Delete" is checked?
  • Ans. 

    The source row will be treated as an update, but the target object will be deleted.

    • The session level property 'Treat source row as Update' will be applied to the source row.

    • The target object will be deleted regardless of the update status of the source row.

    • This can result in data loss if the source row contains important information.

  • Answered by AI
  • Q3. What are the different types of dimension tables?
  • Ans. 

    Dimension tables are used in data warehousing to provide descriptive information about the data in fact tables.

    • Slowly changing dimensions

    • Junk dimensions

    • Degenerate dimensions

    • Role-playing dimensions

    • Bridge dimensions

  • Answered by AI
  • Q4. What schema type was used in your previous project? And explain why it was used?
  • Ans. 

    We used a relational schema in our previous project as it was suitable for the data structure and allowed for efficient querying.

    • Relational schema was used as it allowed for efficient querying of data

    • The data structure was suitable for a relational schema

    • We were able to easily join tables to retrieve necessary data

    • Examples include using SQL to query a database with multiple tables

    • Normalization was used to reduce data r

  • Answered by AI
  • Q5. Difference between Joiner and Lookup transformations?
  • Ans. 

    Joiner combines data from multiple sources based on a common key, while Lookup retrieves data from a reference table based on a matching key.

    • Joiner is used to combine data from two or more sources based on a common key column.

    • Lookup is used to retrieve data from a reference table based on a matching key column.

    • Joiner can perform inner, outer, left, and right joins, while Lookup can only perform an inner join.

    • Joiner can...

  • Answered by AI
  • Q6. Scenario: I have records in a flat file ending with ; character at the end of each them. How to load these records into DB based on this character? What property will be used in Informatica?
  • Q7. How version control happened in your previous project?
  • Ans. 

    We used Git for version control in our previous project.

    • We created a Git repository for the project.

    • All team members were added as collaborators to the repository.

    • We followed the Git flow branching model.

    • We used pull requests for code review and merging.

    • We used tags to mark important releases.

    • We regularly pushed our changes to the remote repository.

    • We used Git commands like commit, push, pull, merge, and rebase.

    • We used...

  • Answered by AI
  • Q8. Which SCD type you worked on before and explain on that?
  • Ans. 

    I have worked on SCD Type 2 before.

    • SCD Type 2 is used to track historical changes in data.

    • It creates a new record for each change and maintains a history of changes.

    • It includes start and end dates for each record.

    • Example: Tracking changes in employee salary over time.

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. This round was taken by the project manager on a phone call. He asked me few basic fundamental questions related to my skills and the things which I worked on in my previous project. He also told me about ...
Round 4 - HR 

(1 Question)

  • Q1. Just F2F discussion with HR finalising on the compensation structure, learning opportunities and the organisational benefits as an employee.

Interview Preparation Tips

Interview preparation tips for other job seekers - If you're an experienced person, be confident about the things which you handled in previous project and be precise on to the point. Don't elaborate too much as the interviewers might build up questions based on that. Be strong in your technical areas of expertise. Expect scenario based questions related to your skills.

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed before Sep 2020. There were 4 interview rounds.

Interview Questionnaire 

7 Questions

  • Q1. Why you want to change the Job ?
  • Q2. What is accrual account and Journal entry ?
  • Ans. 

    Accrual account is a type of account that records revenue or expenses that have been earned or incurred but not yet received or paid.

    • Accrual accounting recognizes revenue and expenses when they are earned or incurred, regardless of when the cash is received or paid.

    • Accrual accounts are used to record these transactions until they are paid or received.

    • Journal entry is the process of recording a transaction in the accoun...

  • Answered by AI
  • Q3. What is prepaid accounts and its journal entry ?
  • Q4. Difference between the amortization and Depreciation ?
  • Q5. Golden Rules
  • Q6. Reconciliations meaning and process
  • Ans. 

    Reconciliations involve comparing financial records to identify discrepancies and resolve them.

    • Reconciliations are important for ensuring accuracy in financial reporting.

    • The process involves comparing two sets of records, such as bank statements and accounting records.

    • Any discrepancies are identified and investigated to determine the cause.

    • Examples of reconciliations include bank reconciliations, accounts receivable re

  • Answered by AI
  • Q7. Self Introduction ?

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are applying for R2R, you should know the Accounts. 1st question of the Interviewer would be Introduction. He wants to know why you want to change your Job.

I applied via Recruitment Consultant and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Questions were totally related to my work.
  • Q2. And also see how well knowledged you are

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and be prepared for the interview based on the subject you are going through

I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Java Basic questions and Git

Interview Preparation Tips

Interview preparation tips for other job seekers - After selection they haven't rolled the offer and put the profile on hold and then doesn't pick calls.

Interview Questionnaire 

1 Question

  • Q1. Questions on profile, team handling etc

I applied via Referral and was interviewed in Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. 1. about your work experience and projects which i have handled
  • Q2. 2. What challenges you have faced?
  • Q3. 3. Some exercise based on the logics in SAS. I have to write logics.
  • Q4. 4.common questions like what is the difference between dupkey and nodup. Difference in put and input. Macros

Interview Preparation Tips

Interview preparation tips for other job seekers - Just say what you did do not frame anything which you never did.

TimesPro Interview FAQs

How many rounds are there in TimesPro Assistant Manager Information Technology interview?
TimesPro interview process usually has 1 rounds. The most common rounds in the TimesPro interview process are One-on-one Round.

Tell us how to improve this page.

TimesPro Assistant Manager Information Technology Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Genpact Interview Questions
3.8
 • 3.1k Interviews
Brane Enterprises Interview Questions
2.0
 • 135 Interviews
Luxoft Interview Questions
3.7
 • 123 Interviews
QX Global Group Interview Questions
3.3
 • 86 Interviews
BDO India LLP Interview Questions
3.4
 • 78 Interviews
Thryve Digital Interview Questions
3.8
 • 68 Interviews
Magic Edtech Interview Questions
3.1
 • 50 Interviews
View all
Program Advisor
124 salaries
unlock blur

₹3.5 L/yr - ₹9 L/yr

Assistant Manager
37 salaries
unlock blur

₹5.2 L/yr - ₹15 L/yr

Counsellor
22 salaries
unlock blur

₹2 L/yr - ₹6 L/yr

Business Development Manager
20 salaries
unlock blur

₹5 L/yr - ₹8.5 L/yr

Sales Manager
18 salaries
unlock blur

₹2.4 L/yr - ₹4.8 L/yr

Explore more salaries
Compare TimesPro with

Genpact

3.8
Compare

Taurus BPO Services

4.5
Compare

Brane Enterprises

2.0
Compare

QX Global Group

3.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview