Job Title: ETL Developer
Location: Onsite (Seattle, WA)
Duration: 6+ months
Job Description:
Key Responsibilities:

• Work on database access management and ensure that ETL data pipelines are running as expected
• Drive technical innovation and efficiency in infrastructure operations via automation.
• Create processes that enhance operational workflow and provide positive customer impact.
• Dive deep to resolve problems at their root, looking for failure patterns amenable to long-term solutions via simplification and automation.
• Avoid re-inventing the wheel and prefer appropriately simple, repeatable solutions over more complex and failure prone ones.
• Recognize and adopt best practices in documentation, testing, security, operational support at scale, and efficient use of resources.
• Develop appropriate metrics to demonstrate performance at improving operational efficiency.

 
Core Requirements:

• In depth knowledge of & experience of working in large data warehouse project
• Strong system troubleshooting skills.
• Proficiency and experience in automation via Perl/Python programming and shell scripting.
• Demonstrable grasp of security best practices in server configuration, tool development, and access controls.
• Experience in building SQL queries.
• Experience in building and troubleshooting ETL pipeline.
• Experience in working on creating table/view and perform Data analysis
• Experience in project and incident management

 
Highly Desirable Attributes:

• Knowledge of services such as S3, Glue, Redshift, Apache Airflow, Neo4j graph
• Knowledge of VCS (git, mercurial, svn).
• Understanding of AWS technologies (aws.amazon.com).
• Experience deploying or managing servers in large-scale, geographically diverse environments.
• Understanding & experience of managing and monitoring large scale disk sub-systems.

Must have

• SQL (Intermediate)
• ETL Data Pipeline /Database experience
• Ticketing systems

 

 


At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $40.00/hr.