What are the responsibilities and job description for the Consultant position at capgemini?
Drive performance analysis and optimization of SQL queries Oracle Snowflake troubleshoot complex data and systems issues and lead root cause analysis for data quality
Partner with technology and business stakeholders to define requirements functional specifications and operational architecture for strategic global programs Provide input to data strategy and actively influence software development process improvements
Key Responsibilities:
Analyze optimize and benchmark SQL queries across Oracle and Snowflake diagnose and resolve highly complex performance and data quality issues through rigorous root cause analysis
Collaborate with Universal Client Manager technology teams to define specifications design documents and functional use cases for system enhancements and integrations
Elicit challenge and prioritize business requirements using standard processes and templates translate requirements into clear functional designs user stories and use case documentation
Develop project scope objectives constraints and assumptions for large strategic multiyear initiatives ensure alignment to business outcomes and operational architecture
Provide consultation to IT and business management on applying technology to business opportunities plan and guide implementation of cross functional applications and systems
Participate in and provide guidance on technical design reviews test planning and user documentation ensure end to end traceability from requirements through testing and release
Manage scope changes and dependencies using formal requirements management principles including change control traceability and stakeholder signoffs
Gather and analyze quantitative and qualitative data to develop recommendations addressing strategic objectives across multiple global business and technology areas
Engage in industry forums to maintain current domain knowledge incorporate best practices into solution design and process improvements
Apply experience with software systems development processes to design and implement improved methodologies actively influence continuous improvement in SDLC and data practices
May allocate and coordinate work within a team or project ensuring delivery quality and timeline adherence
Required Qualifications:
Experience working with Collibra
Proven expertise in SQL performance analysis and tuning across Oracle and Snowflake environments
Hands-on experience investigating and remediating data quality issues including root cause analysis and corrective preventive actions
Demonstrated ability to elicit and document business requirements and translate them into functional specifications use cases and technical designs
Familiarity with operational architecture systems integration and crossfunctional application implementation
Proficiency with requirements management practices change control traceability and participation in testing test plans UAT defect triage
Strong stakeholder management and communication skills with the ability to consult and influence across business and technology teams
Preferred Qualifications:
Experience working with Artificial Intelligence
Experience working with Universal Client Manager or similar client platform technologies
Exposure to largescale strategic multiyear programs spanning global business and technology areas
Knowledge of modern SDLC practices agile methodologies and process improvement frameworks
Participation in industry forums or professional communities related to data analytics or enterprise architecture
Core Competencies:
Analytical problem solving and structured root cause analysis
Requirements elicitation and prioritization
Technical design literacy and testing rigor
Data strategy awareness and business acumen
Stakeholder engagement and consultative communication
Process improvement and change management
Must have skills:
SQL Oracle Snowflake Collibra Financial DMN Expertise
Good to have skills:
Data Modeling Banking Structures AI Data Analytics Exposure Enterprise Data SDLC Practices
The pay range that the employer in good faith reasonably expects to pay for this position is $29.12/hour - $45.51/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.
Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.
Salary : $29 - $46