Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world.
Location - Atlanta GA
Job Description
Job Summary:
We are looking for a highly skilled Senior PL/SQL Developer with 10 to 15 years of experience. The candidate should have a deep understanding of Oracle databases, complex SQL queries, and PL/SQL development. The ideal candidate will possess a strong background in working with SQL Server and Oracle databases, specifically in migrating SQL Server queries to Oracle. Additionally, a basic understanding of Python or R for validation and reconciliation tasks is required. Fluency in both spoken and written English is essential.
Want more jobs like this?
Get jobs in Atlanta, GA delivered to your inbox every week.
Key Responsibilities:
- Design, develop, and optimize complex SQL queries for data extraction, reporting, and integration.
- Migrate and translate SQL Server queries into Oracle while ensuring optimized performance and functionality.
- Troubleshoot and resolve migration-related issues in Oracle PL/SQL code, ensuring smooth migration processes.
- Perform validation and reconciliation of data during migration projects to ensure accuracy and consistency.
- Develop and maintain efficient Oracle PL/SQL code for applications and databases, focusing on performance optimization and scalability.
- Leverage Python or R for basic data validation and reconciliation tasks, aiding in automation and accuracy.
- Work closely with various teams including database administrators, software engineers, and business analysts to design robust database solutions.
Qualifications:
- Oracle Database Expertise (7-10 Years):
- Extensive experience with Oracle database development, including tuning and optimization.
- PL/SQL Experience (7-10 Years):
- Proven experience in PL/SQL development, with a focus on high-performance code.
- SQL Experience (7-10 Years):
- Mastery of SQL, with the ability to write, debug, and optimize complex queries.
- SQL Server & Oracle Experience:
- Strong experience with both SQL Server and Oracle databases, including migrating SQL Server queries to Oracle.
- Migration & Issue Resolution:
- Demonstrated ability to troubleshoot and resolve Oracle PL/SQL code migration issues.
- Basic Python/R:
- Familiarity with Python or R for data validation and reconciliation purposes.
Preferred Skills:
- Experience with database performance tuning and optimization.
- Familiarity with Agile or Scrum methodologies.
- Hands-on experience with version control tools like Git.
- Experience with ETL tools and processes.
Life at Capgemini
Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
- Flexible work
- Healthcare including dental, vision, mental health, and well-being programs
- Financial well-being programs such as 401(k) and Employee Share Ownership Plan
- Paid time off and paid holidays
- Paid parental leave
- Family building benefits like adoption assistance, surrogacy, and cryopreservation
- Social well-being benefits like subsidized back-up child/elder care and tutoring
- Mentoring, coaching and learning programs
- Employee Resource Groups
- Disaster Relief
Disclaimer
Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.
Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law
Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fuelled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion.