Data Engineer - Oracle Apps 181451

CTI Consulting

About The Position

This role is for a Data Engineer with a focus on Oracle Applications. The position involves a blend of Application DBA responsibilities, data engineering and architecture, reporting and analytics support, cloud data platform work, development and automation, and data governance and quality. The ideal candidate will have strong technical skills in Oracle Database, Informatica, Data Warehousing, Snowflake, Oracle Analytics Server, Python, SQL, and NoSQL databases, along with excellent analytical and communication skills.

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