NFOLKS

Data Warehouse Architect

Austin, TX
USD 80k - 85k
ETL Data Vault 2.0 Oracle Informatica DB2 SQL Server
Description

DW Architect - Location - Austin - Rate - $80-$85 - public sector experience is a must

Location: Austin, TX, us

Company Description

nFolks

Job Description

TWC is developing a data warehouse solution and requires a Data Warehouse Architect with proven data warehouse experience to:

 

•                  Establish Extraction, Transformation and Load (ETL) strategies, architecture, and design for the project.

•                  Establish standards for all ETL processes for the data warehouse.

•                  Design, develop, and test ETL processes for the data warehouse.

•                  Develop and document ETL processes to extract data from existing systems into the data warehouse. 

•                  Assist in establishing the organization's data warehousing strategy.

•                  Assist in data tool implementation.

•                  Define and document the technical architecture of the data warehouse, including the physical components and their functionality.

•                  Document the “as-is” schemas currently in use at TWC.

•                  Perform other analysis and documentation tasks as required to facilitate and support TWC’s Enterprise Data Warehouse Project.

 

Qualifications

Minimum Requirements:

Years

Skills/Experience

12

Design and develop Extraction, Transformation, Load (ETL) architecture for enterprise data warehouse; Deep hands-on expertise with ETL processes, development, data management, data flows, data relationships, and data quality standards and processes.

10

Extensive architecture experience and knowledge in the areas of Reference Data, Data Quality, Metadata Management with hands-on solution implementation.

6

Hands-on experience with data warehouse modeling, design and development (relational and dimensional) including recent experience with Data Vault 2.0 architecture and proven evidence of implementation using Oracle. 

6

Recent hands-on experience with Informatica product suite, including those relevant to data quality, master data, and management of enterprise metadata.

3

Experience performing data quality and data tool implementation.

Strong

Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.

Strong

Communication, analytical and interpersonal skills at all levels.

Strong

Strong technical writing skills.

                            

              Preferences:

Years

Skills/Experience

4

Enterprise Architect from Sparx Systems or other equivalent data modeling tools

4

More than one type of RDBMS (DB2, SQLServer, Oracle)

4

Experience in Public Sector delivery

 

Certified Data Management Professional (CDMP)

 

Experience with Informatica in the cloud

 

 

Additional Information

All your information will be kept confidential according to EEO guidelines.

NFOLKS
NFOLKS

0 applies

0 views

There are more than 50,000 engineering jobs:

Subscribe to membership and unlock all jobs

Engineering Jobs

60,000+ jobs from 4,500+ well-funded companies

Updated Daily

New jobs are added every day as companies post them

Refined Search

Use filters like skill, location, etc to narrow results

Become a member

🥳🥳🥳 452 happy customers and counting...

Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.

To try it out

For active job seekers

For those who are passive looking

Cancel anytime

Frequently Asked Questions

  • We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
  • We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
  • We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
  • We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
  • Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
  • Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
  • Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅

What Fellow Engineers Say