Database Architect

Database Architect

Vacancy expired!

OverviewAllied Consultants, Inc. is an Austin-based firm which has for 31 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced

Database Architect to be a key resource on a technical services team.
Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.

Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check

Allied Consultants is an equal opportunities employer.
ResponsibilitiesClient is developing a data warehouse solution and requires a Data Warehouse Architect – senior ETL developer with proven data warehouse experience to:

• 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.
• Document the “as-is” schemas currently in use at client.
• Perform other analysis and documentation tasks as required to facilitate and support client’s

Qualifications

Minimum Requirements:

Years

Skills/Experience
7 - 8
Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc., preferably Oracle.
7 - 8
Experience with Oracle PL/SQL.
6 - 8
Hands on experience with data modeling preferably in a data warehouse environment.
3
Experience with Informatica product suite in the Informatica cloud.
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
Technical writing skills.

Preferred:

Years

Skills/Experience
6
More than one type of RDBMS (DB2, SQL Server, Oracle).
4
Experience in Public Sector delivery.
4
Experience writing dynamic SQL.