Project sessions

Project  - Collection of steps or process or an approach to

Implement task or operation or a business


It is a process where set of tasks define and implement this task

With a standard model

EX - IT Project

Here the model is SDLC And the business operation is task

software Development life cycle – SDLC

If we implement this task by using this model then it is “IT”




NFI[National From insurance] organization


Day to day operations(Source system)

2What are General metting happen in a project?


  1. Project Tender meeting(SLA)Service Level agreement
  2. KICK OFF Meeting[Project initial meeting/introduction meeting]
  3. Status/schedule Meeting(Weakly, daily)
  4. Delivery client Regular
  5. Delivery Meetingà Project MANAGER Meeting
  6. Team Meeting
  7. Clarification defect resolivation Meeting DeveloperàLeadàPMàClient
  8. Discussion Meeting


Development Responsibility

Documents in

  1. LLD/Micro Design/Source map/target 2 source/souce to target mapping etc.
  2. HLD
  3. CR(Change Request)
  4. Defect Tract sheet etc


Document out

  1. Generated code
  2. Unit test code results
  3. Defect Resolution steps
  4. HLD LLD

2What is HLD And What it contains?

Ans: HLD[High Level Design]

  1. It Display the scope and various sub components of corresponding tasks along with the relationship
  2. It is platform independent
  3. Generally Represented with Diagrams[either data flow/e-R Diagrams etc]


2What is LLD And What it contains?

Ans: Low Level Design[LLD]

It contains the below information

  1. Source and its structure
  2. Destination and its structure
  3. Source to Destination business or mapping Rules
  4. To Develop the coding this document Required[Generally Developer use this documents]




23)Most of the organization there maintained LLD Document in excel sheet very few organization in word Doc Format

Ans:  What is mean by unit testing, who is Responsible for that How do you do that?

  1. Testing individual unit of code is called unit testing
  2. It is Responsibility of Developer
  3. Generally we are keeping unit test cases and Result in separate work sheet of excel sheet





2Explain various testing phases in our project?


a)Unit test:

  1. This can also be called white box testing
  2. Individual unit of code tested here
  3. It is developer responsibility

b)System testing[Functional/block box test]

  1. The functionality of the component tested here
  2. It is Responsibility of quality analyst(tester)
  3. User accepting and testing(UAT) End user Testing

Other testing

  1. Silk Testing
  2. Regression Testing
  3. Integration testing


2What is the project life cycle model your using project describe me the steps?

Ans: We are using water fall model other models

V Model

Agile model     Frequently used in real time

Spiral model

Rapid model

Increment model




  1. Requirement Gathering
  2. Analysis
  3. Design
  4. Coding
  5. Testing
  6. Implementation and maintained
  7. SLA Support

SLA=Service Level Agreement


2What is your data ware house model and Approach?

Ans: Our model is “3NF”


àData ware house approach is Top down Approach[WMON Approach]?

Ans: Top down Approach


2How Do you Get the input file what are there size?


  1. Generally we are Getting flat file and client keeps the file in shared derive/location on the server
  2. This file sizes are range MBs To GB

2How do you Get Document HLD,LLD Business etc interview project?

Ans: In my old project we use to get the document through mail in my current project we use to getting from the share point server by using user id, and password


2What do you mean by source system and tell some of source system name?

Ans: It is a name Given to a particular process where the data source in database, this system are input to the  were house





Gold Mind



Do not use the above names in interviews, instead use your corresponding project source system names

It do not the name create/add/put your own name


2What is staging area and how it help for us? where do you have the staging in your project?


  1. An intermediates storage area also be called as stage area.
  2. Generally in between OLATP System data ware housing we have the staging area.

Here having  2 staging in my project

  1. At operating system level Unix
  2. At data ware house system level in tera data





2What are the scheduling tools your using in your project, how are doing scheduling?

Ans: As Developer I am not doing that, my onsite counter part is doing the scheduling.

I heard that they are using, CONTROL-M, for this scheduling


Other scheduling tools

Auto sys


TRILLIUM, CRONTab, AT Commands in union



2How are you maintaining versioning in  your  project?

Ans: We are using PVCS for maintaining Version

PVCS – P Version control system

Other version Tools:


VSS=Visual source safe

Clear case.

Quality center etc





Doc name

creation/conducting modify write date



1Abc.txtVinay,15 Nov 2011Initial Release change date
2Abc.txtMadhu,16 Nov 2011LLD322






  1. There is a scheduled process to get the day to day data from the source system to Unix stage server
  2. From Unix stage to tera data stage actual operations are perform by using BTEQ,FL,ML Information, Data stage
  3. Once stage data base is ready now there is a load from stage 2 actual destination.
  4. During this load if there any exception there moving into error database
  5. Once target data base is ready the reporting people there generates cubes and creating various Reports from inure.