Description:
DWH ETL consultant
Our Client
Our client is a global leader in data warehouse field. The Global Consulting Centre in Prague is providing its consultants to the largest and most sophisticated data warehouse (DWH) projects across EMEA region as for example in Austria, Italy, Sweden, Russia, Czech Rep, etc.
We are looking for consultants performing various BI or ETL analyses; implementing database design & ETL solutions, developing SQL stored procedures, providing SQL tuning and optimization and creating of BI reports and services.
Key Responsibilities
§ Performing data warehouse ETL tasks for large projects (ETL development, stored procedures development, SQL optimization);
§ Building data warehouse (DWH) competency;
§ Deliver business and application specific consulting services included in the integrated Teradata solutions;
§ Support and monitor ETL jobs;
§ Supporting the pre-sale process as well as client communication;
Knowledge and Skills
§ Minimal 1 year of experience in DWH projects or in IT companies;
§ Good understanding of ETL concepts and DWH architecture;
§ SQL knowledge;
§ Experience with database systems such as Teradata, Oracle or MSSQL in similar position (stored procedures development, DDL scripts, DML scripts);
§ Willingness to travel and to relocate to Prague (Czech Rep.) ;
§ Advanced English;
§ EU Citizenship;
Advantages:
§ Proven record of participation on bigger DWH projects;
§ Knowledge of any ETL tool (Informatica, Datastage or Ab-Initio);
§ Experience with Teradata Tools and Utilities (FastLoad, MultiLoad, BTEQ, FastExport);
§ Proficient in UNIX, Shell or Linux;
§ Knowledge of any other European language (eg. German, Italian, French or Russian);
Skills & Attributes
§ Strong problem solving skills
§ Excellent oral and written communication skills
§ Self-directed and keen on learning
§ Experienced in customer interaction;
§ Strong problem solving skills and optimization technique
§ Interested in DWH field
§ Team Player;
Compensation and Benefits
Pension plan including company contributions (after probationary period)
Medical plan (Kardia) covering outpatient care (but not hospitalisation)
Lunch vouchers in amount of 80 CZK for each day worked
Business travel insurance for 24/7
Company credit card (Amex)
5 weeks of holiday
Company´s contribution during sickness
Lucrative working environment
Notebook as a working tool
When travelling, additionally to per-diems “bonus cash” during first 21 days
13th salary + bonuses on the project
Possibility of travelling within EMEA
Information summary
|
Working location:
|
Prague
|
|
Type of employment:
|
Full-time work
|
|
Length of contract:
|
Permanent
|
|
Type of employment:
|
Employment contract
|
|
Required education:
|
University degree preferred (BA, MA, Doctoral) / ...
|
|
Required languages:
|
Czech and English, plus advantageous French / German / Italian / Spanish / ...
|
Contact information
|
Contact person:
|
Petra Klímová
|
|
E-mail:
|
Petra.klimova@cpljobs.cz
|
|
Phone:
|
+420 221 773 611
|