| Only USC & GC :: Lead Data Engineer at Boston, MA - Hybrid (Local to MA Only) at Boston, Massachusetts, USA |
| Email: [email protected] |
| From: Avinash Kumar, ZealHire Inc [email protected] Reply to: [email protected] Position: Lead Data Engineer Location: Boston, MA - Hybrid (Local to MA Only) Duration: Long-Term Contract Visa Status: Only USC/GC Desired Years of experience:- 11+ Years Job Description: Need LinkedIn(With Picture) and DL No Google Voip Number C lient is looking ONLY onsite LOCAL to MA consultants for this position Health care domain experience is MUST. Snowflake, AWS, Glue are the key skills Must have credible and verifiable experience on Snowflake and not just certification Remote is okay for strong candidates. Job Description Must Have: Resource with minimum 10 years of experience in DWH area who can work independently. Strong hands-on SQL skills/ Stored procedures / writing complex queries Good knowledge of Data warehousing and all related concepts0Hands on experience in Data Ingestion from different sources Candidate must be strong in SQL Must have 4 years of Relevant experience in working with Snowflake cloud data warehouse and exposure to AWS S3. Implementing SCD Techniques like slowly changing dimensions (type1, type2 and type3). Experience in working with AWS S3 and Snowflake cloud data warehouse. Good exposure in Snowflake Cloud Architecture and SnowSQL and SNOWPIPE for continuous data ingestion. Handling large and complex data sets like JSON, ORC, PARQUET, CSV files from various sources like AWS S3. Hands-on experience in bulk loading and unloading data into Snowflake tables. Experience in writing complex SQL scripts using Statistical Aggregate functions and Analytical functions to support ETL in snowflake cloud data warehouse. Experience with performance tuning of SnowFlake data warehouse with Query Profiler, Caching and Virtual data warehouse scaling Knowledge on redshift (Good to have) Knowledge on AWS EC2, lambda Good to have python Keywords: cprogramm sthree green card Massachusetts Only USC & GC :: Lead Data Engineer at Boston, MA - Hybrid (Local to MA Only) [email protected] |
| [email protected] View all |
| Thu Jul 25 00:16:00 UTC 2024 |