ETL Informatica Analyst - State (Locals Only)

Overview

Hybrid
$1+
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

ETL
Informatica
IICS
Extract
Transform
Load
Functional Testing
Innovation
Management
Data Visualization
Data Quality
Data Integration
Data Analysis
Data Acquisition
Quality Assurance
Regression Analysis
Microsoft Visio
Modeling
Motivation
Snow Flake Schema
Software Development Methodology
Test Cases
Tableau
Scripting
SQL
Test Plans
Python
PL/SQL
Performance Management
Test Scripts
Conflict Resolution
ERwin
Evaluation

Job Details

Position: ETL Informatica IICS Analyst

Location: Austin TX, 3 days remote with 2 day (Mondays and Wednesdays) required to be onsite

Duration: 12+ Months
Job Description:

  • Implementation and configuration of the infrastructure for the data integration hub
  • Design, development, and implementation (DD&I) of the data integration hub using an agile methodology for all standard SDLC phases that includes, but is not limited to:

o Validation of performance metric requirements

o Creation of Epics/User Stories/Tasks

o Automation of data acquisition from a variety of data sources

o Development of complex SQL scripts

o Testing integration, load and stress

o Deployment / publication internally and externally

  • Operations support and enhancement of the data integration hub

    CANDIDATE SKILLS AND QUALIFICATIONS
  • Minimum Requirements:
    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.

    Years

    Required/Preferred

    Experience

    8

    Required

    Experience developing mappings and workflows to automate ETL processes using Informatica IICS, IDMC or Power Center.

    8

    Required

    Experiencing acquiring and integrating data from multiple data sources/technologies using Informatica for use by a Tableau data visualization object. Data source techs should include Snowflake, Oracle, SQL Server, Excel, Access and Adobe PDF.

    8

    Required

    Experience designing and developing complex SQL scripts that are fast and efficient

    8

    Required

    Strong analytical and problem-solving skills with experience as a Data analyst for a data analytics, performance management system, or data warehousing project.

    8

    Required

    Technical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.

    8

    Required

    Experience in designing and developing Python scripts for data testing and automation.

    8

    Required

    Identify, record, and track defects throughout the development lifecycle, working with developers to prioritize and resolve issues.

    8

    Required

    Collaborate with development teams to understand project specifications and contribute to the continuous improvement of quality processes.

    8

    Required

    Develop and execute test plans, test cases, and test scripts based on project requirements to ensure comprehensive testing coverage.

    8

    Required

    Identify and communicate business risks relative to testing and implementation for evaluation by project teams and management

    8

    Required

    Self-motivation, organized, time-management and deductive problem-solving skills

    8

    Required

    Work independently and as part of a team

    8

    Required

    Multi-task along with attention to detail

    8

    Required

    Maintain confidentiality and practice discretion and caution when handling sensitive information

    8

    Preferred

    Contribute to improving automation frameworks, including adding new features and enhancing test coverage

    4

    Preferred

    Experience building or working with automated regression and functional test suites, ideally enhanced by AI

    2

    Preferred

    Experience working on AI platforms or validating AI-integrated products

    2

    Preferred

    Familiarity with observability and testing infrastructure at scale

    2

    Preferred

    A track record of driving innovation in software quality or test automation


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.