Hybrid Systems Analyst & Data Engineer (ETL/Snowflake)

Sistema Technologies Inc.; Austin (TX); Hybrid; USD 95,000 - 135,000; Full time

Job summary

Sistema Technologies is seeking a Systems Analyst for a 1-year engagement with our government client in Austin, TX. The role combines data engineering and systems analysis to understand business needs and deliver integrated ETL solutions.

You will work in a hybrid model requiring 2 days remote and 3 days onsite at the client site in Austin. Local candidates or those willing to relocate are encouraged to apply.

Qualifications

• 8+ years designing, developing, and supporting data integration solutions in an enterprise environment.
• Hands-on ETL development with Informatica PowerCenter including mappings, sessions, workflows.
• Ingesting data from multiple sources into Oracle databases.
• Strong Oracle SQL/PLSQL knowledge and performance tuning for ETL queries.
• Experience with Snowflake data loading, schema design, and query performance.
• Experience with Informatica PowerCenter / Informatica Cloud Data Integration for cloud-based ETL/ELT development.
• Gathering data requirements and documenting data flow/design specifications.
• Troubleshooting data quality issues and production ETL bottlenecks.
• Experience with job scheduling tools like Control-M or Autosys.
• Experience with SAP Business Objects Universe design/maintenance (Preferred).
• Experience in state government or large enterprise IT with formal SDLC/change management (Preferred).

Responsibilities

• Understand business objectives, analyze requirements, and evaluate alternatives with cost/benefit analysis.
• Analyze user requirements and procedures to automate or improve systems.
• Write detailed descriptions of user needs and program functions to guide development.
• Review system capabilities and scheduling to determine feasibility of changes.

Skills

Informatica PowerCenter

Oracle SQL/PLSQL

Snowflake

ETL workflows

Data ingestion

Job scheduling

Data quality

SDLC

Education

Bachelor's degree in CS/IT

Tools

Control-M

Autosys

Informatica Cloud Data Integration

Oracle SQL

Job description

Sistema Technologies is seeking a Systems Analyst for a 1-year engagement with our government client in Austin, TX. The role combines data engineering and systems analysis to understand business needs and deliver integrated ETL solutions.

You will work in a hybrid model requiring 2 days remote and 3 days onsite at the client site in Austin. Local candidates or those willing to relocate are encouraged to apply.