Location: Austin Texas (hybrid must be local!) Contract Duration: 12 months
Were 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:
Bachelors 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 Womens Business Enterprise an Equal Opportunity Employer and values diversity. All employment is decided on the basis of qualifications merit and business need.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.