Note: The job is a remote job and is open to candidates in USA. PeopleSERVE, Inc. is a company focused on delivering high-quality data solutions. They are seeking a Data Engineer who will be responsible for developing ELT/ETL pipelines, optimizing SQL performance, and working with AWS services to manage data on cloud platforms.
Responsibilities
- You must have proven track record of working in collaborative teams to deliver high quality data solutions in a multi-developer agile environment following design & coding best practices
- You must be an expert in using SQL queries with UNIX shell /Python scripting skills
- You should have experience of using AWS services like EC2, S3, EMR to move data onto cloud platform and experience with Enterprise data lake strategy and use of Snowflake (AWS) is a big plus
- You must have knowledge to develop ELT/ETL pipelines to move data to and from Snowflake data store using combination of Python and Snowflake Snow SQL is a big plus
- You should have experience in SQL performance optimization for large data volumes
- You should have proven analytical and problem-solving skills
- You should be strong in Database and Data Warehousing concepts
- You must be able to work independently in a globally distributed environment
- You must have superior SQL and Data Modeling skills and experience performing deep data analysis on multiple database platforms like Oracle and Snowflake
- You should have experience in working with devops tools for code migrations
- Nice to have working experience in Control-M or similar scheduling tools
- Nice to have adequate knowledge on DevOps, JIRA and Agile practices
Skills
- You must have proven track record of working in collaborative teams to deliver high quality data solutions in a multi-developer agile environment following design & coding best practices
- You must be an expert in using SQL queries with UNIX shell /Python scripting skills
- You should have experience of using AWS services like EC2, S3, EMR to move data onto cloud platform and experience with Enterprise data lake strategy and use of Snowflake (AWS) is a big plus
- You must have knowledge to develop ELT/ETL pipelines to move data to and from Snowflake data store using combination of Python and Snowflake Snow SQL is a big plus
- You should have experience in SQL performance optimization for large data volumes
- You should have proven analytical and problem-solving skills
- You should be strong in Database and Data Warehousing concepts
- You must be able to work independently in a globally distributed environment
- You must have superior SQL and Data Modeling skills and experience performing deep data analysis on multiple database platforms like Oracle and Snowflake
- You should have experience in working with devops tools for code migrations
- Nice to have working experience in Control-M or similar scheduling tools
- Nice to have adequate knowledge on DevOps, JIRA and Agile practices
Company Overview
Company H1B Sponsorship