Job Description
Job Description
Hybrid Onsite - 2 Days/Week on site in Austin, TX. Candidates must be based in Austin, TX
Core Duties & Responsibilities:
• Analyze business objectives, perform cost/benefit analysis, and identify alternative solutions.
• Collaborate with organizational units to document user requirements, data input/output formats, and reporting needs.
• Design, develop, and support enterprise data integration solutions and scalable data engineering pipelines.
• Perform production support, troubleshoot job failures, and optimize ETL performance.
Minimum Required Skills (with years):
• Data Engineering/Systems Analysis: 8+ years
• Informatica PowerCenter: 8+ years
• Oracle SQL/PL-SQL: 8+ years
• Snowflake: 8+ years
• Data Mapping & Requirements Gathering: 8+ years
• Batch Job Orchestration: 8+ years
Preferred Skills
• SAP Business Objects Universe design
• Experience in state government IT environments
II. WORKER SKILLS AND QUALIFICATIONS
Please fill in the "Actual Years Experience" column. Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
Actual Years Experience
Years Experience Needed
Required / Preferred
Skills / Experience
8
Required
Experience as a Data Engineer/Systems Analyst in enterprise environments
8
Required
Informatica PowerCenter development (workflows, mappings, sessions)
8
Required
Data ingestion from heterogeneous source systems to Oracle databases
8
Required
Oracle SQL/PL-SQL (stored procedures, performance tuning)
8
Required
Snowflake data loading, schema design, and performance optimization
8
Required
Informatica PowerCenter / Cloud Data Integration for ETL/ELT
8
Required
Data requirements gathering and source-to-target mapping documentation
8
Required
Troubleshooting ETL pipeline failures and data quality issues
8
Required
Job scheduling/orchestration tools (Control-M, Autosys, Informatica)
3
Preferred
SAP Business Objects Universe design
3
Preferred
State government or large enterprise IT environment experience