ETL Tech Lead
Share
Job Location:
Windsor, NC - USA
Monthly Salary:
Not Disclosed
Posted on:
3 hours ago
Vacancies:
1 Vacancy
Job Summary
Job Title / Role: ETL Tech Lead (Snowflake & SQL)
Key Skills: Snowflake SQL AWS APIs and flat files.
Experience: 10
Location: Windsor CT (Day 1 On-site)
Shift: General.
Mode: On-Site
Job Type: CTH
Key Responsibilities:
- Design develop and optimize ETL workflows and data pipelines using Snowflake and AWS services.
- Implement data ingestion from various sources including APIs databases and flat files.
- Ensure data quality integrity and consistency across all ETL processes.
- Collaborate with data architects analysts and business stakeholders to understand data requirements.
- Monitor and troubleshoot ETL jobs and performance issues.
- Automate data workflows and implement CI/CD practices for data pipeline deployment.
- Maintain documentation for ETL processes data models and data flow diagrams.
Required Skills & Qualifications:
- Bachelors degree in computer science Information Systems or related field.
- 9 years of experience in ETL development and data engineering.
- Hands-on experience with Snowflake including data modeling performance tuning and SQL scripting.
- Proficiency in AWS services such as S3 Lambda Glue Redshift and CloudWatch.
- Strong programming skills in Python or Scala for data processing.
- Experience with orchestration tools like Apache Airflow or AWS Step Functions.
- Familiarity with version control systems (e.g. Git) and CI/CD pipelines.
- Excellent problem-solving and communication skills.
Preferred Qualifications:
- Snowflake certification.
- Experience with data visualization tools (e.g. Tableau Power BI).
- Knowledge of data governance and security best practices.
- Experience in Agile/Scrum development environments
Key Skills
- SQL
- Pentaho
- PL/SQL
- Microsoft SQL Server
- SSIS
- Informatica
- Shell Scripting
- T Sql
- Teradata
- Data Modeling
- Data Warehouse
- Oracle
