Senior Data Engineer - SSIS

September 25

Apply Now
Logo of Derevo

Derevo

Qlik • Data Discovery Projects • DataScience Projects • Business Intelligence • Datawarehouse

51 - 200

Description

• The desired candidate should have hands-on experience in designing, establishing, and maintaining data management and storage systems. • You should be skilled in collecting, processing, cleaning, and deploying large datasets, understanding ER data models, and integrating with multiple data sources. • You must also be proficient in analyzing, communicating, and proposing different approaches for building Data Warehouses, Data Lakes, End-to-End Pipelines, and Big Data solutions for clients, using either batch or streaming strategies.

Requirements

• At least 5 years of experience working with SSIS. • Intermediate/Conversational English. • SQL: Data Definition Language (DDL), Data Manipulation Language (DML), Intermediate/Advanced queries for analytical purposes, Subqueries, CTEs (Common Table Expressions), Data types, Joins with applied business rules, Grouping and Aggregates for business metrics, Indexing and optimizing queries for efficient ETL processes, Stored Procedures for transforming and preparing data, SSMS, DBeaver. • SSIS: Design and develop ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various source systems into target databases. • Create, configure, and deploy SSIS packages, including data flow tasks, control flow tasks, and event handlers. • Perform data source integration from diverse platforms such as relational databases, flat files, web services, and cloud-based storage. • Optimize data integration processes for performance, identifying and resolving bottlenecks, and following best practices. • Provide expertise in troubleshooting and resolving data integration issues, ensuring data accuracy and consistency.

Benefits

• WELLNESS : We promote your overall well-being by balancing your personal, professional, and financial aspects. • LET’S RELEASE YOUR POWER : You’ll have the opportunity to specialize in different areas and technologies, allowing you to grow in an interdisciplinary way. • WE CREATE NEW THINGS : We love thinking outside the box. You will have the space, trust, and freedom to create, along with the necessary training to achieve your goals. • WE GROW TOGETHER : You will participate in cutting-edge, multinational technology projects with international teams.

Apply Now
Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or lior@remoterocketship.com