What are the responsibilities and job description for the Data Warehouse Architect position at Tech Providers, Inc.?
Position : Data Warehouse Architect
Duration : 12 month contract with high possibility for extension
Location : City of Industry, CA, 91746 (Hybrid)
LIVE SCAN REQUIRED
Skills Required :
Ability to lead a Data Mart development project including design, development, data modeling, implementation, and documentation.
Knowledge of Oracle databases and data warehouse database design.
Ability to design data warehouse schema objects for various Data Marts.
Ability to use data warehouse designing software tools like Erwin, Visio, or others to document and communicate project goals effectively.
Ability to build data warehouse fact tables and dimension tables applying slowing changing dimension concepts. –
Ability to design ETL jobs to integrate data from different sources into Oracle Exadata databases running on Oracle Cloud Infrastructure.
Ability to build data pipelines to process terabytes of data while maintaining performance and proactively scaling resources as needed.
Ability for query, and Talend job optimization to ensure adequate performance.
Ability to analyze visualization / reports requirements to design the corresponding database objects.
Good communication skill to provide knowledge transfer sessions and the corresponding documentation.
Ability to draft project documentation including diagrams and project management documentation requirements.
Knowledge of the Talend administration console to help maintain and configure new projects and jobs.
Experience Required :
Three (3) years’ experience within the last five (5) years leading data mart projects in Oracle Exadata Databases Oracle Cloud Infrastructure (OCI).
Three (3) years’ experience within the last five (5) years as a data warehouse architect in Oracle Exadata Databases Oracle Cloud Infrastructure (OCI).
This should include structuring and organizing databases specifically for data warehouses, expertise in data modeling techniques, optimizing query performance, understanding ETL processes, and designing database architecture to efficiently store and retrieve large volumes of data.
Three (3) years’ experience within the last five (5) years of Oracle SQL & PL / SQL programming as part of ETL solution implementations.
Five (5) years’ experience within the last seven (7) years in architecting and implementing ELT processes in Qlik Talend including Version 6.5 or greater.
Three (3) years’ experience within the last five (5) years developing Business Intelligence solutions using On-prem and Cloud technologies.
Education Preferred :
Degrees : Bachelor of Science Degree from an accredited four-year college / university in one of the following majors : Computer Science, Information Technology, Information Systems, Computer Engineering, Software Engineering, Systems Engineering, Applied Computer Sciences, or Informatics. Diplomas must be provided upon request.
Certificates : Any of these certificates, Talend Data Integration Certificate, Talend Big Data Developer Certification, or Talend API Services Developer Certification.
Additional Information :
The work schedule will be set up within the first week of staring with work hours coinciding with the work hours of the section.
After-hours support may be required as deemed by the PM, with advanced notice.
DPSS retains the right to change work schedules with 24-hour notice.
DPSS does not compensate for use of mobile phone or travel expenses.
Live Scan (fingerprinting) is required and be performed by DPSS HR.
Work Location : 14714 Carmenita Road, Norwalk, CA.
