Title - Senior Software Engineer - Snowflake

Location - Chicago IL (Hybrid)

Duration – Fulltime

Key Responsibilities

• Designing and implementing data warehouse solutions using Snowflake architecture
• Developing and optimizing data pipelines and ETL processes within Snowflake.
• Utilizing Snowflake features such as Snowpipe, SnowSQL, and data sharing for efficient data management.
• Designing and configuring optimal virtual warehouses to meet business SLAs.
• Implementing security features including SSO, column masking, and role-based administration.
• Developing and maintaining stored procedures, queries, and data models to support BI visualizations
• Staying updated on new technologies and product updates.

Required Skills

• 2 years of Hands on experience in Snowflake cloud data warehouse
• Experience of designing warehouse and pipelines with Snowflake architecture Data model
• Well versed with Snowflake concepts like Snowpipe SnowSQL Cloud services Data sharing Reader accounts Designing optimal virtual warehouses as per the business SLAs optimized data distribution clustering keys usage of materialized views
• Minimum of 6 years of Overall IT experience including experience as Technical lead in Data warehousing technologies including modern cloud data warehousing
• Hands on Experience in ELT tools like Informatica AWS glue or any other parallel ELT tools
• Experience of semi structured XML JSON and unstructured data handling 
• Knowledge of how to implement security features like SSO column masking role based administration BI Reporting ETL
• Should have designed and developed stored procedures queries ETL Process views Data models necessary to support BI Visualizations
• Should be able to effectively handle reports performance and administration 
• Strong knowledge of ELT ETL concepts design and coding
• Candidate should be eager to learn advance technologies new product updates etc learn and train other team members
• Excellent analytical skills and communication skills written verbal and presentation
• Additional knowledge of complex source system data structures preferably in Financial services preferred Industry and reporting related developments will be an advantage Using warehouse data to generate reports to support business decision making and business performance monitoring Generating and delivering quality reports to customers and performing quality assurance checks on reports Develop Customize
• Deploy maintain data visualizations as per client business requirements.
• Should have thorough knowledge in creating dynamic visualizations with multiple concepts
• Experience working with clients throughout various parts of implementation lifecycle
• Proactive with Solution oriented mindset ready to learn new technologies for Client requirements

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

About Capgemini

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion.
 
Get The Future You Want | www.capgemini.com

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 of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law