Job Information
Oracle Snowflake & Oracle Golden Gate Data Engineer in Phoenix, Arizona
Job Description
Responsibilities:
Snowflake Data Modeling & Architecture: Design, develop, and implement scalable and high-performing Snowflake data models and solutions tailored to meet business and data analytics needs. Implement best practices for Snowflake Data Vault methodology and other Snowflake-specific features.
Real-Time Data Replication & Ingestion: Manage and optimize data replication using Oracle GoldenGate for Big Data to facilitate real-time data streaming and transformation into Snowflake. Leverage Snowpipe for efficient and automated data ingestion from various sources into Snowflake.
Cloud Integration & Management: Work with AWS cloud services (e.g., S3, EC2, Lambda) to manage and deploy Snowflake-based data solutions, ensuring smooth integration of cloud resources with Snowflake.
Data Sharing & Security: Utilize SnowShare to securely share Snowflake data across teams and external partners. Implement robust data security measures, including role-based access control (RBAC), data masking, and encryption, to ensure compliance with industry standards.
CI/CD Implementation: Implement and manage CI/CD pipelines for Snowflake development and deployment processes, streamlining the delivery of new data models, transformations, and features.
Collaboration & Troubleshooting: Collaborate with cross-functional teams (data analysts, data scientists, business intelligence teams) to understand data requirements and troubleshoot any data-related issues within Snowflake. Provide support in the resolution of data pipeline challenges.
Documentation & Best Practices: Develop and maintain comprehensive documentation for data architecture, data flows, ETL processes, and Snowflake configurations to ensure knowledge sharing and alignment across the team. Stay updated on emerging trends and best practices in data engineering and Snowflake technologies.
Performance Optimization: Continuously optimize the performance of data pipelines, queries, and overall Snowflake architecture for better efficiency and reduced costs.
Requirements:
Experience: 5+ years of experience as a Data Engineer or Snowflake Developer , with a focus on Snowflake architecture, data modeling, and data pipeline management.
Technical Skills:
Proficiency in SQL for writing and optimizing complex queries in Snowflake.
Strong experience with Oracle GoldenGate for Big Data for real-time data replication.
Knowledge of Snowpipe for automating data ingestion into Snowflake.
Familiarity with Snowflake Data Vault methodology for designing data models.
Experience with AWS cloud services (S3, EC2, Lambda, IAM) and integrating Snowflake with AWS tools.
Knowledge of CI/CD tools (e.g., Jenkins, GitLab) for automating data engineering workflows.
Experience with Databricks for data processing and analytics is a plus.
Problem-Solving & Communication:
Excellent problem-solving skills with a keen attention to detail.
Strong communication skills to collaborate effectively with both technical and non-technical stakeholders.
Collaboration & Documentation:
Ability to work in a team environment and share knowledge with peers.
Proven track record in maintaining clear and comprehensive documentation for data architecture, pipelines, and processes.
Career Level - IC2
Responsibilities
Responsibilities:
Snowflake Data Modeling & Architecture: Design, develop, and implement scalable and high-performing Snowflake data models and solutions tailored to meet business and data analytics needs. Implement best practices for Snowflake Data Vault methodology and other Snowflake-specific features.
Real-Time Data Replication & Ingestion: Manage and optimize data replication using Oracle GoldenGate for Big Data to facilitate real-time data streaming and transformation into Snowflake. Leverage Snowpipe for efficient and automated data ingestion from various sources into Snowflake.
Cloud Integration & Management: Work with AWS cloud services (e.g., S3, EC2, Lambda) to manage and deploy Snowflake-based data solutions, ensuring smooth integration of cloud resources with Snowflake.
Data Sharing & Security: Utilize SnowShare to securely share Snowflake data across teams and external partners. Implement robust data security measures, including role-based access control (RBAC), data masking, and encryption, to ensure compliance with industry standards.
CI/CD Implementation: Implement and manage CI/CD pipelines for Snowflake development and deployment processes, streamlining the delivery of new data models, transformations, and features.
Collaboration & Troubleshooting: Collaborate with cross-functional teams (data analysts, data scientists, business intelligence teams) to understand data requirements and troubleshoot any data-related issues within Snowflake. Provide support in the resolution of data pipeline challenges.
Documentation & Best Practices: Develop and maintain comprehensive documentation for data architecture, data flows, ETL processes, and Snowflake configurations to ensure knowledge sharing and alignment across the team. Stay updated on emerging trends and best practices in data engineering and Snowflake technologies.
Performance Optimization: Continuously optimize the performance of data pipelines, queries, and overall Snowflake architecture for better efficiency and reduced costs.
Disclaimer:
Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.
Range and benefit information provided in this posting are specific to the stated locations only
US: Hiring Range in USD from $25.48 to $60.63 per hour; from: $53,000 to $126,100 per annum. May be eligible for bonus and equity.
Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle’s differing products, industries and lines of business.
Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.
Oracle US offers a comprehensive benefits package which includes the following:
Medical, dental, and vision insurance, including expert medical opinion
Short term disability and long term disability
Life insurance and AD&D
Supplemental life insurance (Employee/Spouse/Child)
Health care and dependent care Flexible Spending Accounts
Pre-tax commuter and parking benefits
401(k) Savings and Investment Plan with company match
Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
11 paid holidays
Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
Paid parental leave
Adoption assistance
Employee Stock Purchase Plan
Financial planning and group legal
Voluntary benefits including auto, homeowner and pet insurance
The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.
About Us
As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s problems. True innovation starts with diverse perspectives and various abilities and backgrounds.
When everyone’s voice is heard, we’re inspired to go beyond what’s been done before. It’s why we’re committed to expanding our inclusive workforce that promotes diverse insights and perspectives.
We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.
Oracle careers open the door to global opportunities where work-life balance flourishes. We offer a highly competitive suite of employee benefits designed on the principles of parity and consistency. We put our people first with flexible medical, life insurance and retirement options. We also encourage employees to give back to their communities through our volunteer programs.
We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by calling +1 888 404 2494, option one.
Disclaimer:
Oracle is an Equal Employment Opportunity Employer*. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.
* Which includes being a United States Affirmative Action Employer
Oracle
-
- Oracle Jobs
