What are the responsibilities and job description for the Snowflake ETL Developer position at 4 Consulting Inc?
Job Title: Snowflake ETL Developer
Location: Hopewell, VA
Duration: long term
Job ID: 4CI -7838
Required Qualifications:
- Experience with Snowflake data warehouse development.
- Strong SQL development and database management skills.
- Hands-on experience with AWS Glue and ETL/ELT pipeline development.
- Knowledge of data warehousing concepts and data modeling.
- Experience with data ingestion and transformation techniques.
- Design, develop, and maintain ETL/ELT processes for data integration and transformation.
- Build and optimize scalable data pipelines using Snowflake and AWS services.
- Develop and maintain SQL queries, stored procedures, user-defined functions (UDFs), and streams in Snowflake.
- Implement data ingestion processes using Snowpipe, COPY INTO, and staged data loads.
- Create and manage AWS Glue jobs, crawlers, and data catalogs.
- Perform data validation, quality checks, and troubleshooting to ensure data accuracy and reliability.
- Experience with AWS Lambda and event-driven architectures.
- Proficiency in Python for data engineering tasks.
- Experience with Git and CI/CD tools.