- Mar 2, 2016
- 2
- Category........
- NOC Code......
- 2172
- Job Offer........
- Pre-Assessed..
- App. Filed.......
- 10-09-2016
- Nomination.....
- No
- AOR Received.
- 4th Dec, 2016
- IELTS Request
- Upfront, R-9, L-9, W-8, S-8.5
- Med's Request
- Upfront
- Med's Done....
- 04-02-2017
- Passport Req..
- 03-27-2017
- VISA ISSUED...
- 04-05-2017
- LANDED..........
- Planning in Oct
Hello,
Applied for FSW and wanted to confirm if my NOC is marked correct. Don't want to get an ITA and get rejected during the processing phase. Based on my work I believe my NOC code should be 2172. Below I will list what NOC - 2172 is according to CIC and then list my various jobs with the corresponding NOC. Pls. confirm and rectify where ever possible.
According to CIC - 2172 is: (I believe I will come under data analyst)
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
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..
"View all Titles" from CIC website (I believe it is mor aligned to data warehouse analyst)
administrator, data
administrator, database
analyst, database
analyst, EDP (electronic data processing)
analyst, electronic data processing (EDP) systems
architect, database
data administrator
data analyst – informatics and systems
data custodian
data dictionary administrator
data miner
data mining analyst
data processing specialist
data warehouse analyst
database administrator (DBA)
database analyst
database analyst
And more in the adjacent link: http://www5.hrsdc.gc.ca/NOC/English/NOC/2011/ViewAllTitlesQuickSearch.aspx?val=2&val1=2172&val65=2172
Below is the NOC I have marked for each job:
1. USA - Internship, May12-Aug12 (as this is foreign full time internship I am counting it towards work experience)
NOC: 2172
Job Title: Student Intern
Description:
- Document requirements for the purpose of report development for the Treasury department
- Understand Treasury data warehouse and communicate changes/enhancements to the model based on the requirements given by the business
- Develop reports using business objects as outlined by the business users
- Write complex SQL queries for data analysis and report creation
- Automate manual tasks using VBA macros
- Communicate and coordinate with the developers on business requirements for new process as well as enhance existing systems
- Perform statistical modeling for recognizing important trends
2. USA, Full time Job, Jan 13-Nov13
NOC: 2172
Job Title: Analyst
Description:
Analyze proprietary data warehouse and create a similar credit card data model for the client
Communicate with the architects and coordinate with the developers to come up with the system design
Develop database structure and also contribute in writing queries that perform DDL and DML
Load raw data files using Perl, Unix and SQL on Vertica platform
Apply SQL optimization and tuning techniques for fast retrieval of data
Process monthly and daily files which involves processing millions of records
Support and develop Perl modules on ad-hoc basis for automation of various processes
Perform ETL using vSQL and Perl and assist in the entire warehouse development cycle
Participate in stakeholder and project review meetings on weekly basis
Monitor and work with the developers to find the root cause of the data related issues
Design and document the test cases for ensuring quality of data and perform thorough validation
Automate activities like spooling, archival and transfer of data using shell scripts and Autosys
Migrate data from development to testing region on Unix environment
Create MDD documents which requires extensive knowledge of clients data fields, required for analytics
Coach other team members and interns on the system architecture and technology
Interact with the client and work onsite to resolve issues and expedite various process in the project
Work extensively on creating mapping document that required knowledge of TSYS and client data model
3. USA, Full time job, Nov13-March14
NOC: 2172
Job Title: Senior BI Systems Analyst
Description: The description that I got from the company is very basic and as follows:
Performed data analysis related to a variety of projects. He also performed basic project management functions.
Have a question here, will the above suffice? I am also planning to attach a letter where I will explain that I did not get a complete list of job responsibilities from the company but I performed the below job function.
· Developed database migration plan for Microsoft SQL Server to Oracle database migration
· Examined reports and pitched ideas for creating new reports/dashboards for better analysis of data
· Created document for visualization best practices and report and dashboard design
· Served as a conduit between the business and development team
· Worked with the project manager, architect and developers to develop the project timeline and plan
· Contributed towards documentation of business requirements for developing new reports
· Served as point of contact for user queries and production issues
· Wrote SQL queries to create proof of concept in oracle database
Should the 2 liner from the company suffice or should I write a letter with the above description?
4. USA, Full time job, March14-Nov14
NOC: 2172
Job Title: Business Analyst
Description:
Conduct user interviews for requirements gathering
Evaluate client needs for analysis; help define business questions; identify data needs
Develop specs and source to target mapping to support ETL process
Help create and articulate relevant solutions
Communicate and collaborate with technical developers and architects on business requirements for new processes as well as enhancements to existing systems
Work with architecture and technical support to design, test and maintain the warehouse
Design data views; help develop reporting data mart and provide support to reporting needs
Create coordinate and implement test plans
Help verify and reconcile data for accuracy and consistency
Ensure knowledge transfer to users
Provide complete and updated documentation; identify training needs
Facilitate meetings, create status reports, communicate with stake holders and/or business users
Ensures test scripts are documented, reported and tracked in appropriate tools
5. USA, Full time, Nov14-March15
NOC: 2172
Job title: Sr. Analyst
Description:
Review clients data warehouse design and suggest improvements for a highly complex mortgage reporting system
Lead data analysis and design of the system by understanding the data lineage and business rules
Write complex SQL queries to carry out the ETL process for creating monthly federal report
Perform thorough validation of the report/business rules by analyzing submitted data
Create artefacts like mapping, modelling specification and business requirements documents
Serve as an SME for the home consumer line of business project track
Interact with the business partners to resolve any outstanding issues
6. USA, Full time, April15-July16
NOC: 2172
Job title: Sr. Systems Analyst
Description/Responsibilities stated in the letter:
Supported implementation and continued evolution of data warehouse
Work collaboratively with business units and technical teams to develop functional specifications
Conduct user interview for requirements gathering
Evaluate client needs for analysis
Identify data needs
Develop specification and source to target mappings to support ETL process
Working with architecture and technical support to design, test, enhance and maintain the warehouse
Facilitate meetings, create status reports, and communicate with stakeholders
Requirements for job given by my company: (This was in current company so got what was required for the job and some description as well)
Experience in supporting design and specification of data presentation and knowledge of reporting, analytics, and trending
Experience in integrating data from multiple source systems is a plus
Requires knowledge and experience in data warehouse (ETL, Star Schema, ODS, OLAP, Dimensional modeling) knowledge and understanding of different data warehouse methodologies preferably Kimball
Oracle, or relational database as well as SQL experience required
Business/systems analyst experience required. Demonstrated experience working with users to identify information systems and reporting needs
Experience identifying potential solutions, designing, developing, documenting, testing and maintaining database/application required
Ability to transform a business need into visual representation
Must be able to verify and reconcile data for accuracy and consistency
Ability to work collaboratively and communicate effectively with disparate clients
Ability to lead or facilitate meetings
Ability to identify potential solutions and take initiative
Must be able to work independently and within a team to handle sensitive data
Able to work on multiple projects concurrently and work within deadlines
6. Full time, Jul16-Present
NOC: 2173
Job Title: Sr. Application developer
Description: May not be able to get it because its my current job that I just enrolled for and it might be a little suspicious to ask for an experience letter. However, I will write a letter explaining my responsibilities
Below was the job requirements:
Work in a team that demands technical excellence, whose members are expected to hold each other accountable for the overall success of the end product. Focus for this team is on the delivery of innovative solutions to complex problems, but also with a mind to drive simplicity in refining and supporting of the solution by others and at the end of the day, trying to help people lead healthier lives.
Qualifications
Qualifications
• Computer Science Degree or equivalent practical experience with Applied Mathematics, Algorithmic Optimization, or Machine Learning, or the equivalent work & educational experience.
• Programming experience in one or more of the following
o Scala (18+ months of it being your primary language)
o Python, Java, language (18+ months working in both)
o Spark, Kafka
o SAS DS2 Hadoop connectivity/accelerator with Hadoop technologies such as Hive, Impala
o SQL PL/SQL
o Oracle, Teradata
o Processing data from various file formats such as xml, json, csv, parquet
o Familiarity working with web development technologies.
• Ability to design and execute on acceptance criteria & success metrics in an Agile development process
• Strong analytical and coding skills
• Comfortable in configuring and using multiple operating systems (Mac/Windows/*nix)
• Knowledge and/or experience with Health care information domains a plus
Would really appreciate inputs from veterans and suggest me any changes to the NOC code. I know its a huge post but had to get this sorted out to avoid future problems.
Thanks!
Applied for FSW and wanted to confirm if my NOC is marked correct. Don't want to get an ITA and get rejected during the processing phase. Based on my work I believe my NOC code should be 2172. Below I will list what NOC - 2172 is according to CIC and then list my various jobs with the corresponding NOC. Pls. confirm and rectify where ever possible.
According to CIC - 2172 is: (I believe I will come under data analyst)
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
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..
"View all Titles" from CIC website (I believe it is mor aligned to data warehouse analyst)
administrator, data
administrator, database
analyst, database
analyst, EDP (electronic data processing)
analyst, electronic data processing (EDP) systems
architect, database
data administrator
data analyst – informatics and systems
data custodian
data dictionary administrator
data miner
data mining analyst
data processing specialist
data warehouse analyst
database administrator (DBA)
database analyst
database analyst
And more in the adjacent link: http://www5.hrsdc.gc.ca/NOC/English/NOC/2011/ViewAllTitlesQuickSearch.aspx?val=2&val1=2172&val65=2172
Below is the NOC I have marked for each job:
1. USA - Internship, May12-Aug12 (as this is foreign full time internship I am counting it towards work experience)
NOC: 2172
Job Title: Student Intern
Description:
- Document requirements for the purpose of report development for the Treasury department
- Understand Treasury data warehouse and communicate changes/enhancements to the model based on the requirements given by the business
- Develop reports using business objects as outlined by the business users
- Write complex SQL queries for data analysis and report creation
- Automate manual tasks using VBA macros
- Communicate and coordinate with the developers on business requirements for new process as well as enhance existing systems
- Perform statistical modeling for recognizing important trends
2. USA, Full time Job, Jan 13-Nov13
NOC: 2172
Job Title: Analyst
Description:
Analyze proprietary data warehouse and create a similar credit card data model for the client
Communicate with the architects and coordinate with the developers to come up with the system design
Develop database structure and also contribute in writing queries that perform DDL and DML
Load raw data files using Perl, Unix and SQL on Vertica platform
Apply SQL optimization and tuning techniques for fast retrieval of data
Process monthly and daily files which involves processing millions of records
Support and develop Perl modules on ad-hoc basis for automation of various processes
Perform ETL using vSQL and Perl and assist in the entire warehouse development cycle
Participate in stakeholder and project review meetings on weekly basis
Monitor and work with the developers to find the root cause of the data related issues
Design and document the test cases for ensuring quality of data and perform thorough validation
Automate activities like spooling, archival and transfer of data using shell scripts and Autosys
Migrate data from development to testing region on Unix environment
Create MDD documents which requires extensive knowledge of clients data fields, required for analytics
Coach other team members and interns on the system architecture and technology
Interact with the client and work onsite to resolve issues and expedite various process in the project
Work extensively on creating mapping document that required knowledge of TSYS and client data model
3. USA, Full time job, Nov13-March14
NOC: 2172
Job Title: Senior BI Systems Analyst
Description: The description that I got from the company is very basic and as follows:
Performed data analysis related to a variety of projects. He also performed basic project management functions.
Have a question here, will the above suffice? I am also planning to attach a letter where I will explain that I did not get a complete list of job responsibilities from the company but I performed the below job function.
· Developed database migration plan for Microsoft SQL Server to Oracle database migration
· Examined reports and pitched ideas for creating new reports/dashboards for better analysis of data
· Created document for visualization best practices and report and dashboard design
· Served as a conduit between the business and development team
· Worked with the project manager, architect and developers to develop the project timeline and plan
· Contributed towards documentation of business requirements for developing new reports
· Served as point of contact for user queries and production issues
· Wrote SQL queries to create proof of concept in oracle database
Should the 2 liner from the company suffice or should I write a letter with the above description?
4. USA, Full time job, March14-Nov14
NOC: 2172
Job Title: Business Analyst
Description:
Conduct user interviews for requirements gathering
Evaluate client needs for analysis; help define business questions; identify data needs
Develop specs and source to target mapping to support ETL process
Help create and articulate relevant solutions
Communicate and collaborate with technical developers and architects on business requirements for new processes as well as enhancements to existing systems
Work with architecture and technical support to design, test and maintain the warehouse
Design data views; help develop reporting data mart and provide support to reporting needs
Create coordinate and implement test plans
Help verify and reconcile data for accuracy and consistency
Ensure knowledge transfer to users
Provide complete and updated documentation; identify training needs
Facilitate meetings, create status reports, communicate with stake holders and/or business users
Ensures test scripts are documented, reported and tracked in appropriate tools
5. USA, Full time, Nov14-March15
NOC: 2172
Job title: Sr. Analyst
Description:
Review clients data warehouse design and suggest improvements for a highly complex mortgage reporting system
Lead data analysis and design of the system by understanding the data lineage and business rules
Write complex SQL queries to carry out the ETL process for creating monthly federal report
Perform thorough validation of the report/business rules by analyzing submitted data
Create artefacts like mapping, modelling specification and business requirements documents
Serve as an SME for the home consumer line of business project track
Interact with the business partners to resolve any outstanding issues
6. USA, Full time, April15-July16
NOC: 2172
Job title: Sr. Systems Analyst
Description/Responsibilities stated in the letter:
Supported implementation and continued evolution of data warehouse
Work collaboratively with business units and technical teams to develop functional specifications
Conduct user interview for requirements gathering
Evaluate client needs for analysis
Identify data needs
Develop specification and source to target mappings to support ETL process
Working with architecture and technical support to design, test, enhance and maintain the warehouse
Facilitate meetings, create status reports, and communicate with stakeholders
Requirements for job given by my company: (This was in current company so got what was required for the job and some description as well)
Experience in supporting design and specification of data presentation and knowledge of reporting, analytics, and trending
Experience in integrating data from multiple source systems is a plus
Requires knowledge and experience in data warehouse (ETL, Star Schema, ODS, OLAP, Dimensional modeling) knowledge and understanding of different data warehouse methodologies preferably Kimball
Oracle, or relational database as well as SQL experience required
Business/systems analyst experience required. Demonstrated experience working with users to identify information systems and reporting needs
Experience identifying potential solutions, designing, developing, documenting, testing and maintaining database/application required
Ability to transform a business need into visual representation
Must be able to verify and reconcile data for accuracy and consistency
Ability to work collaboratively and communicate effectively with disparate clients
Ability to lead or facilitate meetings
Ability to identify potential solutions and take initiative
Must be able to work independently and within a team to handle sensitive data
Able to work on multiple projects concurrently and work within deadlines
6. Full time, Jul16-Present
NOC: 2173
Job Title: Sr. Application developer
Description: May not be able to get it because its my current job that I just enrolled for and it might be a little suspicious to ask for an experience letter. However, I will write a letter explaining my responsibilities
Below was the job requirements:
Work in a team that demands technical excellence, whose members are expected to hold each other accountable for the overall success of the end product. Focus for this team is on the delivery of innovative solutions to complex problems, but also with a mind to drive simplicity in refining and supporting of the solution by others and at the end of the day, trying to help people lead healthier lives.
Qualifications
Qualifications
• Computer Science Degree or equivalent practical experience with Applied Mathematics, Algorithmic Optimization, or Machine Learning, or the equivalent work & educational experience.
• Programming experience in one or more of the following
o Scala (18+ months of it being your primary language)
o Python, Java, language (18+ months working in both)
o Spark, Kafka
o SAS DS2 Hadoop connectivity/accelerator with Hadoop technologies such as Hive, Impala
o SQL PL/SQL
o Oracle, Teradata
o Processing data from various file formats such as xml, json, csv, parquet
o Familiarity working with web development technologies.
• Ability to design and execute on acceptance criteria & success metrics in an Agile development process
• Strong analytical and coding skills
• Comfortable in configuring and using multiple operating systems (Mac/Windows/*nix)
• Knowledge and/or experience with Health care information domains a plus
Would really appreciate inputs from veterans and suggest me any changes to the NOC code. I know its a huge post but had to get this sorted out to avoid future problems.
Thanks!
