Description

Design and develop data flows between line of business applications and data warehouses within multi-cloud, tenant environments.

Responsibilities

• Design, develop, and document data flows from applications to the Data Warehouse or other business systems.
• Collaborate with IT to model application data structures, storage, and integration following enterprise architecture standards.
• Develop and execute test plans covering data design, extraction, transformation, and tool design.
• Manage data capture, retention, and metadata to ensure compliance with HIPAA, PCI, PII, and federal/state policies.
• Provide technical support for incident resolution and manage ticket lifecycles.

Required Skills

• 5+ years of experience in data engineering or integration roles.
• Proficiency in T-SQL and PL/SQL.
• Strong programming skills in Python and Java.
• Experience with Oracle 19c Database.
• Hands-on experience with Oracle Integration Cloud (OIC).
• Ability to work within multi-cloud and tenant-based environments.
• Experience designing and modeling data structures across legacy, web, and cloud environments.
• Ability to produce both technical and non-technical documentation.

Preferred Skills

• Knowledge of web technologies including REST, SOAP, JSON, and (S)FTP(S).
• Experience with large and high-frequency data loads and optimization methods.

Key Skills

Education

Any Gradute