Informatica ETL Developer

Overview

Allied Consultants, Inc is a proudly Austin based firm with over 33 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience Informatica ETL Developer to play a key role within a high-impact technical services team.

 

At Allied Consultants, we value our consultants and are committed to providing an exceptional experience including:

• Highly competitive pay rates
• Local support staff for responsive, personal service
• Comprehensive benefits package, including:
  • Medical insurance (with employer cost sharing)
  • Life insurance
  • A 401(K) plan with company match
  • Flexible spending through a cafeteria plan

Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening, in compliance with federal and state regulations. All offers of employment are contingent upon successful completion of these checks.

 

Allied Consultants is a proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Responsibilities

**Location of job: HYBRID - Position will be 2 days (Tuesdays and Fridays) remote with 3 days (Mondays, Wednesdays-Thursdays) required to be onsite at the location listed above. Program will only allow candidates who are LOCAL TO THE AUSTIN AREA ONLY.**

 

8 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.

 

Job Description

Understands business objectives and problems, identifies alternative solutions, performs studies and cost/benefit analysis of alternatives. Analyzes user requirements, procedures, and problems to automate processing or to improve existing computer system: Confers with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be; summarized, and formats for reports. Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system.

 

Additional job details and special considerations

We are seeking a highly experienced and motivated individual who specializes in Informatica Cloud Services (IICS). The ideal candidate will have deep technical expertise in multi-domain environments, enabling them to lead and deliver complex IICS implementations for our clients. This role requires a strong understanding of the Informatica toolset, including IICS and relevant business processes, along with excellent communication and client management skills.

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

8

Required

Extensive experience in designing, implementing, and managing Informatica IICS/snowflake solutions.

8

Required

E2E implementation experience involving phases from design, realization, testing, to go-live

8

Required

Deep understanding of Informatica data modeling, workflow, and integration capabilities and technologies, APIs, web services, and Informatica ETL tools.

8

Required

Strong knowledge of data governance, data quality, and data integration principles.

8

Required

Expertise in Azure Cloud and Snowflake Cloud Datawarehouse

8

Required

Strong knowledge in SQL Queries and Query optimization

8

Required

Ability to interact at a technical and non-technical level with Infrastructure, Network, Development, BA and QA

8

Required

Development experience in high transaction/high availability systems.

8

Required

Experience with analyzing and recommending solutions for Production issues short-term and long term.

8

Required

Must have informatica PowerCenter/IICS development experience.

8

Required

Knowledge and experience of managing reference data systems

8

Required

Provide technical mentorship to junior ETL developers; establish coding standards, templates, and best practices.

8

Required

Experience in Python with data science libraries

8

Required

Experience in SQL programming and writing stored procedures, functions, views, SQL queries

8

Required

Experience working with HIPAA regulations and handling protected health information (PHI) and personally identifiable information (PII).

8

Required

Strong organizational and time management skills.

8

Preferred

Data warehouse development experience

8

Preferred

Experience with Snowflake

4

Preferred

Experience in designing, optimizing, documenting, and implementing the operational aspects that support the Snowflake cloud data platform, including cost monitoring, optimizations, and user security auditing.

4

Preferred

Experience in implementing and supporting automation for managing Snowflake accounts, databases, and access roles.

4

Preferred

Experience and understanding in proposing and implementing database and Snowflake query performance optimizations.

4

Preferred

Experience with Git hub integration with snowflake and load data.