Enterprise Data Warehouse Architect

1970-01-01Davis Companieshttp://www.daviscos.com/wp-content/themes/davis_theme/assets/images/logo.svg325 Donald J. Lynch Boulevard, Suite 201MarlboroughMA01752USAcustomer support[+800-482-9494][+508-481-8519]
Search Jobs

Enterprise Data Warehouse Architect

  • Specialty:

    IT
    • City:

      Burlington
    • State:

      MA
    • 01803
  • Assignment Type:

    Contract
  • Job Id:

    52081
  • Payrate:

    $92.00

Description

Our clients Enterprise Data Warehouse will be implemented on Azure Data Services, sourcing data from on-premise as well as Cloud business applications. Informatica Cloud will be used as the Integrations platform.

This individual with his / her strong understanding of iPaaS, ETL / ELT and Azure DW / Lake concepts, should be able to contribute effectively towards evaluation, proof of concept, design and development of the Azure EDW solution. 

This position requires individual to be a self-starter with excellent communication skills and ability to multi-task on various initiatives.

 Responsibilities:

  • Contribute to EDW solution architecture by participating in design review sessions and providing suggestions/ideas
  • Work with technical team members for Proof of Concept (PoC) of the EDW Use Cases 
  • Work with project stakeholders to understand the requirements and deliver design that best meets the business and technical need
  • Design and develop ETL/ELT solutions using data warehouse design best practices, specifically using Informatica Cloud and Azure Data Warehouse / Data Lake or Azure Synapse
  • Collaborate with business analysts and data architects during data modeling, data mapping and system specification activities
  • Create Data Integrations technical specifications  
  • Follow as well suggest architectural / design best practices, coding standards
  • Contribute to project plan through details on integrations tasks and effort estimations
  • Consistently deliver on time and high-quality deliverables
  • Effectively communicate status, challenges, issues, risks to management

Required Experience:

  • Minimum of 1 full Azure implementation (POC through go-live)
  • Broad experience with: Azure SQL Data warehouse, Data Lake, Data Factory and Databricks, Familiarity with Azure Synapse
  • Informatica experience

Other Qualifications: 

  • Bachelor’s Degree in a technology area of study, preferably in Computer Science, MIS or Analytics.
  • 10+ years of experience in designing and implementing data warehouses, at least 4 years with Cloud data warehouses
  • 4+ years of hands-on experience with Azure ecosystem, specifically Azure SQL Data warehouse, Data Lake, Data Factory and Databricks, Familiarity with Azure Synapse
  • 10+ years of experience using ETL / ELT & iPaaS integration technologies with solid understanding of hybrid integration architecture to identify, analyze and develop interfaces and integration flows both on-premise and on cloud.
  • 8+ years of hands-on ETL development experience using Informatica integration tools, PowerCenter and Informatica Cloud
  • 5+ years of experience in relational and data warehouse database design, optimization and performance, specifically with MS SQL Server and Oracle
  • Microsoft Certification in Azure Data Solutions is preferred
  • Experience with Informatica Cloud application integration (ICRT) tool is desired
  • Experience working with offshore resources is desired

 

 

#LI-RB1

#LI-WD1

 

 

Quick Apply

  • As an Equal Employment Opportunity Employer, DAVIS has reporting requirements which require us to invite employees to voluntarily self-identify their race/ethnicity. Submission of this information is voluntary and refusal to provided it will not subject you to any adverse treatment. The information obtained will be kept confidential.
  • Accepted file types: pdf, doc, docx, txt, rtf.
  • By applying to this position and providing my contact information, I give The DAVIS Companies permission to provide me with email communications and information.

Loading...