Data Warehousing Consultant

  • Salary

    $65 Per Hour

Experience

10 to 15 Years

Posted On

Feb 08, 2024

Company

PB Consulting

Travel Requirements

0%

Job Overview

Required Skills

  • Data Modeling
  • Database
  • ETL
  • Azure ADF / SAP BODS
  • SQL
  • Python
  • Data Warehousing

Job Type

Contract - W2

Location

Washington, DC

Job Description

Job Description

  • Candidate Should have hands-on experience on working in Cloud Based Datawarehouse Solution with below capabilities:
  • Data Modeling: Design and implement data models based on business requirements.
  • Optimize and normalize database structures for efficient data storage and retrieval.
  • Database Development: Develop and maintain database schemas, tables, indexes, and views.
  • Write efficient and optimized SQL queries for data manipulation and retrieval.
  • ETL (Extract, Transform, Load)
  • Design and implement ETL processes to extract data from various sources, transform it as needed, and load it into the target databases
  • Experience on any ETL tools like Azure ADF/SAP BODS
  • Data Integration: Integrate data from diverse sources and systems to create a unified view.
  • Implement data integration solutions for real-time or batch processing.
  • Extensive experience in data analysis using SQL, Python
  • Design and develop data warehouses to support business intelligence and reporting needs.
  • Optimize data warehouse performance and ensure scalability.
  • Data Security: Implement and maintain security measures to protect sensitive data.
  • Monitor and audit data access to ensure compliance with security policies.
  • Performance Tuning: Identify and resolve performance issues in databases and data processing pipelines.
  • Optimize queries and processes for better performance.
  • Collaboration: Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders
  • Communicate effectively to understand and address data requirements.
  • Continuous Learning: Stay updated on industry trends, emerging technologies, and best practices in data development.
  • Problem Solving: Identify and resolve data-related issues and challenges.
  • Troubleshoot and debug issues in databases and data processing systems.

Job ID: PC240045

  • Posted By

    William Christopher

Designation

Sr. Manager

Company

PB consulting

Last Login

Apr 22, 2024

Posted On

Feb 08, 2024


Related Jobs