Description

You will design, build, and maintain cloud-based data pipelines and warehousing solutions for enterprise data initiatives.

This role is hybrid.

Responsibilities

• Design and develop ETL processes for data ingestion, transformation, and loading into data warehouses.
• Implement cloud data pipelines using Azure Data Factory v2 and Databricks.
• Build optimized data structures and maintain Data Warehouse schemas and Data Marts.
• Collaborate with data analysts and scientists to support reporting and analytics needs.
• Ensure high performance, security, and scalability in all data integration solutions.

Required Skills

• 10+ years of experience in ETL development, data integration, and Data Warehouse design.
• Expertise in Azure Data Factory v2 and IBM DataStage.
• Hands-on experience with Azure Data Lake, Azure Synapse, and Azure SQL Data Warehouse.
• Proficiency in the SQL Server stack including SSIS, SSRS, and SSAS.
• Strong command of T-SQL, Oracle, and Python.
• Experience with XML and Windows/Linux shell scripting.
• Ability to work with both structured and unstructured data sources.
• Familiarity with Erwin, Power BI, Tableau, and MS TFS.
• Knowledge of Kimball or Inmon data warehousing concepts.

Preferred Skills

• Minimum 5 years of experience with Snowflake.
• Experience ingesting spatial data.

Key Skills

Education

Any Graduate