ASSYST is seeking a skilled ETL Engineer/Analyst to support our client in Austin, Texas.

• Implement and configure infrastructure for the data integration hub in alignment with TIERS objectives.
• Design, develop, and implement ETL processes using Agile SDLC practices, including:
• Performance metric validation
• User Story and Task creation
• Data acquisition automation
• SQL script development
• Integration, load, and stress testing
• Internal/external deployment and publication
• Provide operations support and continuous enhancement of the data integration hub.
• Acquire data from diverse sources (Oracle, SQL Server, Snowflake, Excel, Access, PDF) and load into dimensional models.
• Design and implement Informatica workflows and mappings to automate transformation logic.
• Write and optimize complex SQL queries, views, and materialized views in Oracle.
• Develop automated testing and validation processes using Python and Informatica tools.
• Collaborate closely with architects and data engineers on data design and acquisition strategies.
• Enhance and support a Java-based web portal that delivers Tableau dashboards to users with varied access roles.
• Create mockups and participate in customer validation sessions for dashboard interfaces and features.
• Participate in all Agile ceremonies (planning, stand-ups, retrospectives, etc.).
• Develop and maintain technical documentation including specifications, diagrams, and data models.
• Interpret changing business requirements and recommend appropriate system enhancements.
• Support testing and quality assurance including defect tracking and resolution