Unclassified - Eden Prairie, MN
posted 3 months ago
As an ODI Developer, you will be responsible for designing and implementing data integration solutions that facilitate the movement of data from PI Systems into Oracle databases. Your primary focus will be on creating SSIS packages that efficiently read data from PI Systems and load it into the Oracle Landing area. This role requires a strong understanding of both Oracle and SSIS technologies, as well as the ability to develop and maintain complex data workflows. In addition to SSIS package development, you will create Oracle Stored Procedures to facilitate the movement of data from the Landing area to the Staging area using partition exchange techniques. This will involve writing efficient SQL code to ensure data integrity and performance. You will also be tasked with developing Oracle Procedures that perform aggregations on the staged data, subsequently loading the results into curated tables for reporting and analysis. Your responsibilities will extend to creating ODI Procedures and Packages that automate the execution of Oracle procedures on a daily basis through ODI Load Plans. This automation is crucial for maintaining up-to-date data in the curated tables. Furthermore, you will utilize C# scripting to update log entries within the SSIS packages, ensuring that all processes are well-documented and traceable. To enhance data integration capabilities, you will also develop Python scripts to read API data from the PI Systems and load it into the Oracle Landing tables. This will require a solid understanding of both Python programming and API interactions. Throughout your work, you will effectively use JIRA to maintain project scope, track task progress, and document all development activities. Collaboration with team members and stakeholders will be essential, and you will work under supervision to ensure alignment with project goals and timelines.