My Title is SQL BI Developer , Can anyone help me with NOC Code

[Kpkumar713]

Can I someone please help me clarifying my noc:
Design, develop and support databases, data marts, data dictionaries and metadata repositories
Lead data preparation activities including exploration, cleansing, validation, integration, transformation, and aggregation of data
Design and implement technical enhancements to the enterprise data warehouse, including database design, ETL processes, access and security
Develop of ETL processes and re-usable packages according to standards reflecting industry-specific best practices
Develop SQL queries and complex SQL joins, triggers and stored procedures
Participate in the analysis and resolution of issues related to information content, data integrity, integration, and performance
Conduct proactive database monitoring to identify performance improvement opportunities
Work as part of an application development team; create structured code for integration into larger systems, as well as documentation for ongoing maintenance in production environments
Work closely with Data Architects, Project Managers, Quality Assurance Analysts and Business Intelligence Consultants
Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts

 

[isenhiem]

Hey Kumar....could you let me know which NOC did u use to apply. I heard NOC 2172 has been rejected for some ETL/BI/DATA WAREHOUSE developers. I am guessing 2173 would be the most appropriate. Any help would be much appreciated.

Thanks

 

[Kpkumar713]

Hi , I have used the NOC code 2172 as I am BI developer and I haven’t seen any cases which got rejected based on the noc codes.. most of the cases I see are based on the POF

 

[isenhiem]

Hi , I have used the NOC code 2172 as I am BI developer and I haven’t seen any cases which got rejected based on the noc codes.. most of the cases I see are based on the POF

Thanks for the quick response Kumar. Really appreciate your time. I am an Informatica developer and the reason I am a bit skeptical about 2172 as its mostly for Database analyst and database administrator. Also here is the link I was referring to earlier:

https://www.canadavisa.com/canada-immigration-discussion-board/threads/refusal-letter-for-canada-immigration.543140/

But nonetheless I have also heard that if the job responsibilities match the NOC to about 70% then we can include a letter of explanation to inform why we chose that NOC. Do let me know your thoughts and has which stage of the application process are you in right now?

Thanks a lot.

 

[anshad.ca]

Hello All - For those whose applications has already been processed may I know which NOC should I choose for ETL Developer - Informatica . I am assuming NOC 2172. Please provide your inputs.

Thanks.

 

[Kpkumar713]

Go with 2172..

 

[anshad.ca]

Go with 2172..

Thank you !

 

[Uniquehelp]

Hi all, I worked in a MNC and started my career with them as a Associate System Engineer and later on got promted as a Application Developer. I worked with the company for 5 years and 3 months. My primary role was there to take care of development and support of OBIEE reports and ETL workflows. OBIEE is a Oracle BI tool. I am little confused that which noc code I should use according to NOC code version 2021.

Also the reliving /experience letter which I had receieved from my previous company does not mention anything about my job duties, they just mentioned my employee id, start date, end date, full time employment and last position I held in the organization. And this is there standard template that company used for any experience letter.

Now I have few below questions, and if anyone can answer or give me some suggestions:

1. Can anyone suggest me, do I need to get the new job letter from my employer with all job duties written on that or I can use the existing standard document and attach the letter of explanation (LOA) with my file?

2. My last job title was Application Developer but I was like doing more of like BI report development kind of work, so which below NOC code should I use for my filing:
NOC 21221 - Business System Specialists,
NOC 21232 - Software Developers and Programmers.
NOC 21234 - Web Designers and Programmers

3. If I request my Indian employer which is a MNC, to give me a new experience letter with job duties. Is it okay to have job duties different then the job title, like job Title : Application Developer and Job duties: Business System Analyst (NOC code 21221)

4. Another question, that in Canada I have worked in mutiple NOC codes, like 8 months worked on NOC code - 21234 ( with Job Title: Web Application Developer) and 4 months NOC code - 21221 ( with Job Title: Power BI Technical Support Engineer), so now my question is should I mention that I have worked on mutiple NOC codes or not? Any suggestion or recommendations if appreciable?

5. Last question, 8 months of experience which I have as a Web Application Developer in Canada, for that I have just Record of Employment, and a experience letter with no end date written on that. My employer is refusing to give me the letter with end date written on that and saying you can use ROE only. Employer is not supportive, but I have all the paychecks and Offer letter also. Any suggestion or advise if highly appreciable.

Thank you to all if you read my situation and suggest me some solutions or recommendations.

 

[Uniquehelp]

Hi all, I worked in a MNC and started my career with them as a Associate System Engineer and later on got promted as a Application Developer. I worked with the company for 5 years and 3 months. My primary role was there to take care of development and support of OBIEE reports and ETL workflows. OBIEE is a Oracle BI tool. I am little confused that which noc code I should use according to NOC code version 2021.

Also the reliving /experience letter which I had receieved from my previous company does not mention anything about my job duties, they just mentioned my employee id, start date, end date, full time employment and last position I held in the organization. And this is there standard template that company used for any experience letter.

Now I have few below questions, and if anyone can answer or give me some suggestions:

1. Can anyone suggest me, do I need to get the new job letter from my employer with all job duties written on that or I can use the existing standard document and attach the letter of explanation (LOA) with my file?

2. My last job title was Application Developer but I was like doing more of like BI report development kind of work, so which below NOC code should I use for my filing:
NOC 21221 - Business System Specialists,
NOC 21232 - Software Developers and Programmers.
NOC 21234 - Web Designers and Programmers

3. If I request my Indian employer which is a MNC, to give me a new experience letter with job duties. Is it okay to have job duties different then the job title, like job Title : Application Developer and Job duties: Business System Analyst (NOC code 21221)

4. Another question, that in Canada I have worked in mutiple NOC codes, like 8 months worked on NOC code - 21234 ( with Job Title: Web Application Developer) and 4 months NOC code - 21221 ( with Job Title: Power BI Technical Support Engineer), so now my question is should I mention that I have worked on mutiple NOC codes or not? Any suggestion or recommendations if appreciable?

5. Last question, 8 months of experience which I have as a Web Application Developer in Canada, for that I have just Record of Employment, and a experience letter with no end date written on that. My employer is refusing to give me the letter with end date written on that and saying you can use ROE only. Employer is not supportive, but I have all the paychecks and Offer letter also. Any suggestion or advise if highly appreciable.

Thank you to all if you read my situation and suggest me some solutions or recommendations.