ETL Analyst

Position: ETL Analyst #2823
ETL AnalystLocation: 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 Power Center), 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 Power Center
• 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. #J-18808-Ljbffr