Vacancy expired!
We work with Direct Clients, no layers.One of them needs
Sr React Developer for Long Term Contract. Role: Data EngineerDirect Client, No LayersLong Term ContractDallas, TX (Onsite) Project Description/Job Summary:- Savvy and know about Oracle and Postgres. Team is heavy in Oracle for the applications.
- Snowflake – good to have.
- Needs to be savvy and know about Oracle and Snowflake (Oracle is heavier)
- Primary focus will be in Oracle and Unix
- Location: onsite.
- This is more of a Data Engineering role.
- Building things using any programming languages. any exp. With Golang gives them an edge.
- Oracle DB – must hv.
- Data integration; Data modelling; Data cleaning
- Build tables; ER Modelling
- How business works on the reporting side.
- Analyzing Data
- Expert knowledge in Database like Oracle, PostgreSQL (preferably cloud hosted), any cloud based Data Warehouse (like Snowflake, Azure Synapse) with strong programming experience in SQL.
- Programming language experience in Golang, Python, shell scripts is desirable.
- Deep knowledge of databases, stored procedures, optimization of large data sets.
- In-depth knowledge of ingestion techniques, data cleaning, de-dupe, partitioning.
- Experience in building the infrastructure required for data ingestion and analytics
- Solid understanding of normalization and denormalization of data, database exception handling, transactions, profiling queries, performance counters, debugging, database & query optimization techniques
- Understanding of index design and performance-tuning techniques
- Familiarity with SQL security techniques such as data encryption at the column level, signed stored procedures, and assignment of user permissions
- Experience in understanding the source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting
- Adhere to standards for all database e.g., Data Models, Data Architecture and Naming Conventions
- Experience with GoLang will have an edge
- Must Have OracleDB
- Hands on experience with data integration, data modeling, and data cleaning
- Build Tables; ER Modeling
- Understand how business works on the reporting side
- Snowflake is a nice to have, because they are moving to Snowflake for some of their data performance needs
- Scripting, understanding Data Structures
- Analyzing Data
- Exposure to Source control like GIT, Azure DevOps
- Understanding of Agile Methodologies (Scrum)
- Understanding of Data modeling techniques and working knowledge with OLTP and OLAP systems
- Experience with CI/CD automation tools.
- ID: #44612599
- State: Texas Dallas / fort worth 75201 Dallas / fort worth USA
- City: Dallas / fort worth
- Salary: Depends on Experience
- Job type: Contract
- Showed: 2022-08-05
- Deadline: 2022-10-03
- Category: Et cetera