Lead Snowflake Data EngineerLocation: Rosemont, IL (Initial Remote)Mandatory skills: AWS, Snowflake, Informatica, Python• Experience working on Snowflake.• Experience working on Informatica Cloud (IICS).• Experience working on AWS data environment – S3, EMR, Lambda, SQS etc.• Strong background in developing technical solutions for Cloud data warehouse and data lakes.• Exposure to Python is a plus.• Experience designing and troubleshooting complicated data extraction routines and real time / batch integrations.• Experience extracting and processing data from multiple data sources such as: Databases (Exadata, Oracle, Snowflake), Applications, Web Services (SOAP/REST), flat files (*.csv, *.txt, *.xml, *.json) and streaming data.• Experience on Migration of Data Warehouse from on premises to cloud (Snowflake preferred).• Exposure to version control (GitLab, GitHub, BitBucket) and CI/CD (Bamboo) tools and methodologies• Experience writing and troubleshooting complex SQL queries.• Experience working with Fivetran.