Data Integration Developer

About this Position:

Job Title: Data Integration Developer

Deliverables:

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 business transactions.

• Design, develop, and maintain specialized software for a Business Intelligence (BI) solution to analyze 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 3,000 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 client's 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

• The 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 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.

Qualifications:

• At least five (5) years of experience in some or all areas of Pension, Health Insurance, Customer Service, or Finance.

• At least five (5) years of experience performing tasks pertaining to data integration (ETL) processes to transform disparate source data into the target data stores, data warehouses or datamarts.

• At least three (3) years of experience in data integration projects using Oracle Database 19c and Oracle Data Integrator or similar ETL tools.

• At least five (5) years of experience with interpreting requirements and developing complex PL/SQL, SQL and data marts.