Job Description

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.

Job Tags

Contract work, Local area,

Similar Jobs