Description

You will design and maintain ETL pipelines for a cloud-based data management platform, ensuring high-quality spatial and business data integration.

Responsibilities

• Analyze source systems with spatial components to profile data, identify conflicts, and recommend resolution strategies.
• Develop ETL processes and database schemas to extract, transform, and load data into warehousing environments and Data Marts.
• Decompose requirements into Agile Epics, Features, and user stories while managing metadata and documenting data lifecycles.
• Define test objectives, create test plans, and execute test cases including User Acceptance Testing (UAT) to ensure data quality.
• Collaborate with data scientists and architects to refine data models and optimize table structures for reporting.

Required Skills

• 10+ years of experience in data analytics or data engineering.
• Proficiency in Python, Java, XML, and SQL.
• Hands-on experience with SSIS, SSRS, and SSAS.
• Deep knowledge of warehousing architecture including MOLAP, ROLAP, ODS, DM, and EDW.
• Experience with Oracle, T-SQL, and Azure SQL Database.
• Expertise in entity resolution, semantic conflict identification, and metadata management.
• Ability to diagram processes using flowcharts, context diagrams, and data flow diagrams.
• Experience working within Agile/Sprint frameworks.

Key Skills

Education

Any Graduate