Click here number

 

Click Here Show Number

Thank you!

New Job Vacancy

 1.Company Name: MNC Company ( Bike, Cars Parts Manufacturing)

Department: Production

Qaulification: 10th/12th/ITI/ Diploma/B.E

Job Role: Trainee

Experience: Freshers and Experiences

No of Vacancy: 

Gender: Male Only

Age Limit: 18 - 30

Salary: 14000 to 18000

Other Benefits: Free Food

Work Hours: 8hrs 3 rotational shift

Shift Timings:

Interview Date: 28-11-2023 to 30-11-2023 at 8am

Company Address or Location:Vellapanchavadi, chennai

Contact Number:

Click here

9361214609, 7200229697

2.Company Name: Automobile MNC Company ( Bike, Cars Parts Manufacturing)

Department: Production

Qaulification: 10th/12th/ITI/ Diploma/B.E/any degree

Job Role: Trainee

Experience: Freshers and 1 YEAR Experiences

No of Vacancy: 

Gender: Male Only

Age Limit: 18 - 30

Salary: 14000 CTC

Other Benefits: Free Food, ESI, PF

Work Hours: 8hrs 3 rotational shift

Shift Timings:

Interview Date: 

Company Address or Location: Urappakkam, chennai

Contact Number:9840283252

3.Company Name: MNC Company ( Bike, Cars Parts Manufacturing)

Department: Production

Qaulification: Diploma (pass/fail)

Job Role: Trainee

Experience: Freshers and 1 YEAR Experiences

No of Vacancy: 

Gender: Male Only

Age Limit: 18 - 24

Salary: 16000 CTC

Other Benefits: Free Food, Transport, ESI, PF, 

Work Hours: 8hrs 3 rotational shift

Shift Timings:

Interview Date: 

Company Address or Location: Oragadam, chennai

Contact Number:8925910068

4.Company Name: Two Spare parts Manufacturing

Department:

Qaulification: 10th to any degree

Job Role: Trainee

Experience: Freshers and 1 YEAR Experiences

No of Vacancy: 

Gender: Male Only

Age Limit: 18 - 32

Salary: 16000  to 18000 and attendance bonus 1000

Other Benefits: Free Food,  65km Transport free

Work Hours: 8hrs 3 rotational shift

Shift Timings:

Interview Date: 

Company Address or Location: Oragadam, chennai

Contact Number: 9943008078, 9585916818

5.Company Name: Auto Components Manufacturing

Department: Production

Qaulification: 10th to any degree

Job Role: Trainee

Experience: Freshers and 3 YEAR Experiences

No of Vacancy: 30 direct joining, no interview

Gender: Male Only

Age Limit: 18 - 32

Salary: 18200 take salary

Other Benefits: Free Food,  Low price room , Salary increament

Work Hours: 8hrs 3 rotational shift

Shift Timings:

Interview Date: 

documents:need

Company Address or Location: Oragadam, chennai

Contact Number: 6380386202, 7200671273

Click text

What is the Data migration process?, Data Migrated Source to Data Warehouse

What is the Data migration process?

1. Requirements will come as RSD (Requirement Specification Document)

2. RSD document will be shared with Both dev and SIT team

3. Dev Team will start the Developments, SIT (our team) will start with the test plan and test case preparation, mapping document preparations.

 

The reason for the source stage is 

Files can be a data source 

• We can load the file data into the database table, it will happen in the source stage 

Data may from multiple databases 

• 10 tables have to be migrated then

• 5 of them coming from MySQL database 

• 5 of them coming from the oracle database 

• We can merge all into the source stage 

Source stage is not needed, when we're receiving cleansed data and data is from single source 

No cleansed data is 

Like internet provided in the 100mbps of speed and limit of 1000 GB 

Like internet provided in the 100M of speed and limit of 1000G

Like internet provided in the 100M- 1000 GB 

This data has to go to target as 

For speed, column 100

For limit column 1000

1. If Source is a file then, the Source stage will be there

2. In this case file data will load to the source stage environment 

3. From the Source stage data will be migrated to the target stage 

4. In that target stage data has to be validated by the ETL testers 

5. If the ETL tester is given a green signal, then(sign off), data will be migrated to Target DB.

ETL Architecture Explaination

 

·         ETL Architecture

•  ETL is Extract Transformation and Load

•  Extracting the data from the OLTP environment and transforming the data into the ETL tools and    Loading the data into the OLAP environment

• OLTP can have multiple data sources called flat files and Databases and also legacy systems like DB2, mainframe databases

•  ETL will have a Source area and staging area and Landing area

• The source will be OLTP Db or else files

• The stage will be any of the RDBMS databases

• Target will be a database ( RDBMS)

• OLAP target will be designed like fact table and dimension table types and created as snowflake or star schema design.

OLAP Vs OLTP

OLTP

1. OLTP is a data source it can be a flat file or database 

2. It contains normalized data and current year data 

3. It contains regular transaction data 

OLAP 

• OLAP  will contain historical data and it must be a database 

• IT contains denormalized data and a huge volume of data 

• BI – reports will run on OLAP environment 

• OLAP will be a data source of an ETL process 

IT Industry Environment Details | What Will Do Every Department In IT Industry - Basics Of IT Industry

 Environment details

• DEV
• SIT
• UAT
• PROD

For Front end and back end developers, below environment is common

Dev  -  Development Environment 

it is used for development of the code – Developer will have full access for this environment – developers will do the development here – Developer will test the functionality which you developed here (that is called UNIT TESTING)

If unit testing is OK then Code will be promoted to SIT environment

Development will happen in Separate database (separate schema as well)

 

SIT   -  System Integration Testing (Our Environment)

Professional testers will test the functionality which is working or not,

They will understand the functionality and as per their plan they will execute some test cases

If any failures occurs then, code will send back to the dev team.

If everything is OK then, Code will promote to the UAT environment. 

SIT will happen in Separate database (separate schema as well)                  

For SIT database we will not have any DML / DDL privs / We can select the data from the database.

We can't modify anything in SIT

 

UAT – User acceptance Test

Environment is accessed by customers (End users)

Customer will test the functionality with their inputs.

In case of issues then, code will send back to SIT team

If everything is OK then, Code will promote to PROD

It will be in Separate DB – Separate Schema

We can’t access the data, some of them from our dev team can access the data

But any case, we can’t perform any DML / DDL in this environment.

 

PROD  - Production

High secured environment

We can’t perform any DDL / DML here

We can select the data, in case of any production issues validations

It will be in Separate DB – Separate Schema

TOP 12 ETL Testing Interview Questions and Answers 2021

1. What is ETL 

Answer: An ETL tool extracts the data from these heterogeneous data source, transform the data like applying some calculation, joining fields, keys, removing incorrect data fields etc. and a load it into a data warehouse.

2. What is the difference between ETL tool and OLAP tools 

Answer:

ETL tool is meant for extraction data from the legacy systems and load into specified database with some process of cleansing data X Informatica data stage OLAP is meant for reporting purpose in OLAP data available in multi-directional model so that you can write simple query to extract data from the database X Business Objects Cognos 

3. What is odes operation data source 

Answer: ODS operational data store ODS comes between staging area and data warehouse the data is ODS will be at the low level of granularity once data was populated in ODS aggregated data will be loaded into EDW through ODS. 

4. Where do we use connected and unconnected lookups 

Answer: if returned port only 1 then we can go for unconnected more than 1 returned port is not possible with unconnected if more than one returned port then go for connected if you require dynamic cache an ie where your data will change dynamically then you can go for connected lookup if your data is static where your data won't change when the session loads you can go for unconnected lookups.

5. Where do we use semi and non-additive facts 

Answer: Additive a measure can participate arithmetic calculations using all or any dimensions semi additive a measure can participate arithmetic calculations using some dimensions non-additive a measure can't participate arithmetic calculations using dimensions.

6. What is the latest version of power center power Mart? 

Answer: the latest version is 7.2 

7. What are the modules in power Mart? 

Answer: Power mod designer server manager repository manager. 

8. what are active transformation, passive transformations? 

Answer: active transformation can change the number of rows that pass through it decrease or increase rows passive transformation cannot change the number of rows that pass through it 

9. What are the different lookup methods used in Informatica 

Answer: connected lookup connected look up will receive input from the pipeline and sends output to the pipeline and can return any number of values it does not contain return port unconnected lookup can return only one column it contained return port 

10. Can Informatica load heterogeneous targets from heterogeneous sources 

Answer: nor in Informatica 5.2 and yes in Informatica 6.1 and later 

11. How do we call shell scripts from Informatica 

Answer: specify the full path of the shell script a post session properties of session workflow.

12. what is Informatica metadata and where its stored. 

Answer: Informatica metadata is data about data which stores in Informatica repositories.