ETL Analyst

ETL Analyst Location: Austin, Texas (hybrid – must be local!)

Contract Duration: 12 months

We’re looking for a ETL Analyst with proven experience in data integration, ETL automation, and SQL development. This role supports large-scale data engineering efforts and involves close collaboration with technical teams to translate business requirements into actionable data workflows and documentation. The ideal candidate will have hands-on expertise with Informatica (IICS or PowerCenter), advanced SQL scripting, and working within Agile delivery environments.

Qualifications:

Bachelor’s degree in Computer Science or a related field

8+ years developing ETL processes using Informatica IICS, IDMC, or PowerCenter

8+ years integrating data from multiple sources: Oracle, SQL Server, Snowflake, Excel, Access, PDFs

Strong SQL skills; experience designing and optimizing complex scripts

Proficient in Python scripting for data automation and testing

Experience with data analytics, warehousing, and performance reporting

Strong technical documentation skills using Visio, Erwin, MS Office, and MS Project

Familiarity with Agile practices and participation in sprint ceremonies

Strong problem-solving, time-management, and communication skills

Ability to work independently and handle sensitive information with discretion

Experience with AI-enhanced test automation

Familiarity with observability/testing infrastructur

Background in testing AI-integrated platforms

Key Responsibilities:

Analyze business requirements, translate into technical specs, and document data workflows

Design, build, and validate ETL processes using Informatica

Develop complex SQL scripts for data transformation and modeling

Automate data validation and reporting processes

Collaborate with engineers and architects to optimize data integration strategy

Participate in Agile sprint planning, reviews, and retrospectives

Create and maintain documentation, process diagrams, and test plans

Support defect tracking, testing coverage, and continuous improvement initiatives

Genius Road, LLC is proud to be a Certified Women’s Business Enterprise, an Equal Opportunity Employer and values diversity. All employment is decided on the basis of qualifications, merit and business need.