Data Warehouse developer with Data Vault

Pacific Investment Management Company PIMCO

Contract Newport Beach, California, United States Posted 5 months ago

 Write a Review Add Vendor   Add Contact  

About Position

Data Warehouse developer with Data Vault (Contract)

$125.00 / Hourly

Newport Beach, California, United States

Data Warehouse developer with Data Vault

Contract Newport Beach, California, United States Posted 5 months ago

Skills
• Designs and builds conceptual logical and physical dimensional data models and third normal form artifacts. • Supports new data development ensuring consistency and integration with existing data warehouse structure and framework. • Designs builds and maintains data warehouse solutions to support Business Intelligence (BI) and Reporting projects using Informatica Oracle and MicroStrategy • Ensure that the highest level of system and data confidentiality integrity and data availability is maintained • Demonstrate knowledge in writing understanding and tuning PL/SQL and/or T-SQL is a must • Understanding of relational database concepts and experience with data modeling is a must • Skilled in OOP design and development preferably in Python • Develop and maintain data architecture framework and standards. • Serves as Subject Matter Expert in data warehouse concepts (star schema snowflake schemas and normalized and de-normalized data models). Analyzes performance statistics and recommend improvements.
Description

Seeking an Enterprise Data Warehouse Developer at intermediate level to work on the projects focusing on the development of PIMCO’s Data Warehouse domain, a key platform delivering enterprise-wide analytics. The candidate should demonstrate an advanced level of understanding of data architecture, data modeling, data analytics, RDBMS systems, and data integration solutions. The candidate will support a full lifecycle of activities on data analysis, design, modeling, processing, and integration. Activities will include organizing and manipulating data across disparate sources, analyzing datasets, performing queries on data, managing business rules and processes to ensure the timely operation of data.

Responsibilities
  • • BS/BA degree in Computer Science, Information Systems, Engineering or related fields or equivalent experience
  • • 8+ Professional working experience
  • • 6+ years relevant work experience in technology environment
  • • Sophisticated knowledge with Data Architecture (conceptual, logical, physical, transactional, dimensional, and Star/Snowflake modeling).
  • • Ability to design and visualize a system’s architectural blueprints using UML, ERD, and Data flow diagrams.
  • • Expertise in Oracle enterprise relational database with experience in query optimization and performance tuning.
  • • Ability to design and participate in application discovery and architecture workshops.
  • • Good interpersonal and communication skills are essential, as well as the ability to work well in a team environment.
  • • Experience in banking or financial services preferred.

By applying to a job using ClientFYI you are agreeing to comply with and be subject to the ClientFYI Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Questions / Comments:

Display Questions / Comments:

No Questions / comments

Pacific Investment Management Company PIMCO Vendors

MW Partners
Write a Review

201 East Sandpointe Suite #200
Santa Ana
California
http://www.mwpartners.net/ ( No vendors )

Job Summary

$125.00 / Hourly

Contract

Newport Beach, California, United States

Experience Required : 7 Year/s

Posted : 5 months ago

Deadline : March 26, 2020 5 months ago

Job ID : Job000002576

Pacific Investment Management Company PIMCO

840 Newport Center Drive, Suite 100

www.pimco.com