Sr. Analytics - Data Warehouse
Norwalk, CA Skills Required:
Ability to design, develop and document Talend ELT processes, Technical Architecture, data pipelines, and performance scaling for handling terabytes of data throughput. Ability to design the data warehouse schema for various Data Marts, including fact tables and dimension tables to support business requirements.
Ability for query, and Talend job optimization to ensure adequate performance. - Ability to analyze visualization/reports requirements to design the corresponding database objects.
Knowledge of all aspects associated with designing and building a Human Resources Data Mart including, business requirement definition and review, setting up physical environments, comprehensive data modeling, Talend job design, implementation, and delivery.
Knowledge of the Talend administration console to help maintain and configure new projects and jobs.
Knowledge of Oracle databases and data warehouse database design.
Experience Preferred:
Experience using Talend and developing and implementing Talend tools and technologies, including Version 6.5 or greater.
Experience in architecting and implementing ELT processes.
Experience with SQL & PL/SQL programming.
Experience developing Business Intelligence solutions using On-prem and Cloud technologies.
Experience with data warehouse design including 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.
Experience working with Oracle 12c or later versions
Degrees: Bachelor Degree
Certificates: Any of these certificates:
Talend Data Integration Certificate, Talend Big Data Developer Certification, or Talend API Services Developer Certification.