Oracle To Snowflake Developer Jobs

1 job found

Today

Oracle PL/SQL Developer

CGI Group, Inc. Plano, TX

Plano, TX

Today

$84k - $115k/yr Full time Data Integration Data Pipeline Data Processing

Apply Now

Job Description

CGI Group, Inc. is seeking an experienced Oracle PL/SQL Developer to help design, develop, test, and maintain complex Oracle SQL and PL/SQL solutions. This onsite role in Plano, TX focuses on performance tuning, reliable data integration, and delivering database capabilities that support downstream applications and analytics.

In this position, you will build and support Oracle-to-Snowflake data flows, automate testing using TDD practices, and partner with business stakeholders, application developers, data engineers, architects, and QA teams throughout an Agile/Scrum delivery cycle.

What you’ll do

Design, develop, test, and maintain complex Oracle SQL and PL/SQL solutions.
Develop and optimize stored procedures, packages, functions, cursors, triggers, and complex SQL queries.
Perform SQL and PL/SQL performance tuning, including execution-plan analysis, indexing, and query optimization.
Deliver solutions for data maintenance, migration, copy, reconciliation, archival, and purge activities.
Build and support Oracle-to-Snowflake integrations, including data movement, transformations, and validation processes.
Troubleshoot database and data issues while ensuring data integrity, accuracy, and application performance.
Translate business and data requirements into scalable technical designs and database solutions.
Develop automated tests and follow Test-Driven Development (TDD) and engineering best practices.
Participate in code reviews and contribute to development and database standards.
Collaborate with stakeholders across teams, including application development, data engineering, architecture, and QA.
Participate in Agile/Scrum activities, including sprint planning, daily stand-ups, reviews, and retrospectives.
Communicate delivery status, dependencies, risks, and technical issues effectively across teams.

Requirements

Bachelor’s or Master’s degree in a technical field such as Computer Science, Software Engineering, Information Systems, or a related discipline.
9+ years of Oracle SQL and PL/SQL development experience.
Strong expertise in SQL, stored procedures, packages, functions, cursors, transactions, triggers, and exception handling.
Strong knowledge of Oracle performance tuning, query optimization, indexing, and execution plans.
Experience developing complex SQL queries and processing large-volume data sets.
Strong understanding of relational and transactional databases and database design principles.
Experience with data migration, maintenance, reconciliation, archival, and purge processes.
Good understanding of dimensional modeling and Star Schema concepts.
Experience with CI/CD and automated database deployment.
Hands-on experience across analysis, design, development, testing, debugging, and production support.

Technologies

Oracle SQL
PL/SQL
Oracle-to-Snowflake integrations
Snowflake
Amazon Relational Database Svc
ETL
GIT
Jira
CI/CD
Test-Driven Development (TDD)

Compensation and location

Location: Plano, TX (onsite)
Salary range: USD 83,900 - 115,400 per year
Compensation estimate notice: A reasonable estimate of the current range for this role in the U.S. is $83,900.00 - $115,400.00.

Benefits

Competitive compensation
Comprehensive insurance options
Matching contributions through the 401(k) plan and the share purchase plan
Paid time off for vacation, holidays, and sick time
Paid parental leave
Learning opportunities and tuition assistance
Wellness and Well being programs

Good to have

Snowflake integration or Oracle-to-cloud data platform integration
Exposure to cloud and modern data engineering platforms
Experience supporting high-volume, business-critical enterprise applications
Financial services or other regulated-industry experience

View full job page →

Get Oracle To Snowflake Developer Jobs alerts

New Oracle To Snowflake Developer Jobs, daily.