Overview
Skills
Job Details
Role Description:
The SQL Developer will design, develop, and maintain complex SQL code based on business requirements and new business processes.
The SQL Developer responsibilities include:
- Performing day to day querying and analysis using SQL queries and procedures, and script execution to enhance understanding of data within a consolidated data store.
- Considering amorphous problem sets or functional requirements to determine path forward on creating the query to support end user business needs.
- Migration of queries, including conversion of syntax, from Postgres DB to a Redshift data store.
- Developing materialized views, stored procedures and scheduled queries.
- Analyzing existing queries for performance improvement and optimize runtime against Redshift database.
Technical Skills:
Skill | Years/Level of Experience |
SQL Database Design | P2 Intermediate (7 Years) |
SQL Data Analysis | P2 Intermediate (7 Years) |