Description:
This role is a full-time, in-person position, primarily based in the office with occasional visits to client sites. We are seeking candidates who reside in the Virginia/Washington DC region.
Responsibilities
Required Skills and Qualifications :
- 8+ years of experience in data engineering, ETL development, or database management
- Strong expertise in Oracle Database technologies (e.g., Oracle 19c, Oracle Exadata, Oracle Data Integrator - ODI)
- Proven experience with PL/SQL, Oracle partitioning, and performance tuning
- Deep understanding of data modeling, data warehousing concepts, and star/snowflake schemas
- Strong knowledge of ETL pipeline design and implementation for large-scale data systems
- Proficiency in shell scripting, Python, or other automation tools
- Experience with Oracle GoldenGate or similar CDC (Change Data Capture) tools
- Familiarity with data governance, metadata management, and data lineage practices
- Ability to work with cross-functional teams including data scientists, DBAs, and business analysts
- Strong verbal and written communication skills for documenting and presenting solutions
Desired Skills and Qualifications:
- Experience integrating Oracle databases with big data platforms (e.g., Hadoop, Spark, or cloud-based data lakes)
- Familiarity with Oracle Big Data SQL or Oracle Autonomous Database
- Exposure to cloud platforms such as Oracle Cloud Infrastructure (OCI), AWS, or Azure
- Experience with streaming data architectures (e.g., Apache Kafka, Oracle Stream Analytics)
- Knowledge of data security best practices and regulatory compliance
- Experience with DevOps and CI/CD pipelines in a data engineering context
- Oracle certifications (e.g., Oracle Certified Professional or Oracle Big Data certification) are a plus