ETL Engineer / Analyst
ETL Engineer / Analyst
Posted on :
11-07-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
ASSYST is seeking a skilled ETL Engineer/Analyst to support our client in Austin Texas.
Location: Austin Texas
Job Type: Contract (W2/C2C or 1099)
Position: Hybrid - Onsite
Key Responsibilities:
Required Qualifications
Preferred Skills
ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race color religion sex age disability military status national origin or any other characteristic protected under federal state or applicable local law
Location: Austin Texas
Job Type: Contract (W2/C2C or 1099)
Position: Hybrid - Onsite
Key Responsibilities:
- 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.
Required Qualifications
- ETL & Integration Expertise: 8 years of experience with Informatica (IICS IDMC or PowerCenter) and multi-source data integration from platforms like Snowflake Oracle SQL Server Excel Access and PDF.
- Advanced SQL & Data Analysis: Extensive experience in SQL development and performance management/data warehousing projects with strong skills in query optimization.
- Scripting & Automation: Proficiency in Python for data validation automation and test script development.
- Technical Documentation & Tools: Skilled in creating technical documentation and using modeling tools (Visio Erwin) and MS Office Suite.
- QA & Risk Management: Strong background in defect tracking test planning and risk identification throughout the development lifecycle.
- Soft Skills: Excellent communication organizational and problem-solving skills with the ability to work independently or in a team handle sensitive data and manage multiple tasks effectively.
Preferred Skills
- Test Automation Expertise: Proven experience enhancing automation frameworks building robust regression and functional test suites and improving test coverageideally with AI-driven enhancements.
- AI and Scalable Testing: Hands-on experience working with AI platforms or validating AI-integrated products along with familiarity in testing infrastructure and observability at scale.
- Innovation in Quality Engineering: Demonstrated ability to drive innovation in software quality test automation practices and continuous improvement of testing processes.
ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race color religion sex age disability military status national origin or any other characteristic protected under federal state or applicable local law
Required Experience:
IC
Employment Type
Full Time
Key Skills
Report This Job
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.
