Loading...
About the job
We have an immediate opportunity for "Data Warehouse Engineer - Data Integration" with our client. Interested candidates send me your CV to kirthika.r@lancesoft.com
Job Title: Data Warehouse Engineer - Data Integration
Location: Dubai
Duration: 12+ Months
Skills, Tools, and Systems Experience:
• StreamSets Data Collector, Kafka, DBT, Airflow, PostgreSQL + Citus, Tableau
• Data Warehousing and Dimensional Modeling
• Data Visualization / Reporting
Job Accountabilities (What is done and why) Weightage (%)
Development of Data Integration Pipelines 30%
• Design, build and deploy effective data ingestion pipelines/streams in StreamSets Data Collector & Kafka
• Process data using SQL and PL SQL Procedures
• Orchestrate and automate data ingestion pipelines
Design and Implementation of Data Models 20%
• Transform data into Star Schema Data Model including partitioning and distribution strategy
• Create Semantic layer and Data Marts
• Build Aggregate tables
Design and Development of Tableau Dashboards 30%
• Design and Develop Visualization for KPIs
• Compose Sheets using Tableau Data Model
• Develop Tableau Workbook using Containers and Sheets parameters and automate data extracts
Operational support and administration of Data Integration platform 10%
• Maintenance of system logs
• Security Update and System Patching
• Monitoring of the platform and applications
Requirements Gathering and Project Reporting 10%
• Data Analysis and generation of KPI
• Communication to business and expectation management
• Project planning and dependency resolution
Interested candidates send me your Cv along with below details:
Expected salary:
Visa/ Work Permit:
Notice Period:
Current Location:
Seniority Level: Other
Job Functions: Data Science & Analytics
Industries : Information Technology
