ETL Engineer - Austin, United States - Allied Consultants (Texas)

    Allied Consultants (Texas)
    Allied Consultants (Texas) Austin, United States

    3 weeks ago

    Default job background
    Description

    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