Job Information
Capgemini Senior Software Engineer - Snowflake in Chicago, United States
Senior Software Engineer - Snowflake
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
Ref: 1803995
Posted on: May 1, 2024
Experience level: Experienced (non-manager)
Contract Type: Permanent
Location:
Chicago, US
Department: Financial Services
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.