Genius Road
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.
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.