Overview
Hybrid
$100 - $120
Contract - W2
Skills
Python
Java
JSON
ERwin
PL/SQL
Data modeling
Apache Kafka
Amazon Redshift
Advanced analytics
Star schema
Oracle Exadata
Job Details
- This is a developer that will help design and implement a consolidated order data store and normalize a way of sourcing from multiple sources
- Technologies: star schema data model, Java, JavaScript, Python Kafka, and JSON using messaging
- Understand dimensional data modeling will be in oracle, experience with AWS Redshift and Kafka
- Developer source data from multiple systems fix message/file/api build adaptors that bring data in source from internal systems as well use Kafka for trading backbone and that data then flows into data store
- Heavy on middle and backend work on real-time message system primarily Java, Kafka and messaging
- Must have expertise in Java, JavaScript, Python, JSON, and Kafka
- Strong Relational database design and modeling skills including trade-offs
- Understanding of Dimensional Modeling
- Oracle Exadata and Golden Gate, MySQL and PostgreSQL
- Strong Pl/SQL development and debugging skills
- Performance tuning and understanding how to analyze query plans, knowledge of AWR, SQL trace and ability to optimize SQL queries, create indexes, and use other performance-enhancing features.
- Experience with data modeling tools such as ERwin, IBM Data Architect, etc.
- Experience with cloud-based databases such as AWS Aurora, Redshift and Snowflake.
- Advanced analytics, reporting, and machine learning capabilities with Oracle databases
- The ability to creatively resolve database-related problems
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.