Unclassified - Eden Prairie, MN

posted 3 months ago

Full-time - Mid Level
Eden Prairie, MN

About the position

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.

Responsibilities

  • Create SSIS Packages to read data from PI Systems and load it into Oracle Landing area.
  • Develop Oracle Stored Procedures to move data from Landing to Staging using partition exchange.
  • Write Oracle Procedures to calculate aggregations on stage data and load results into curated tables.
  • Create ODI Procedures and Packages to run Oracle procedures daily using ODI Load Plan.
  • Develop C# scripts to update log entries in the SSIS Package.
  • Write Python scripts to read API data from PI Systems and load it into Oracle Landing tables.
  • Utilize JIRA to maintain project scope and track progress of tasks and development activities.
  • Work under supervision to ensure project alignment.

Requirements

  • Proven experience in developing SSIS packages for data integration.
  • Strong knowledge of Oracle databases and SQL, including stored procedures and partition exchange.
  • Experience with ODI (Oracle Data Integrator) for data loading and automation.
  • Proficiency in C# for scripting and logging purposes.
  • Familiarity with Python for API data handling and integration.
  • Ability to effectively use JIRA for project management and task tracking.
  • Strong analytical and problem-solving skills.

Nice-to-haves

  • Experience with PI Systems and their data structures.
  • Familiarity with data warehousing concepts and best practices.
  • Knowledge of data governance and data quality principles.

Benefits

  • Competitive salary and performance bonuses.
  • Health insurance coverage.
  • 401(k) retirement plan with company matching contributions.
  • Opportunities for professional development and training.
  • Flexible working hours and remote work options.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service