SQL/ETL Developer Offline

WE ARE

We are a team of professionals who create high-quality software products 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 a retail domain on an enterprise account. With us, you will face challenging and interesting tasks

YOU ARE

A specialist ready to pass the retraining program and become a Big Data Engineer

Strongly competent in database structures, theories, principles

Experienced in SQL (in writing and tuning complex SQLs and use analytical functions)

Having basic knowledge in Python, PySpark, readiness to learn Snowflake

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

Possessing strong analytical skills, a sense of responsibility, self-organization, self-improvement potential

Flexible and motivated to work in a fast-paced environment

Showing excellent soft skills and experience in communication with end business users

Demonstrating good technical English reading, speaking, and writing skills.

YOU WANT TO WORK WITH

Data analysis and technical requirements

A customer closely

Risk assessment, defining dependencies and assumptions

Technical specifications and vision document creation

Design of ETL solution.

TOGETHER WE WILL

Be a part of a fast-moving development team that use Agile methodologies best practices

Cooperate with Top Solutions architects in the company

Work with a variety of data sources

Develop ETL technical specifications, as well as design, test, implement, and support 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

Collaborate 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 the production

Provide the best product to our customers

Grow professionally as ETL/Big Data developers