Data Engineer- Oracle Apps 181451

CTI Consulting•Durham, NC

10d

About The Position

We are seeking a skilled Data Engineer with a strong background in Oracle Apps and a blend of application DBA responsibilities and data engineering expertise. This role involves administering, monitoring, and tuning Oracle databases, developing and maintaining data models, building enterprise data warehouse solutions on Oracle and Snowflake, and supporting reporting environments. The ideal candidate will have hands-on experience with ETL tools, Python, SQL, and cloud data platforms, along with a proactive approach to data governance, quality, and automation.

Requirements

Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience)
7+ years of experience in data engineering and database administration
Strong expertise in Oracle Database (Application DBA experience required)
Strong expertise in Informatica (ETL development)
Strong expertise in Data Warehousing concepts and architecture
Hands-on experience with Snowflake
Hands-on experience with Oracle Analytics Server (reporting and integration)
Hands-on experience with Python
Hands-on experience with SQL (advanced querying and performance tuning)
Hands-on experience with NoSQL databases (MongoDB preferred)

Nice To Haves

Experience with cloud platforms (Azure, AWS, or GCP)
Familiarity with modern data stack tools (dbt, Airflow, etc.)
Knowledge of DevOps and CI/CD pipelines
Experience supporting high-volume transactional systems (OLTP)
Exposure to data governance and security frameworks

Responsibilities

Administer, monitor, and tune Oracle databases supporting critical applications
Manage database performance (query optimization, indexing, partitioning, and execution plans)
Perform database maintenance activities (backups, recovery, patching, upgrades)
Ensure high availability, disaster recovery, and data integrity
Support application teams in database design and troubleshooting
Develop and maintain data models (dimensional and normalized) to support analytics and reporting
Build and optimize enterprise data warehouse solutions across Oracle and Snowflake platforms
Ensure efficient ingestion, transformation, and integration of structured and unstructured data
Design, develop, and maintain scalable data pipelines and ETL processes using tools such as Informatica and Python
Support and enhance Oracle Analytics Server reporting environments
Collaborate with BI and analytics teams to ensure data accuracy and usability
Optimize data structures for reporting performance
Develop and maintain solutions in Snowflake cloud data warehouse
Implement best practices for cloud data architecture, cost optimization, and performance
Work with NoSQL technologies (MongoDB) for semi-structured and unstructured data use cases
Write efficient, reusable, and scalable code using Python and SQL
Automate data workflows, monitoring, and alerting
Implement CI/CD practices for data pipelines and database deployments
Ensure data quality, consistency, and security across platforms
Implement data validation, cleansing, and lineage tracking
Adhere to corporate data governance and compliance standards