ETL Developer 3 / Concepteur (extraire, transformer, charger) 3 (11903-R)

Location: Edmonton, AB, Canada
Date Posted: 14-09-2018
Description:
Responsible for programming, testing, debugging, and documenting simple to moderately complex ETL applications under direct supervision. Maintains and modifies existing ETL applications and corresponding documentation Develops new ETL applications reports of simple to complex scope, works with basic applications systems design specifications; and utilizes Company standards, procedures, and techniques Creates and maintains effective ETL application documentation Assists in the development of test plans for assigned projects Uses simple to moderately complex debugging techniques to test ETL applications. 

Candidates must have strong communication skills that allow you to regularly deal with the business, as well as with specialists from related fields, including database developers, and software engineers. Candidates must have outstanding analytical and problem solving skills and a good grasp of the technical side of business intelligence and always keep up to date with the latest BI tools and technologies. 

Responsibilities: 
Design, build and deploy effective packages 
Implement stored procedures and effectively query a database 
Understand & implement proper analytics 
Translate requirements from the business and analyst into technical code 
Work with business users to establish reporting and analytic requirements. 
Develop and implement ETL processes, reports and queries in support of business analytics. 
Engage in data architecture design activities. Provide technical recommendations for data warehouse and business analytics 
Develop and implement interactive analytic reports and dashboards. 
Identify and test for bugs and bottlenecks in the ETL solution 
Ensure the best possible performance and quality in the packages 
Provide support and fix issues in existing packages 

Minimum Requirements :
1.       Oracle Developer – Minimum 5 years’ experience (we will revisit this, if the candidate has at least 2 year continuous in Oracle 11g or higher)
a.       Strong SQL experience is a must
2.       Informatica is a minus
3.       Unix Experience (2 years) (shell scripts will be assumed)
4.       Analysis specifically the ability to 
a.       reverse engineer existing processes by reviewing code and data structures
b.      understand relationships between data from various data sources – The ability to “pull out” relationships between related but disparate systems without documentation.
c.       identify and root cause issues from a data perspective
5.       Experience with customer centric systems, would be a plus (telco, power, gas…).  
6.       Good verbal skills. 
7.       The ability to work independently but, know when to ask questions for time management and meeting deadlines
 

Bonus: 
Tableau Development experience 
Hadoop experience

Must to have skills:
1. Design, build and deploy effective packages / 10 Years
2. Implement stored procedures and effectively query a database / 10 Years
3. Bachelor's degree/ Technical Diploma in IT or related major. 10+ years related experience.
4. Excellent knowledge of database design, SQL, data warehousing /10 years
5. Strong knowledge of Oracle PL/SQL /10 years
6. Ability to facilitate meetings and delegate responsibilities.
7. Understand & implement proper analytics / 10 Years
8. Translate requirements from the business and analyst into technical code / 10 Years
9. Work with business users to establish reporting and analytic requirements. / 5 years
10. Develop and implement ETL processes, reports and queries in support of business analytics. /5 years

Nice to have skills:
1. Desirable UNIX, Perl, KORN Shell, CONTROL M-9 /5 years
2. Tableau Development experience / 1 year
3. Hadoop experience /1 year  
or
this job portal is powered by CATS