1024 Data Integration Developer – Development & Architecture
Share
Job Location:
Sacramento, CA - USA
Monthly Salary:
Not Disclosed
Posted on:
8 days ago
Vacancies:
1 Vacancy
Job Summary
Job Summary (List Format): Data Integration Developer Development & Architecture
- Develop and Support Data Integration Solutions:
- Design develop and maintain specialized software for data integration focusing on dimensional models transformation solutions and ETL jobs using Oracle Data Integrator.
- Develop and enhance data warehouse datasets including self-service data marts facts dimension tables and ETL processes.
- Provide functional administration for the data integration environment.
- Data Platform Maintenance and Operations:
- Monitor and maintain data warehouse and data integration environments.
- Ensure data accuracy freshness and alignment with business requirements.
- Provide backup support for operating the data platform (ETL jobs operational data store data warehouse).
- Modernize and Automate BI Data Platform:
- Architect and implement frameworks to increase automation scalability and efficiency.
- Integrate DevOps practices into the data and analytics software lifecycle.
- Develop Java and Groovy programs for add-on modules cloud data source connectors and automation tasks.
- Evaluate and implement modern data integration tools and technologies supporting hybrid (on-premises and cloud) environments.
- Design and Validation:
- Design and develop multidimensional data models (star schemas) for business transaction analysis.
- Validate and test data integrations and ETL processes to ensure seamless integration and high quality.
- Source Application Change Management:
- Coordinate data integration maintenance when source applications are upgraded or patched to ensure continued operations.
- Knowledge Transfer:
- Document all deliverables processes incidents and solutions.
- Conduct regular knowledge transfer sessions with state personnel and ensure documentation is maintained and accessible.
- Collaboration and Reporting:
- Work closely with contract managers business users and other stakeholders.
- Provide status reports participate in meetings and assist with incident resolution.
Minimum Qualifications:
- 5 years experience in Pension Health Insurance Customer Service or Finance domains.
- 5 years experience with data integration (ETL) for transforming source data into data warehouses/data marts.
- 3 years experience with Oracle Database 19c and Oracle Data Integrator or similar ETL tools.
- 5 years experience developing complex PL/SQL SQL and data marts.
- Must be able to interpret requirements and work with complex data integration projects.
- Top candidates will be interviewed for selection.
- Develop and Support Data Integration Solutions:
- Design develop and maintain specialized software for data integration focusing on dimensional models transformation solutions and ETL jobs using Oracle Data Integrator.
- Develop and enhance data warehouse datasets including self-service data marts facts dimension tables and ETL processes.
- Provide functional administration for the data integration environment.
- Data Platform Maintenance and Operations:
- Monitor and maintain data warehouse and data integration environments.
- Ensure data accuracy freshness and alignment with business requirements.
- Provide backup support for operating the data platform (ETL jobs operational data store data warehouse).
- Modernize and Automate BI Data Platform:
- Architect and implement frameworks to increase automation scalability and efficiency.
- Integrate DevOps practices into the data and analytics software lifecycle.
- Develop Java and Groovy programs for add-on modules cloud data source connectors and automation tasks.
- Evaluate and implement modern data integration tools and technologies supporting hybrid (on-premises and cloud) environments.
- Design and Validation:
- Design and develop multidimensional data models (star schemas) for business transaction analysis.
- Validate and test data integrations and ETL processes to ensure seamless integration and high quality.
- Source Application Change Management:
- Coordinate data integration maintenance when source applications are upgraded or patched to ensure continued operations.
- Knowledge Transfer:
- Document all deliverables processes incidents and solutions.
- Conduct regular knowledge transfer sessions with state personnel and ensure documentation is maintained and accessible.
- Collaboration and Reporting:
- Work closely with contract managers business users and other stakeholders.
- Provide status reports participate in meetings and assist with incident resolution.
Minimum Qualifications:
- 5 years experience in Pension Health Insurance Customer Service or Finance domains.
- 5 years experience with data integration (ETL) for transforming source data into data warehouses/data marts.
- 3 years experience with Oracle Database 19c and Oracle Data Integrator or similar ETL tools.
- 5 years experience developing complex PL/SQL SQL and data marts.
- Must be able to interpret requirements and work with complex data integration projects.
- Top candidates will be interviewed for selection.
