Offer summary

Qualifications:

Minimum 8 years of experience in ETL processes and data management., Hands-on experience with data warehouse development using Oracle or SQL Server., Proficiency in data modeling, particularly in a data warehouse environment., Experience with Informatica product suite and creating source to target mapping documentation..

Key responsabilities:

Oversee multiple projects as part of the Data Governance team.

Test and document ETL processes for the data warehouse.

Create database standards and best practices deliverables.

Define and document the technical architecture and perform other analysis tasks as needed.

Numentica LLC, founded in 2008, is a team of software experts who have built enterprise software at fortune 500 companies and helped them achieve success. We have worked across industries such as ECommerce, Finance, Marketing and Supply Chain Automation - each of these industries have unique needs, but they share one particular challenge: They need to manage large amounts of structured and unstructured data. Numentica's team specializes in helping companies wrangle big data and making sense of it. We are a niche consulting firm specializing in software product development, business intelligence, and data management. We believe that our success is built on the success of our clients, and we do what it takes to give our clients a sustained competitive edge through value and innovation. By formalizing our experience into innovative tools and frameworks, we help our customers accelerate time-to-market, improve the quality of products and reduce costs. Our unique culture promotes excellence and drives innovation through trust, pride and teamwork. Some key differentiators that help us build enduring relationships with our clients include Mindshare: Our engagement model, partnership mindset and organization structure ensure that our customers get all the mindshare that they need, and more. Team stability: Our staff retention and longevity provides immense confidence to our customers that the investment they make in their teams with us shows excellent ROI. Service orientation: We never forget that we are in the software services business, an attitude that carries tremendous weight in our recruitment process. Our customers get teams that always go the extra mile to advance their businesses. Partnership mindset: As a company, we take a very long-term view to each and every relationship. We invest time and effort that we know is required for the relationship to mature.

Job description

This is a remote position.

Perform Database Architect work as a member of the Data Governance team, overseeing one or more projects

concurrently. Test Extraction Transformation Load (ETL) processes for the data warehouse. Document ETL

processes to extract data from existing systems into the data warehouse. Document the “as-is” schemas currently

in use at TWC. Perform complex data modeling tasks in a data warehouse environment. Create mapping documents

from source to target databases. Create database standards and best practices deliverables. Perform other analysis

and documentation tasks as required to facilitate and support TWC’s Enterprise Data Warehouse. Define and

document the technical architecture. Perform other analysis and documentation tasks as required. Perform other

duties as assigned to maintain operations.

Requirements

Minimum 8 years of experience required for the following Skills :

Deep hands-on expertise with Informatica ETL processes, development, data
management, data profiling, data flows, data relationships, and data quality
standards and processes

Hands-on experience with data warehouse development and testing
(relational and dimensional) and proven evidence to implement using
databases like Oracle, SQL Server etc. but preferably Oracle

Analyzing and generating technical requirements and design

Hands on experience with data modeling preferably in a data warehouse
environment

Experience with Informatica product suite in the Informatica cloud

Creating source to target mapping database documentation

Assist with migrating data from legacy database to new target database

Preferred :

5 years in more than one type of RDBMS (DB2, SQL Server, Oracle)

5 years in erwin or other equivalent data modeling tools

3 years in Experience in Amazon Web Services

Texas Workforce Commission experience

Required profile