Data Warehouse Architect-Baldwin Park, CA - Georgia IT Inc.
Baldwin Park, CA
About the Job
Data Warehouse Architect
Location: Baldwin Park, CA
Duration: 5 months
Rate: DOE
US Citizen, Green Cards, GC EAD and H4 EAD Preferred.
Job Description:
Experience:
Location: Baldwin Park, CA
Duration: 5 months
Rate: DOE
US Citizen, Green Cards, GC EAD and H4 EAD Preferred.
Job Description:
- Bachelor s Degree in Computer Science, Information Systems or related discipline
- 5 years of enterprise Data Warehouse design, implementation, deployment, operation, and monitoring with demonstrated expert knowledge developing SQL, stored procedures, views
- 5 years of experience with Power BI, Tableau, Microsoft SSIS and Informatica with data aspects of information system design, modeling, and implementation.
- 5 years of experience relational and dimensional data modeling - including constructing database normalization; utilizing data modeling tools to record, update, reverse engineer and generate DDL; creating logical and physical data models for current and proposed states
- Demonstrated experience and expert knowledge supporting statistical and predictive analytic modeling with large datasets.
- Expert demonstrated knowledge writing / understanding SQL queries and stored procedures; MS SQL/ Oracle experience preferred
- Knowledge of Data Governance and Data Stewardship principles and processes.
- Knowledge and experience with Data Quality concepts and tools.
- Proficient at performance tuning techniques both Informatica and database level
- Knowledge of OS command line and scripting techniques
- Experience with non-relational data sources (flat file, XML, CACHE, unstructured, etc.)
Experience:
- Developing SQL, stored procedures, views, MDM and ETL: 5 years
- Power BI, Tableau, Microsoft SSIS and Informatics: 5 years
- Data Warehousing: 5 years
- System design, modeling, and implementation:
Source : Georgia IT Inc.