本文发表在 rolia.net 枫下论坛俺上篇文章说，网页前台开发比较容易入门。今天在 indeed 看到一个 Junior SQL Programmer 的工作，俺想起来数据库应用也比较容易入门。
数据库应用就是通过软件包来搞数据分析。常用的软件包有 Cognos，DataStage，Informatica。俺认识一个人，本地计算机毕业。上班被雷后，看到一个要求 DataStage 的工作。他找到一个 DataStage 的盗版软件，自己在家里捣鼓了一个礼拜，就通过了面试。那是好几年以前的事了，据说该同志从那以后一直在靠 DataStage 吃饭。
俺个人觉得做数据分析，市场需求量还是很大的，前景也不错。不过俺不是做这一行的，说错了大家不要扔砖。
数据分析其实里面划分的可能很细。比如有些人专门做报表，有些人专门做 ETL。ETL 是 Extract，Transform，Load 的缩写，翻译成汉语就是把数据从各个渠道拿过来，捣鼓捣鼓，再放到公司自己专用的数据库里。很多做数据库应用的，其实就是做 ETL。俺也经常能看到 ETL 的招工广告。
做数据库应用，肯定要会 SQL。俺以前文章里说过，SQL 入门，几个小时就行了。不过那是针对入门的 Java 工作。如果专门做数据库，俺觉得还需要一些 advanced 的 SQL, 外加一些数据库的理论和应用知识。再加上学会一个程序包，俺估摸着要一两个月时间。
做数据库应用，最好是自己捣鼓捣鼓数据库。市场上最流行的数据库是 Oracle 的 Oracle 和微软的 SQL Server。俺记得以前 Oracle 是有免费的学生版本的，SQL Server 可能也有。如果没有，可以用完全免费的 MySQL。MySQL 虽然免费，但是并不山寨。它的 owner 是 Oracle，用户包括很多大公司。
做 SQL 开发，一个流行的软件是 Oracle 的 SQLDeveloper，功能很强，很好用，而且完全免费。很多 Java 码工都喜欢用。
Junior SQL Programmer
Corp Support - Mississauga, ON
Team Description
Our client, a large Canadian company, is currently seeking to fill a contract, full-time Junior SQL Programmer position to provide support within the client’s market analytics team. You will be responsible for extracting and aggregating data with database management tools from various sources to derive critical insights for targeted decisions by our clients. Working in a fast-paced environment, candidates will be provided with the chance to enhance their own skills, learning from industry leaders, while participating in seminars that will compliment your experience and allow you to grow within our team.
Job Description/Main Responsibilities
Analyze, design, and implement data including coding, testing, debugging, and documentation
Assist in the development of analytical techniques and data quality monitoring
Responsible for data extraction, systems expertise, and data manipulation techniques, supporting analysis and other business requirements
Identify opportunities to automate data analysis to increase efficiencies and enhance data accessibility and quality
Communicate status, risks, constraints, and dependencies to the project manager
Understand client and business requirements to provide support and deliver accurate information
Meet strict timelines for deliverables
Pulling data from databases to be used in cross-functional work
Cross-functional support, i.e. provide feedback/critique for projects
Qualifications
University degree in Statistics/Mathematics, Applied Mathematics, Computer Science, or related technical fields
Knowledge of SQL programming in MS SQL Server 2008
Understanding of data structure and quality assurance processes
Experience with other programming languages, such as VB, C++, Java would be beneficial
Possess excellent communication and relationship building skills that promote trust among colleagues and clients
Be able to participate in analysis and design sessions, possessing strong analytical and problem solving skills
Ability to manage changing priorities, multi-tasks, and work with minimal supervision
Advanced computer skills: MS Office (Excel, PowerPoint), MS Access
Familiar with technology, regulatory, socio-economic and business trends in ICT sector
Bilingual (English/French) would be considered an asset
To apply please reply to this posting with your cover letter and resume and include Junior SQL Programmer in the objective statement. Only those candidates selected to continue with the recruitment process will be contacted. We are an equal opportunity employer.更多精彩文章及讨论，请光临枫下论坛 rolia.net
数据库应用就是通过软件包来搞数据分析。常用的软件包有 Cognos，DataStage，Informatica。俺认识一个人，本地计算机毕业。上班被雷后，看到一个要求 DataStage 的工作。他找到一个 DataStage 的盗版软件，自己在家里捣鼓了一个礼拜，就通过了面试。那是好几年以前的事了，据说该同志从那以后一直在靠 DataStage 吃饭。
俺个人觉得做数据分析，市场需求量还是很大的，前景也不错。不过俺不是做这一行的，说错了大家不要扔砖。
数据分析其实里面划分的可能很细。比如有些人专门做报表，有些人专门做 ETL。ETL 是 Extract，Transform，Load 的缩写，翻译成汉语就是把数据从各个渠道拿过来，捣鼓捣鼓，再放到公司自己专用的数据库里。很多做数据库应用的，其实就是做 ETL。俺也经常能看到 ETL 的招工广告。
做数据库应用，肯定要会 SQL。俺以前文章里说过，SQL 入门，几个小时就行了。不过那是针对入门的 Java 工作。如果专门做数据库，俺觉得还需要一些 advanced 的 SQL, 外加一些数据库的理论和应用知识。再加上学会一个程序包，俺估摸着要一两个月时间。
做数据库应用，最好是自己捣鼓捣鼓数据库。市场上最流行的数据库是 Oracle 的 Oracle 和微软的 SQL Server。俺记得以前 Oracle 是有免费的学生版本的，SQL Server 可能也有。如果没有，可以用完全免费的 MySQL。MySQL 虽然免费，但是并不山寨。它的 owner 是 Oracle，用户包括很多大公司。
做 SQL 开发，一个流行的软件是 Oracle 的 SQLDeveloper，功能很强，很好用，而且完全免费。很多 Java 码工都喜欢用。
Junior SQL Programmer
Corp Support - Mississauga, ON
Team Description
Our client, a large Canadian company, is currently seeking to fill a contract, full-time Junior SQL Programmer position to provide support within the client’s market analytics team. You will be responsible for extracting and aggregating data with database management tools from various sources to derive critical insights for targeted decisions by our clients. Working in a fast-paced environment, candidates will be provided with the chance to enhance their own skills, learning from industry leaders, while participating in seminars that will compliment your experience and allow you to grow within our team.
Job Description/Main Responsibilities
Analyze, design, and implement data including coding, testing, debugging, and documentation
Assist in the development of analytical techniques and data quality monitoring
Responsible for data extraction, systems expertise, and data manipulation techniques, supporting analysis and other business requirements
Identify opportunities to automate data analysis to increase efficiencies and enhance data accessibility and quality
Communicate status, risks, constraints, and dependencies to the project manager
Understand client and business requirements to provide support and deliver accurate information
Meet strict timelines for deliverables
Pulling data from databases to be used in cross-functional work
Cross-functional support, i.e. provide feedback/critique for projects
Qualifications
University degree in Statistics/Mathematics, Applied Mathematics, Computer Science, or related technical fields
Knowledge of SQL programming in MS SQL Server 2008
Understanding of data structure and quality assurance processes
Experience with other programming languages, such as VB, C++, Java would be beneficial
Possess excellent communication and relationship building skills that promote trust among colleagues and clients
Be able to participate in analysis and design sessions, possessing strong analytical and problem solving skills
Ability to manage changing priorities, multi-tasks, and work with minimal supervision
Advanced computer skills: MS Office (Excel, PowerPoint), MS Access
Familiar with technology, regulatory, socio-economic and business trends in ICT sector
Bilingual (English/French) would be considered an asset
To apply please reply to this posting with your cover letter and resume and include Junior SQL Programmer in the objective statement. Only those candidates selected to continue with the recruitment process will be contacted. We are an equal opportunity employer.更多精彩文章及讨论，请光临枫下论坛 rolia.net