Architect

Capgemini; New York (NY); On-site; USD 99,712 - 168,716; Full time

Job summary

A multinational consulting firm in New York is seeking a Senior Consultant for Talent Acquisition in the Financial Services sector. The ideal candidate has more than 10 years of IT experience in BFSI and Insurance, with strong expertise in data engineering and cloud technologies like Snowflake. Responsibilities include managing data ingestion and migrations to Snowflake, along with query optimization. Competitive compensation based on experience.

Qualifications

• 10+ years of IT experience in BFSI and Insurance domains.
• Extensive experience in data engineering and cloud platform administration.

Responsibilities

• Manage data ingestion, data lakes, and data warehouses.
• Migrate databases to Snowflake using AWS/Azure.
• Optimize Snowflake queries and manage cloud resources.

Skills

Data Engineering

Data Analysis

Big Data Pipelines

Snowflake Utilities

Tools

AWS

Azure

SnowSQL

Snowpark

Job description

This range is provided by Capgemini. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$99,712.00/yr - $168,716.00/yr

Sr. Consultant, Talent Acquisition North America - Financial Services Strategic Business Unit at Capgemini

Job Description:

Responsibilities

• 10+ years of IT Experience in BFSI and Insurance.
• Extensive experience on Data Engineering field including ingestion, Data lake, Datawarehouse, reporting and analytics.
• Strong knowledge and experience on Data Analysis, Big Data Pipelines, Data reconciliation, Data transformation rules, data flow diagram including data replication, data integration and data orchestration tools.
• Hands-on experience in migrating other databases to Snowflake using AWS/Azure.
• Experience in Snowflake utilities - Snow SQL, Snowpark, SnowPipe, Tasks, Streams, Stored Procedures, Time-Travel, Resource Monitor, Data sharing, zero-copy cloning, Data Masking and Data Replication.
• Extensive knowledge in Snowflake query and cost optimization techniques.
• Knowledgeable in Snowflake on Cloud Platform Administration and Account setup.

Qualifications

• 10+ years of IT experience in BFSI and Insurance domains.
• Extensive data engineering experience including ingestion, data lake/warehouse, reporting, and analytics.
• Strong ability in data analysis, big data pipelines, data reconciliation, data transformation rules, data flow diagrams, data replication, integration, and orchestration tools.
• Hands-on Snowflake migration experience from other databases using AWS or Azure.
• Proficient with Snowflake utilities (SnowSQL, Snowpark, SnowPipe, Tasks, Streams, Stored Procedures, Time Travel, Resource Monitor, Data Sharing, Zero-Copy Cloning, Data Masking, Data Replication).
• Knowledge of Snowflake query optimization and cost control techniques.
• Cloud platform administration and account setup for Snowflake.

Note: This section preserves the original job information while presenting it in a clean, structured format without extraneous postings or market data.