Informatica System Analyst

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

Agile
Analytical Skill
Analytics
Automated Testing
Business Intelligence
Cascading Style Sheets
Collaboration
Communication
Computer Science
Conflict Resolution
Dashboard
Data Acquisition
Data Analysis
Data Integration
Data Security
Data Warehouse
Database
DevOps
ERwin
Extract
Transform
Load
HTML
Health Care
Informatica
JIRA
Java
JavaScript
Management
Microsoft Excel
Microsoft PowerPoint
Microsoft Visio
Mockups
Multitasking
Oracle
PDF
PL/SQL
Problem Solving
Python
Quality Assurance
Reporting
Requirements Analysis
SOAP
SQL
Scripting
Snow Flake Schema
Sprint
Systems Analysis
Tableau
Technical Writing
UI
UPS
Visualization
Web Applications
Web Services
Workflow
Writing
jQuery

Job Details

Informatica System Analyst

Location: Austin, TX Hybrid (Onsite Mondays and Wednesdays)

Local Candidates Only (No relocation; onsite presence required)

Responsibilities:

  • Acquire data from multiple sources for use in analytics and reporting.
  • Develop complex SQL scripts to transform data and create views/materialized views in Oracle.
  • Automate data pipelines using Informatica IICS, IDMC, or Power Center.
  • Design and implement dimensional data models for analytical use.
  • Perform validation and verification of SQL scripts, Informatica workflows, and database views.
  • Develop automated testing methods for validation and QA.
  • Participate in all Agile sprint ceremonies (planning, reviews, retrospectives, stand-ups).
  • Collaborate with architects and team members on data acquisition strategies.
  • Enhance and maintain Java-based web applications that serve Tableau dashboards to various user roles.
  • Develop UI mockups and work closely with stakeholders for validation.
  • Assist in technical problem solving and DevOps tool configuration.
  • Produce and maintain technical documentation (specifications, diagrams, etc.).
  • Participate in requirement analysis, design sessions, and propose technical enhancements.
  • Analyze and interpret changing business requirements and provide data solutions accordingly.
  • Perform other related duties as assigned.

Minimum Required Skills and Experience:

Years

Required Skills

8

Experience developing ETL mappings/workflows using Informatica IICS, IDMC, or Power Center

8

Data integration from Snowflake, Oracle, SQL Server, Excel, Access, PDF using Informatica

8

Strong experience writing complex and optimized SQL scripts

8

System analysis experience in data analytics, BI, or data warehousing projects

8

Technical documentation and diagramming skills using Visio, Erwin, Word, Excel, PowerPoint

8

Experience with enterprise-level software platform delivery

8

Hands-on experience with Python scripting

8

Worked in an Agile sprint team environment

8

Experience using JIRA for Agile project tracking

Preferred Skills and Experience:

Years

Preferred Skills

8

Excellent verbal and written communication skills

6

Experience writing clean, testable, and efficient code

4

Knowledge of healthcare data security principles

4

Experience with modern BI/visualization tools and metrics systems

4

Strong self-management, multitasking, and priority-setting abilities

4

Bachelor s degree in Computer Science, IT, Business, or related field

3

Previous experience in the Healthcare industry

2

Experience working with HHS agencies

2

Experience working with PII or PHI data

2

Experience in web technologies: HTML, CSS, JavaScript, JQuery, APIs

2

Experience building UI using standard HTML/CSS practices

2

Understanding of REST, SOAP web services

2

Experience developing reports/dashboards using Tableau connected to external data

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.