| Direct Client Looking for Data Warehouse Architect Hybrid Dimondale, MI at Remote, Remote, USA |
| Email: [email protected] |
|
Processing description: http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=832837&uid= Hello Partners, Greetings from Dev Care Solutions . Hope everything is well with you. I have the following requirements with one of my direct clients in Michigan . Please review the job description and let me know if you are interested . Don't share resumes if the candidate doesn't have a Local ID to Michigan because we submit only local profiles from Michigan. Job title: Data Warehouse Architect Job id: 124057 name: State of Michigan MSP Location: Dimondale, MI Duration: 1+ Years Interview mode: In-person ***Hybrid Work, two days a week (Tuesdays and Wednesdays are required to be onsite for this position) Job Description: Translate business requirements and models into feasible and acceptable data warehouse designs. Provide support to all data warehouse initiatives. Define all metadata standards for the data warehouse. Develop data warehousing hardware and software platforms and integrate systems to ensure that integration is effective and meets client specifications. Prepare a design for all metadata relating to various Extract/Transform/Load (ETL) processes. Create ETL designs to provide easy accession to data marts. Conduct troubleshooting on all ETL processes and effectively resolve any issues. Analyze every data warehouse architecture goal and identify what skill requirements they require. Evaluate all proposals and requests and help implement the chosen items that will improve the data warehouse structure. Assist in the definition, documentation, and development of mapping rules for movement of data from desperate data sources and into the various components and subject areas. Create data models including robust data definitions, entity-relationship-attribute models, as well as relational and/or dimensional models. A good understanding of the design and development of complex business reports. Design and oversee the implementation of data transformation and change processing procedures to ensure that data from multiple sources is aggregated, normalize, and update and then publish to multiple target environments. Provide hands-on data modeling (relational and dimensional) for Data Warehouse/Data Marts Test and monitor alterations in designs. Create database models which serve as blueprints for project engagements of all complexities. Must be familiar with DevOps best practices and automation of processes like building, configuration, deployment, documentation, testing, and monitoring. Requirements: Experience in Data Modeling and designing Datawarehouse databases, Required 10+ years. Experience in developing ETL models. Required 5+ years Experience in Data Replication using tools like Oracle Golden Gate, 5+ years. Experience in Oracle Database administration, PL/SQL, packages, security, and stored procedures, Required 12+ years. Knowledge in design, development, implementation, and documentation of data systems Working knowledge of relational database design, logical data modeling, data warehousing, and relational database management systems preferably Oracle 19c, Experience in performance tuning, Required 10+ years. Vast experience in LINUX systems, Required 10+ years. Extensive working experience in RAC environments, Required 10+ years. Experience using Oracle Data Guard / Fast Start Failover, Required 5+ years. Database programming experience in data migration and conversion practices, Required 8+ years Writing Oracle packages, procedures, and functions, Required 10+ years Designing, creating, normalizing and maintenance of oracle database objects, Required 10+ years. Designing logical and physical database model, Required 10+ years Data analysis and management, Required 10+ years Skills Years Used Last Used Experience in Data Modeling and designing Datawarehouse databases, Required 10+ years. Experience in developing ETL models. Required 5+ years Experience in Data Replication using tools like Oracle Golden Gate, 5+ years. Experience in Oracle Database administration, PL/SQL, packages, security, and stored procedures, Required 12+ years. Knowledge in design, development, implementation, and documentation of data systems Working knowledge of relational database design, logical data modeling, data warehousing, and relational database management systems preferably Oracle 19c, Experience in performance tuning, Required 10+ years. Vast experience in LINUX systems, Required 10+ years. Extensive working experience in RAC environments, Required 10+ years. Experience using Oracle Data Guard / Fast Start Failover, Required 5+ years. Database programming experience in data migration and conversion practices, Required 8+ years Writing Oracle packages, procedures, and functions, Required 10+ years Designing, creating, normalizing and maintenance of oracle database objects, Required 10+ years. Designing logical and physical database model, Required 10+ years Data analysis and management, Required 10+ years Thanks & Regards, Nidhen Ravichandran Technical Recruiter +1(616)-682-6405 (Direct) 614-867-9367 (Fax) 614-221-2277 (Corp) [email protected] 579 Executive Campus Dr, Suite 370, Westerville, OH-43082|| www.dev care .com For escalations please contact: Level of Escalation Nagarajan ( [email protected] ,517-921-5281) Team Lead Kothandan ( [email protected] ,614 559-9953) Manager If you do not wish to receive an email or phone call, please send an email to the following email addresses. Do Not Disturb (Email): [email protected] Do Not Disturb (Phone): [email protected] Award Winner "Inc 5000: Fastest Growing Companies in America" "Columbus Business First: Fastest Growing Private 50 Companies in Columbus" "Certified Minority Business Enterprise - MBE" Keywords: procedural language Idaho Michigan Ohio http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=832837&uid= |
| [email protected] View All |
| 07:54 PM 07-Nov-23 |