Data Warehousing Consultant

PB Consulting

Washington, DC

Posted On: Feb 08, 2024

Job Overview

Job Type

Contract - W2

Experience

10 - 15 Years

Salary

$65 Per Hour

Work Arrangement

On-Site

Travel Requirements

0%

Required Skills

  • Data Modeling
  • Database
  • ETL
  • Azure ADF / SAP BODS
  • SQL
  • Python
  • Data Warehousing
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

Naincy Chauhan

Sr. Manager