Wednesday, 31 July 2024
Thursday, 30 November 2023
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
Wednesday, 6 October 2021
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.
Friday, 1 October 2021
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
Subscribe to:
Posts (Atom)