NOC 2172 FSW/PR VISA holders and also people who are waiting for visa stamping

[MDV]

NOC 2172

This thread is started for all those people who have got FSW visa and are looking for jobs in NOC 2172 stream.Also people who have completed medicals and waiting for visa stamping can also join here

Share your preparations and experiences here.

Networking will help us find our dream jobs

 

[MDV]

Re: NOC 2172 FSW/PR VISA holders

2172 Database analysts and data administrators

Database analysts design, develop and administer data management solutions using database management software. Data administrators develop and implement data administration policy, standards and models. They are employed in information technology consulting firms and in information technology units throughout the private and public sectors.

Example Titles

data administrator
data custodian
data dictionary administrator
data warehouse analyst
database administrator (DBA)
database analyst
database architect
technical architect – database

View all titles

Main duties


Database analysts perform some or all of the following duties:
Collect and document user requirements
Design and develop database architecture for information systems projects
Design, construct, modify, integrate, implement and test data models and database management systems
Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of database management tools
Operate database management systems to analyze data and perform data mining analysis.
May lead, co-ordinate or supervise other workers in this group.

Data administrators perform some or all of the following duties:
Develop and implement data administration policy, standards and models
Research and document data requirements, data collection and administration policy, data access rules and security
Develop policies and procedures for network and/or Internet database access and usage and for the backup and recovery of data
Conduct research and provide advice to other information systems professionals regarding the collection, availability, security and suitability of data
Write scripts related to stored procedures and triggers
May lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models.

Employment requirements

A bachelor's degree, usually in computer science or in mathematics
or
Completion of a college program in computer science is usually required.
Computer programming experience is usually required.

 

[Chinna_FSW]

Dear MDV,

Good initiative
Count me in. I'm waiting for PPR !!

Cheers !!

 

[MDV]

Great China_Fsw

I have been advised by some mentors to complete as many technical certifications as possible before we arrive in Canada.

Data work is in demand in Canada like in the world now so certification around data will help.

 

[MDV]

Cover letter and 2 Page CV is mandatory in Canada

 

[RanjitNagi]

Cover letter and 2 Page CV is mandatory in Canada

Do you have sample resume for DBA which should be valid in canada?

 

[MDV]

Questions Employers SHOULD NOT

Ask in a Job Interview
1. Do you have health problems?
Disabilities?
2. When was the last time you
were hospitalized?
3. Do you have AIDS?
4. Have you ever been addicted
to drugs?
5. How old are you?
6. Do you have children? How old
are they?
7. What church are you a member of?
Do they prevent you from working
weekends and holidays?
8. What’s your sexual orientation?
9. Are you married, divorced,
separated or single?
10. Were you ever arrested?

 

[MDV]

Do you have sample resume for DBA which should be valid in canada?

You have optimal resume account it has I guess have a look I had checked some samples.

 

[NILESHRM]

Hi

I m 2172 applicant from India

medical completed this week and waiting for DM/PPR now

some questions -

are there more jobs in DB in oracle side or MS SQL server side?

all my exp. in MS SQL server only, no oracle exp, but I can learn it of course

also, does it help to acquire new skill in informatica, cognos or like that other new skills Hadoop

or should I refine my MS SQL and oracle skills?

 

[MDV]

Hi

I m 2172 applicant from India

medical completed this week and waiting for DM/PPR now

some questions -

are there more jobs in DB in oracle side or MS SQL server side?

all my exp. in MS SQL server only, no oracle exp, but I can learn it of course

also, does it help to acquire new skill in informatica, cognos or like that other new skills Hadoop

or should I refine my MS SQL and oracle skills?

I see from my research there are ms sql server jobs .If you want to add any new skill it has to be around big data technologies as there is demand for data analytics professionals.

Hadoop, Mongo DB, R programming and SAS are the courses I would recommend now if you are interested to add few.

These are the highest paid skills in the world now.

 

[ellynguyen]

Hi All,
Please count me in, I'm waiting for MR

Best of luck on finding your jobs

 

[R_J]

Hi Guys,

Good to see a thread for 2172 applicants.

My timeline

Application Date: 21st Nov
DD En cashed: 17th Jan
Current Status: IN PROGRESS (As per the UCI# provided to me)
AOR: 25th March (File transferred to colombo visa office)


waiting for MR..

 

[psk_270185]

Hi All

I have received COPR in March. Is it worth taking the risk of going to Canada? How long it will take for me to find a decent job in Canada? i have experience in Data warehousing in Banking domain.

 

[MDV]

Hi All

I have received COPR in March. Is it worth taking the risk of going to Canada? How long it will take for me to find a decent job in Canada? i have experience in Data warehousing in Banking domain.

Yes bro Banking is big here infact alll the IT consultants you see mostly will be working for banks .

You should pack your bags and prepare a tailored made cv and start applying for jobs and get you local number .

Dont waste your time thinking too much.

 

[alok4best]

Yes bro Banking is big here infact alll the IT consultants you see mostly will be working for banks .

You should pack your bags and prepare a tailored made cv and start applying for jobs and get you local number .

Dont waste your time thinking too much.

From what I have seen online, there looks to be decent oppertunities for SQL and BI professionals.
As you have already pointed out, I would also suggest everyone to get a Local number and start applying while you are still in native country.
You can get the calls to that number forwarded to gmail or skype.

Also, make sure you have your linkedIn profiles updated.

MDV, apart from job portals like Workpolis or Indeed, are you aware of any recruitment firms of consultancies, which might help job search on a more personal level.