Us_east | Desktop Engineer_l4

Job Description Description:

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

Role: 9OT167 - Snowflake Engineer C-Grade Work location: Greensboro, NC - onsite Background check MANDATORY Request ID: 9OT167 Pursuit

"The main visas we should accept are the following: H1B L-2 EAD H-4 EAD AOS EAD Green Card Holder US Citizen***"

JOB DESCRIPTION The successful candidate will design, build, and maintain a robust and scalable data infrastructure to support business intelligence, analytics, and data science initiatives. The responsibility includes managing the end-to-end data lifecycle, including data ingestion, transformation, storage, and accessibility for various stakeholders.

Required Skills and Experience: • Extensive Data Engineering Experience: A minimum of 10+ years of proven experience in Data Engineering is required, including designing, developing, and supporting complex data environments. • Data Warehouse Design and Development:

1. Experience in designing, implementing, and optimizing enterprise data warehouses (EDWs) is required.

2. Expertise in data modeling and schema design (e.g., relational, dimensional) is required to ensure efficient data storage and retrieval.

3. Snowflake: Hands-on experience with Snowflake data warehousing, including optimization techniques, is required. • ETL/ELT and Data Integration:

4. A deep understanding and experience with ETL/ELT processes and tools are required.

5. Matillion and Fivetran HVR: Proficiency with Matillion and Fivetran HVR for building data pipelines is required.

6. Experience integrating data from various sources using APIs, EDI, SFTP, and other methods is required. • Data Modeling and Design:

7. A strong understanding of data modeling principles and best practices is required.

8. The ability to translate business requirements into efficient data models is required. • Data Quality and Governance:

9. Experience implementing data quality checks and validation processes is required.

10. Familiarity with data governance principles and best practices is required.

11. Ensuring data security and access controls are implemented and maintained is required. • Data Security:

12. Experience implementing industry-standard data security measures, including encryption and access controls, is required.

13. Familiarity with data privacy regulations (e.g., GDPR) is required. • Testing and Validation:

14. Experience in designing and executing integration testing for data pipelines and EDW is required.

15. The ability to implement robust error handling and recovery mechanisms is required. • Collaboration and Communication:

16. The ability to work collaboratively in cross-functional teams, including data scientists, analysts, and business stakeholders, is required.

17. Strong communication skills, both verbal and written, with the ability to explain complex technical concepts to non-technical audiences, are required. • Agile Methodologies:

18. Experience working in Agile/Scrum development methodologies is required. • Data Integrity and Accuracy:

19. Experience ensuring data integrity and accuracy across various data sources is required. • BI and/or EDW Lifecycle Implementation:

20. Experience with multiple BI and/or EDW lifecycle implementations (e.g., blueprinting, build/test, go-live, support) is required. Preferred Skills: • Experience with external partner integrations, including eCommerce, EDI, WMS, and B2B integration. • Experience with Snowflake Marketplace integrations. • Proficiency in SQL and scripting languages (e.g., Python, Bash). • Experience with data visualization tools (e.g., Power BI). • Cloud computing experience (e.g., AWS, Azure, Google Cloud). • Familiarity with containerization technologies (e.g., Docker, Kubernetes). Key Responsibilities: • Design, develop, and maintain efficient and scalable data pipelines to extract, transform, and load data from various sources. • Build and maintain data models within the Enterprise Data Warehouse, ensuring data is organized and accessible for analysis and reporting. • Gather business reporting requirements and translate them into technical specifications for data solutions. • Develop and implement ETL/ELT solutions to support data integration needs. • Integrate data from external partner applications and other internal systems. • Develop and support dashboards, analytics, and reports using Power BI. • Perform integration testing to ensure data quality and system functionality. • Design and implement data security measures and access controls. • Collaborate with cross-functional teams to ensure data solutions meet business needs. • Ensure data integrity and accuracy across the EDW solution and source systems. • Provide support for production data environments and troubleshoot data-related issues. • Participate in cutover planning and execution for new data solutions. • Stay up-to-date with industry trends and emerging technologies in data engineering.

"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 : DNamed Job Posting? (if Yes - needs to be approved by SCSC) : NoRemote work possibility : NoGlobal Role Family : 60243 (P) Delivery ExcellenceGlobal Technical Skills Family : 6269 (T) Office / Desktop SolutionsLocal Role Name : Snowflake EngineerLocal Skills : Enter detailed local skills if neededLanguages Required: : Hannah Mutch