Us_east | It Consultant - Clou..

Job Description Description:

Submit candidates under their legal name and use only Capgemini template"

Role: 77TFSE - Sowflake Architect Work location: Charlotte, NC - onsite. Background check MANDATORY Request ID: 77TFSE Pursuit

The main visas we should accept are the following: US Citizen

JOB DESCRIPTION US Citizen is a must.

5-10 years of experience in data warehousing. Understanding of data models and co-cordiante with Client to capture requirements. Experience in snowflake and control M • Data Architecture Design: Develop/Modify the architecture for the EDW, including data models, data quality standards, data integration strategies, data migration and data warehousing technologies to effectively store and access data from various sources as per the requirments.
• Business Requirements Gathering: Collaborate with business stakeholders to understand their data needs, identify key performance indicators (KPIs), and translate them into data warehouse requirements. • Data Integration and ETL Development: Oversee the design and implementation of ETL processes to extract data from various source systems, transform it into a consistent format, and load it into the EDW. • Data Modeling: Create dimensional data models to optimize querying and reporting on the data within the EDW. • Performance Optimization: Monitor and optimize the performance of the EDW to ensure efficient data access and query response times. • Data Governance: Establish data governance policies and procedures to ensure data quality, consistency, and compliance with regulations. • Overall Technical Leader: Provide technical guidance on data warehouse technologies, tools, and best practices to the relevant stakeholders. • Collaboration with Stakeholders: Work closely with business users, data analysts, and application developers to understand their data needs and deliver data-driven insights. Required Skills and Experience: • Data Warehousing Expertise: Deep understanding of data warehousing concepts, architectures, and technologies like dimensional modeling, star schema, snowflake schema, and ETL processes. • Database Management Systems (DBMS): Proficient in SQL’s and Databases like Snowflake, Oracle, SQL Server, or Teradata , Control M • Data Modeling Tools: Experience with data modeling tools like Erwin, PowerDesigner, or other industry-standard modeling software. • Data Integration Tools: Familiarity with data integration tools for ETL development and data cleansing. Communication Skills: Excellent communication skills to effectively collaborate with stakeholders from various departments

"Mandatory:

Please use candidate's legal name always Please add the candidate’s ID at the end of resume Videocalls for interviews are a MUST Please add in the comments section for each Candidate the following:"

Please send Candidates with this information Possible 3 Month CTH Legal name: Location (USA, City and State): Relocate? Rate: Travelling availability (if required) Availability: Phone #: Mobile#: LinkedIn: Skype ID: Email address: Visa type: Visa expiring date: Hiring Status: If ex Capgemini employee (Y/N): If yes, please share client's name, manager and email. If the resource has a visa, what company owns it? Are you working directly with the contractor’s visa holder? Had the contractor worked in Capgemini before SKYPE INTERVIEW IS MANDATORY

Resumes will be rejected for the following reasons:

• Different format

• Missing details in comments section

• Missing text box in the header

• Photo ID included containing personal information other than legal name and photo

Estefania Ocheita External Resource Manager (ERM) | SubCo Staffing Center Capgemini North America | Guatemala

Named Job Posting? (if Yes - needs to be approved by SCSC)

try { var fgTooltip = new FG.Tooltip({ element: $('#cf_descz1901221542246011397492e'), text: "To\x20be\x20populated\x20with\x20\x22Yes\x22\x20when\x20Job\x20Seeker\x20to\x20be\x20onboarded\x20is\x20already\x20known\x20at\x20the\x20time\x20of\x20Job\x20Posting\x20creation.\x20Must\x20be\x20approved\x20by\x20SCSC." }).initialize(); } catch(err) {}

Additional Details Global Grade : CNamed Job Posting? (if Yes - needs to be approved by SCSC) : NoRemote work possibility : NoGlobal Role Family : 60236 (P) Software EngineeringGlobal Technical Skills Family : 6313 (T) Application Server TechnologiesLocal Role Name : Sowflake ArchitectLocal Skills : Hannah MutchLanguages Required: : English