| 10+ Years || Sr. Data Engineer || REMOTE || Immediate Interview at Remote, Remote, USA |
| Email: [email protected] |
| From: shruti, 1 Point System [email protected] Reply to: [email protected] Hi, This side Shruti Singh from 1point system, Hope you are doing Well, I have a job position for you. Job Description:- Job Role:- Sr. Data Engineer Location :- REMOTE Contract Our client, a major software Development Company is seeking a Sr. Data Engineer. The Preferred candidate must have the following: Oracle Cloud, SQL, and non-federated relational data warehouse architecture to help complete the Map Builder capability as part of a larger Social Determinants of Health capability. The candidate will also need to be familiar with Census and CDC data. Must Have:- 1. Data Engineer - 8-10 yrs of Relevant experience 2. Data Warehouse 8-10 yrs of Relevant experience 3. Oracle PL/SQL - 8-10 yrs of Relevant experience 4. OCI - 5-10 yrs of Relevant experience 5. Inmon and Kimball methodologies - 4-10 yrs of Relevant experience 6. API Gateway - 5-10 yrs of Relevant experience 7. AWS & Cloud - 5-10 yrs of Relevant experience 8. Data Mapping - 5-10 yrs of Relevant experience 9. CDC - 5-10 yrs of Relevant experience 10. VLDB - 5-10 yrs of Relevant experience 11. Erwin Data Modeler - 5-10 yrs of Relevant experience 12. Metadata - 5-10 yrs of Relevant experience Our client, a major software Development Company is seeking a Sr. Data Engineer. The Preferred candidate must have the following: Oracle Cloud, SQL, and non-federated relational data warehouse architecture to help complete the Map Builder capability as part of a larger Social Determinants of Health capability. The candidate will also need to be familiar with Census and CDC data. High Level Tasks: Redesign database using single partitioned FACT Table to improve system performance and data management efficiency. Refactor Geography DIM dataset structure to improve handling, performance, and utilization for mapping functionalities in the Map Builder tool. Update how total deaths are coded in the CDC Mortality Data while ensuring the accuracy and reliability. Deploy SDoH code to production instance supporting its first specific geography (implementation for a county in New Mexico). Comprehensive review & validation of SDoH data readiness for product launch Prepare the SDoH data for the initial launch of Map Builder 1.0, ensuring data accuracy and integrity. Set up and configure ETL orchestration processes to support a data subscription model, enabling dynamic data access and updates. Create a schema that facilitates a data subscription model for accessing the SDoH datamart, allowing for flexibility and scalability. Required Skills The skill set required for this role is below. 8-10 Years experience in data warehousing in both Inmon and Kimball methodologies 8-10 Years experience (expert level) in Oracle PL/SQL Hands-on experience using Erwin Data Modeler for complex 3NF/Dimensional/Hybrid models. Experience with metadata-driven solutions. Hands-on experience working with VLDB and partitioning strategies. Hands-on experience leveraging external API-s for augmenting DW content. 5+ Years experience working with cloud databases, preferably OCI and AWS. Experience with a variety of database architectures including row stores, column stores, fully in-memory systems, etc. Understanding of data architecture and performance optimization techniques including multi-node data distribution, partitioning/sharding, indexing, in-memory data structures, parallelization techniques, explain plans and/or tracing techniques, etc. Detailed understanding of common data warehouse security requirements including dedicated/system users and roles, row-level security, masking and/or anonymization, SSO capabilities, etc. Thanks & Regards Shruti Singh| 1Point System LLC IT Recruiter Email: [email protected] Keywords: information technology procedural language |
| [email protected] View all |
| Thu Mar 21 19:37:00 UTC 2024 |