{"schemaVersion":"jobsearcher.job.v1","id":"d96558ea38c80c8e7524c14e","url":"https://jobsearcher.com/jobs/d96558ea38c80c8e7524c14e","canonicalUrl":"https://jobsearcher.com/jobs/d96558ea38c80c8e7524c14e","title":"Oracle PL/SQL Developer - Financial Services","description":"Oracle PL/SQL Developer – Financial ServicesWe are seeking an experienced Oracle PL/SQL Developer with strong hands-on expertise in Oracle SQL, PL/SQL development, database performance tuning, and data integration. The ideal candidate will have experience developing complex database solutions, working with large data sets, and integrating Oracle with modern data platforms such as Snowflake. This is a Full-Time, On-Sight employment opportunity based in Plano, TX or Cary, NC.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.Develop solutions for data maintenance, migration, copy, reconciliation, archival, and purge activities.Build and support Oracle-to-Snowflake integrations, data movement, transformations, and validation processes.Troubleshoot database and data issues and ensure 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 business stakeholders, application developers, data engineers, architects, and QA teams.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.A 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.Strong hands-on experience across analysis, design, development, testing, debugging, and production support. Good to haveSnowflake 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 is a plus.Together, as owners, let's turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential because... You are invited to be an owner from day 1 as we work together to bring our Dream to life. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction. Your work creates value.You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise. You'll shape your career by joining a company built to grow and last. You'll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons. Come join our team—one of the largest IT and business consulting services firms in the world.","company":"CGI","rawCompany":"cgi","city":"Cary","state":"NC","isRemote":false,"isActive":false,"createdAt":"2026-09-26T12:29:17.857Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1211.00","title":"Computer Systems Analysts","slug":"computer-systems-analysts"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Oracle PL/SQL Developer - Financial Services","description":"Oracle PL/SQL Developer – Financial ServicesWe are seeking an experienced Oracle PL/SQL Developer with strong hands-on expertise in Oracle SQL, PL/SQL development, database performance tuning, and data integration. The ideal candidate will have experience developing complex database solutions, working with large data sets, and integrating Oracle with modern data platforms such as Snowflake. This is a Full-Time, On-Sight employment opportunity based in Plano, TX or Cary, NC.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.Develop solutions for data maintenance, migration, copy, reconciliation, archival, and purge activities.Build and support Oracle-to-Snowflake integrations, data movement, transformations, and validation processes.Troubleshoot database and data issues and ensure 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 business stakeholders, application developers, data engineers, architects, and QA teams.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.A 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.Strong hands-on experience across analysis, design, development, testing, debugging, and production support. Good to haveSnowflake 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 is a plus.Together, as owners, let's turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential because... You are invited to be an owner from day 1 as we work together to bring our Dream to life. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction. Your work creates value.You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise. You'll shape your career by joining a company built to grow and last. You'll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons. Come join our team—one of the largest IT and business consulting services firms in the world.","datePosted":"2026-09-26T12:29:17.857Z","dateModified":"2026-09-26T12:29:17.857Z","hiringOrganization":{"@type":"Organization","name":"CGI","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Cary","addressRegion":"NC","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"d96558ea38c80c8e7524c14e"},"url":"https://jobsearcher.com/jobs/d96558ea38c80c8e7524c14e"}}