671-Oracle & Talend ETL Data Warehouse Architect

This position requires - Clear Background, Drug Test, and Education Check.
Must be authorized to work in the US for any employer without Sponsorship.
(Principal Only! No Corp to Corp)
---------------------------------------------------------------------------------------------------------------------

Position Title: 671-Oracle & Talend ETL Data Warehouse Architect
Location: Norwalk, CA
Pay Rate: $80-$95

Contract Duration: 1 Year

Estimated Regular Hours/Week: 40.00

Hybrid

Skills Required:

1. Ability to lead a Data Mart development project including design, development, data modeling, implementation and documentation.
2. Knowledge of Oracle databases and data warehouse database design.
3. Ability to design data warehouse schema objects for various Data Marts.
4. Ability to use data warehouse designing software tools like Erwin, Visio or others to document and communicate project goals effectively.
5. Ability to build data warehouse fact tables and dimension tables applying slowly changing dimension concepts.
6. Ability to design ETL jobs to integrate data from different sources into Oracle Exadata databases running on Oracle Cloud Infrastructure.
7. Ability to build data pipelines to process terabytes of data while maintaining performance and proactively scaling resources as needed.
8. Ability for query and Talend job optimization to ensure adequate performance.
9. Ability to analyze visualization/reports requirements to design the corresponding database objects.
10. Good communication skills to provide knowledge transfer sessions and the corresponding documentation.
11. Ability to draft project documentation including diagrams and project management documentation requirements.
12. 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 Required:

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:

Resumes submitted must contain clear evidence all qualifications are met, “From” and “To” dates specified for each project included in the work history, and contact information of persons who can substantiate experience and job performance, references will be verified. The work schedule will be set up within the first week of starting 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.

We encourage Minorities, Women, Protected Veterans and Disabled individuals to apply for all positions that they may be qualified for. We maintain a drug-free workplace and perform pre-employment substance abuse testing and background checks.

If you are interested in this position, please submit your resume in a Word Document with the month and year that you have worked at each previous position to - roli@norlandgroup.com and copy: 671-Oracle & Talend ETL Data Warehouse Architect to the email Subject Line.

Or click this email link and attach your resume in a MS Word Document format.

Job Posted Date: 2/24/2025