Data Warehouse Architect
Software Technology Inc.
Michigamme, MI
See who Software Technology Inc. has hired for this role
Hi,
This is Tejaswini from Software Technologies Inc. We have a job opening with our client for position of Data Warehouse Architect 3 you are available and looking for any new opportunities, please send me your updated resume for below position ASAP
The State of Michigan is looking for.
Job Title : Data Warehouse Architect 3
Location: Dimondale, MI
Interview Process: Interviews will be held in person - candidates must be able to attend an in-person interview.
Hybrid: Local candidates strongly preferred, or non-local candidates who are willing to relocate at their own expense from acceptance with no delays. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week (Tuesdays and Wednesdays are required to be onsite for this position). Resource will be working a hybrid schedule.
Top Skills & Years Of Experience
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 desigining 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,
N.TEJASWINI NAIDU
Technical recruiter
Direct:404-777-9838 | Fax: 866-608-6686
Email: tejaswini.n@stiorg.com | Web: www.stiorg.com
100 Overlook Center, Suite 200
Princeton, NJ 08540.
This is Tejaswini from Software Technologies Inc. We have a job opening with our client for position of Data Warehouse Architect 3 you are available and looking for any new opportunities, please send me your updated resume for below position ASAP
The State of Michigan is looking for.
Job Title : Data Warehouse Architect 3
Location: Dimondale, MI
Interview Process: Interviews will be held in person - candidates must be able to attend an in-person interview.
Hybrid: Local candidates strongly preferred, or non-local candidates who are willing to relocate at their own expense from acceptance with no delays. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week (Tuesdays and Wednesdays are required to be onsite for this position). Resource will be working a hybrid schedule.
Top Skills & Years Of Experience
- Years of experience: 12 or more years of experience in the field is required
- Experience building a data warehouse
- Experience creating ETL designs
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 desigining 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,
N.TEJASWINI NAIDU
Technical recruiter
Direct:404-777-9838 | Fax: 866-608-6686
Email: tejaswini.n@stiorg.com | Web: www.stiorg.com
100 Overlook Center, Suite 200
Princeton, NJ 08540.
-
Seniority level
Mid-Senior level -
Employment type
Full-time -
Job function
Information Technology -
Industries
Information Technology & Services
Referrals increase your chances of interviewing at Software Technology Inc. by 2x
See who you knowGet notified about new Data Warehouse Architect jobs in Michigamme, MI.
Sign in to create job alertSimilar jobs
-
Senior System Architect, New Products
Senior System Architect, New Products
Roku
-
Technology Architect
Technology Architect
Stellar Professionals
-
Senior System Architect, New Products
Senior System Architect, New Products
Roku
-
VP, Chief Architect - Enterprise Applications and Infrastructure
VP, Chief Architect - Enterprise Applications and Infrastructure
Intuit
-
Chief Technology Architect
Chief Technology Architect
Celerity
-
Applications Architect
Applications Architect
Pierce
-
Senior Technology Architect
Senior Technology Architect
Infosys
-
Application Architect-II
Application Architect-II
Serigor Inc
-
Information Technology Solutions Architect
Information Technology Solutions Architect
MANN+HUMMEL
-
Solutions Architect
Solutions Architect
Smartcat
-
Solutions Architect, Early Stage Startups
Solutions Architect, Early Stage Startups
Amazon Web Services (AWS)
-
IT Infrastructure Architect
IT Infrastructure Architect
Accroid Inc
-
Solution Architect
Solution Architect
Sogeti
-
Cloud Architect
Cloud Architect
Delaney & Bourton
-
Cloud Architect
Cloud Architect
Steneral Consulting
-
Solutions Architect
Solutions Architect
Simpson Thacher & Bartlett LLP
-
Lead IT Architect - Operational Reporting
Lead IT Architect - Operational Reporting
McKesson
-
Sr Solution Architect
Sr Solution Architect
Accroid Inc
-
Digital Transformation Technology Architect
Digital Transformation Technology Architect
Dizer Corp
-
Application Architect-III (Hybrid)
Application Architect-III (Hybrid)
Serigor Inc
-
Cloud Architect
Cloud Architect
Dizer Corp
-
Solution Architect
Solution Architect
Inventive
-
Cloud Architect/Technical Lead
Cloud Architect/Technical Lead
Donato Technologies, Inc.
-
Urgent requirement of Solution Architect @ 100% Remote
Urgent requirement of Solution Architect @ 100% Remote
Webologix Global
-
Data Center Architect - Remote
Data Center Architect - Remote
EVOTEK
-
Solution Architect
Solution Architect
Donato Technologies, Inc.
-
Senior Application Architect - Payment Systems
Senior Application Architect - Payment Systems
Donato Technologies, Inc.
People also viewed
-
Cloud Architect
Cloud Architect
-
Senior Solutions Architect
Senior Solutions Architect
-
REMOTE WORK - Need AWS Architect
REMOTE WORK - Need AWS Architect
-
Solutions Architect, Early Stage Startups
Solutions Architect, Early Stage Startups
-
IT Architect
IT Architect
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub