Database Architect

Numentica; United States; Remote; USD 90,000 - 140,000; Full time

Job summary

Join a dynamic team at an innovative company specializing in enterprise software solutions. As a Database Architect, you will play a crucial role in overseeing data governance projects, ensuring the integrity and quality of data throughout the organization. Your expertise in ETL processes and data modeling will be essential as you document and optimize data flows, and create best practices for database management. This role offers the opportunity to work with cutting-edge technologies and contribute to the success of major projects that impact Fortune 500 companies. If you are passionate about data and looking to make a significant impact, this is the perfect opportunity for you.

Qualifications

• Minimum 8 years of experience with Informatica ETL processes and data management.
• Hands-on experience with data warehouse development and testing.
• Experience with data modeling tools like erwin.

Responsibilities

• Oversee multiple projects in the Data Governance team.
• Test and document ETL processes for the data warehouse.
• Perform complex data modeling tasks in a data warehouse environment.

Skills

Informatica ETL processes

Data management

Data modeling

Data quality standards

Data flows

Data relationships

Technical requirements analysis

Tools

Oracle

SQL Server

DB2

erwin

Amazon Web Services

Job description

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 of experience in Amazon Web Services.

About the company

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.