Data Integration Developer – Development & Architecture

Roles/Responsibilities:
Deliverable 1: Design and development including programming testing enhancements and maintenance of specialized software for Business Intelligence (BI) data integration solution for an advanced analysis of CalPERS business transactions.

Design develop and maintain specialized software for a Business Intelligence (BI) solution to analyze CalPERS business transactions. BI provides historical current and predictive insights into business operations by translating business data requirements into technical specifications and developing enterprise data warehouse star schemes. Each data warehouse deliverable focuses on a specific business subject area (star schema) and includes Technical specifications dimensional data models and Extract Transform and Load (ETL) programs. Validation and testing to ensure data aligns with the subject area and integrates seamlessly into the enterprise data platform which includes a data warehouse and scheduled ETL jobs. Design multidimensional data models (star schemas) to represent business transactions supporting data analysis and analytic dashboards. Integrate data models and ETL jobs into the enterprise data warehouse following established standards. Validate data records to ensure they meet business requirements. Provide backup support for maintaining and operating the data platform which includes over 3000 ETL jobs an operational data store (raw unprocessed data from multiple applications) and a data warehouse (star schemas and data marts). Address and troubleshoot issues related to deliverables during the assignment.

Deliverable 2: Modernization of BI data platform. Architecting frameworks that increase automation capabilities.

Modernize the BI data platform and integrate DevOps practices into the data and analytics software project lifecycle. Architect frameworks to enhance automation capabilities ensuring scalability and efficiency. Implement Java programming for developing add-on modules and cloud data source connectors that integrate seamlessly with the existing data platform. Utilize Groovy programming to automate tasks and create repeatable frameworks that streamline development and operational processes. Develop a proof of concept (PoC) for CalPERS data integration process using a modern data integration tool demonstrating improved performance flexibility and scalability. This includes evaluating and implementing advanced data integration technologies to optimize data flow reduce latency and enhance data quality. The modernization effort focuses on aligning the BI platform with current industry standards leveraging cloud-based solutions and ensuring the platform is future-ready. Additionally Establish automated testing deployment pipelines and monitoring frameworks to ensure faster delivery higher quality and reduced operational risks. Architect solutions that support hybrid data environments enabling seamless integration of on-premises and cloud data sources.

Deliverable 3: Knowledge Transfer

On an ongoing basis through the end of the contract all work products and deliverables (project status reports business process triage incident reports with resolution meeting minutes test cases test outcomes) details have to be discussed with the contract manager to ensure that all of the information is documented and placed in a file share. The contract manager will schedule knowledge transfer sessions at regular intervals to ensure that all of the work production details have been documented and the knowledge has been transferred to state personnel. Knowledge transfer to State staff is part of each project when the projects are completed and released into maintenance mode. On an ongoing basis through the end of the contract all work products and deliverables (project status reports business process triage incident reports with resolution meeting minutes test cases test outcomes) details have to be discussed with the contract manager to ensure that all of the information is documented and placed in a file share. The contract manager will schedule knowledge transfer sessions at regular intervals to ensure that all of the work production details have been documented and the knowledge has been transferred to the state personnel.

Mandatory Skills:

1. Strong proficiency in Data Integration Development and Oracle Data Integrator (ODI) for ETL job development.
2. Expertise in designing and developing dimensional models / star schemas for data warehouses.
3. Advanced SQL programming and data transformation skills.

Desirable Skills: N/A