Vacancy expired!
- Design relational data models
- Write ETL code querying relational databases, tabular excel data, and CSV data
- Write ETL routines to confirm full data content is transferred successfully
- Write procedures to perform automated operations on data and provide business rule views of data
- Perform data discovery to profile data for ETL requirements and find anomalous data
- Optimize queries for large volumes of data
- Write ETL code to migrate data to specific shards in a database farm
- Write performant complex SQL statements against terabyte+ size datasets
- Develop relational data models to accommodate in-process data for automated ETL processes
- Optimize ETL and SQL statements
- Analyze and troubleshooting database performance issues
- Develop ETL routines that manipulating and transfer large volumes of data and perform quality checks to confirm all data is transferred
- Using version control systems, GIT preferred
- Works well in a distributed team environment
- Querying REST API's and consuming JSON data
- Oracle
- AWS S3 and Glacier
Vacancy expired!