ETL Engineer

Overview

Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced ETL Engineer 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.

Responsibilities

The ETL engineer will support a cloud-based analytics platform based on AWS using Informatica Power center and Snowflake. In addition to the skills listed, experience with other Informatica tools such as MDM, Axon, and EDC will be preferred. Knowledge of Python will be preferred.

Qualifications

Minimum Requirements:

Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

10

Required

ETL experience in Informatica tools or similar technology

8

Required

Experience Working on Data Warehousing projects

8

Required

Experience working on Enterprise Scale database solutions, such as Oracle, SQL Server, Snowflake, and similar

8

Required

Experience in Agile or Scrum

5

Preferred

Experience with Informatica PowerCenter preferred

5

Preferred

Experience with Business Intelligence or Reporting tools such as Tableau, PowerBI, Crystal Reports, SSRS, or similar.

4

Preferred

Experience creating data models, including star and snowflake schema strongly preferred. This should include both Physical and Logical Data models.

4

Preferred

Experience with cloud platforms such as AWS, Azure or similar strongly preferred

3

Preferred

Experience with Python

2

Preferred

Experience with Snowflake Cloud Database