Job Title: ETL/ELT Developer
Location: Onsite from Day One – San Mateo, California
Job Type: Contract
Duration: Long Term
Rate: $65/hr (all-inclusive)
Experience Range: 10 -15years
Start Date: ASAP
About Technology&
Technology& specializes in delivering high-impact technology solutions across industries, with a focus on data analytics, cybersecurity, cloud computing, and staff augmentation. Our mission is to empower clients by driving digital transformation and operational efficiency through innovative technology solutions.
Job Description
We are seeking an experienced ETL/ELT Developer to join our team onsite in San Mateo, California. The ideal candidate will have a strong background in SQL, data warehouse design, and hands-on experience with Snowflake.
Key Responsibilities
- Develop and maintain ETL/ELT processes for data warehouse integration from various sources.
- Manipulate and manage large datasets using SQL.
- Design and implement ELT pipelines in Snowflake managed service.
- Orchestrate ELT workflows using Airflow.
- Execute full and incremental ETL processes using Informatica Power Center.
- Work with both OLTP and dimensional schemas.
- Collaborate in a team environment aligned with the PST time zone.
- Provide production support and resolve issues efficiently.
Required Skills
- 8+ years of experience as an ETL/ELT Developer.
- Expertise in SQL for managing and manipulating large datasets.
- Experience with Snowflake for ELT development.
- Familiarity with Airflow for ELT orchestration.
- Strong understanding of data warehouse design principles.
- Proficiency in Informatica Power Center for ETL.
- AWS Cloud experience.
Preferred Skills
- Experience with Python for data extraction and manipulation.
- Familiarity with AWS analytical services such as S3, EC2, EMR, Glue, and Athena.
- Experience with AWS Terraform.
- Knowledge of New Relic setup and maintenance.
- Familiarity with GIT and Rally for version control and task tracking.
- Experience with Scala.
- Proficiency in reporting tools such as MicroStrategy.
Equal Opportunity Statement
We believe diversity drives innovation. At Technology&, we are committed to fostering an inclusive environment where all employees feel valued and respected. We welcome applicants from all backgrounds and do not discriminate based on race, religion, gender, sexual orientation, age, disability, or any other legally protected status.