Capgemini
Google cloud Architect
Capgemini, New York, New York, us, 10261
Explore our latest thought leadership, ideas, and insights on the issues that are shaping the future of business and society.Choose a partner with intimate knowledge of your industry and first-hand experience of defining its future.Discover our portfolio – constantly evolving to keep pace with the ever-changing needs of our clients.Become part of a diverse collective of free-thinkers, entrepreneurs and experts – and help us to make a difference.We are a global leader in partnering with companies to transform and manage their business by harnessing the power of technology.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.Client Location: New York, NY
Job Description
7+ years of experience in Google Cloud Architecture.Expert in analyzing existing Oracle and SQL Server database schemas, stored procedures, and data workflows.Data expert in converting PL/SQL and T-SQL code to BigQuery SQL and/or Python User-Defined Functions (UDFs).Collaborate with cross-functional teams including data engineers, analysts, and business stakeholders.Experience in identifying and implementing opportunities for process improvement and automation in the new environment. Lead the implementation of data governance and security measures in the new BigQuery environment.Adaptability and willingness to learn new technologies.Ability to work effectively in a fast-paced collaborative environment.Understanding of machine learning concepts and their integration with BigQuery (Preferred, not mandatory).Lead the end-to-end planning, execution, and validation of stored procedure migrations including schema transformation, SQL rewriting, and query optimization for BigQuery.Design and define the architecture and migration strategies for converting Oracle and SQL Server stored procedures, triggers, and functions to BigQuery.Identify and deploy tools and automation techniques for schema conversion, stored procedure migration, and testing. Develop custom scripts if necessary. Develop comprehensive documentation outlining the migration process, architectural decisions, testing procedures, and post-migration operations.Lead the testing and validation of migrated stored procedures ensuring correctness, performance, and adherence to best practices.Collaborate with engineering, DBA, and data analytics teams to align architectural decisions with broader business and technical goals.Provide technical leadership throughout the migration process.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: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.Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.Salary Transparency:
Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to the highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The base salary range for the tagged location is $103,330 - $128,656/year.This role may be eligible for other compensation including variable compensation, bonus, or commission. Full-time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.Note : No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.
#J-18808-Ljbffr
Job Description
7+ years of experience in Google Cloud Architecture.Expert in analyzing existing Oracle and SQL Server database schemas, stored procedures, and data workflows.Data expert in converting PL/SQL and T-SQL code to BigQuery SQL and/or Python User-Defined Functions (UDFs).Collaborate with cross-functional teams including data engineers, analysts, and business stakeholders.Experience in identifying and implementing opportunities for process improvement and automation in the new environment. Lead the implementation of data governance and security measures in the new BigQuery environment.Adaptability and willingness to learn new technologies.Ability to work effectively in a fast-paced collaborative environment.Understanding of machine learning concepts and their integration with BigQuery (Preferred, not mandatory).Lead the end-to-end planning, execution, and validation of stored procedure migrations including schema transformation, SQL rewriting, and query optimization for BigQuery.Design and define the architecture and migration strategies for converting Oracle and SQL Server stored procedures, triggers, and functions to BigQuery.Identify and deploy tools and automation techniques for schema conversion, stored procedure migration, and testing. Develop custom scripts if necessary. Develop comprehensive documentation outlining the migration process, architectural decisions, testing procedures, and post-migration operations.Lead the testing and validation of migrated stored procedures ensuring correctness, performance, and adherence to best practices.Collaborate with engineering, DBA, and data analytics teams to align architectural decisions with broader business and technical goals.Provide technical leadership throughout the migration process.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: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.Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.Salary Transparency:
Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to the highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The base salary range for the tagged location is $103,330 - $128,656/year.This role may be eligible for other compensation including variable compensation, bonus, or commission. Full-time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.Note : No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.
#J-18808-Ljbffr