Data / Database Engineer - SQL, Oracle, PL/SQL, Informatica, ETL, Powercenter

Job Location - Westlake TX (Day One Onsite - Hybrid)

About The Role

• We are seeking a highly skilled Database Engineer with strong expertise in SQL, Oracle PL/SQL, and data integration to support enterprise data solutions.
• This role combines data analysis, database development, and cloud-based data engineering, requiring hands-on experience with large datasets, data pipelines, and modern cloud platforms such as AWS and Snowflake.
• You will collaborate closely with business stakeholders and technical teams to design, analyze, and deliver scalable, high-quality data solutions that drive business insights.

Key Responsibilities

• Develop, optimize, and maintain complex SQL and PL/SQL queries, stored procedures, scripts, SQS and SNS
• Perform data analysis, data profiling, and data quality validation on large datasets
• Design and implement data ingestion and integration pipelines across systems
• Work with conceptual, logical, and physical data models to support database design
• Support ETL processes, transformation logic, and performance tuning
• Build and maintain cloud-based data solutions using AWS (S3, EC2, Lambda) and Snowflake
• Work with data pipelines and streaming solutions (e.g., Kafka - working knowledge)
• Support data replication and synchronization strategies across platforms
• Conduct data exploration and impact analysis to support business decisions
• Collaborate with stakeholders to translate business requirements into data solutions
• Review system architecture and identify gaps, dependencies, and optimization opportunities
• Prepare and present data insights and technical solutions to business and technical audiences
• Work independently and manage deliverables in an Agile environment

Required Skills & Qualifications

• Strong proficiency in SQL and Oracle PL/SQL
• Hands-on experience with data ingestion, data integration, and ETL processes
• Experience in database analysis, data profiling, and large dataset handling
• Solid understanding of data modeling (logical, conceptual, physical)
• Experience with cloud platforms (AWS, Snowflake)
• Working knowledge of Python for scripting and automation
• Exposure to Kafka or streaming data pipelines (preferred)
• Familiarity with distributed databases (e.g., YugabyteDB) and data replication concepts
• Strong analytical and problem-solving skills
• Ability to work independently and manage priorities effectively
• Strong communication and presentation skills

Nice to Have

• Experience with query optimization, indexing, and performance tuning
• Familiarity with CI/CD tools (e.g., Jenkins) and data pipeline automation
• Experience working in Agile environments (Scrum/Kanban, Jira, Bitbucket)
• Exposure to multi-cloud or modern data platforms

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 o