Position: Middle ETL Developer
Company: SoftServe
Category: SQL
Experience required: 2y
English level: intermediate

WE ARE

We are the team of professionals who create high quality software product by working with cutting-edge technologies.  Our client is one of  the largest Canadian retail companies which sells a wide range of automotive, hardware, sports and leisure, and home products. Our super friendly and collaborative team will help you to grow professionally in retail domain on enterprise account. With us you will face challenging and interesting tasks. 

YOU ARE

•    Strong in the understanding of database structures, theories, principles;
•    Have exellend soft skills and experience in communication with end business users;
•    Experienced in SQL;
•    Experienced in Hive, Hadoop;
•    Experienced in PySpark;
•    Have basic knowladge in Scala – nice to have;
•    Able to perform tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques;
•    Passionate about learning new technologies;
•    Have strong analytical skills, sense of responsibility, self-organization, self-improvement potential;
•    Experienced in writing and tuning complex SQLs and use analytical functions;
•    Flexible and motivated to work in a fast-paced environment;
•    Demonstrating good technical English reading, speaking and writing skills;

YOU WANT TO WORK WITH

•    Data analysis and work with technical requirements;
•    Closely work with customer;
•    Risk assessment, defining dependencies and assumptions;
•    Technical specifications and vision document creation;
•    Design of ETL solution

TOGETHER WE WILL

•    Be a part of fast-moving development team that use Agile methodologies best practices;
•    Work with Top Solutions architects in the company;
•    Work with a variety of data sources;
•    Develop ETL technical specifications, designs, tests, implements, and supports optimal data solutions for end-to-end data processing
•    Document ETL data mappings, data dictionaries, processes, programs and solutions;
•    Integrate ETL development with existing projects;
•    Work with the Business team(s) to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake;
•    Perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production;
•    Provide the best product to our customers;
•    Grow professionally as ETL/Big Data developers;