ETL Developer Job at Software People, Inc., Austin, TX

Qkl2Wkc5MFVmaVIvaWZ3Rk1Ma1NPSFlNdnc9PQ==
  • Software People, Inc.
  • Austin, TX

Job Description

Phone/Skype Hire. Onsite from day 1. Only Local candidates

Location: Austin, Texas

Duration: 12+ months

Must have current LinkedIn profile.

Responsibilities

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:

  • Validation of performance metric requirements
  • Creation of Epics/User Stories/Tasks
  • Automation of data acquisition from a variety of data sources
  • Development of complex SQL scripts
  • Testing integration, load and stress
  • Deployment / publication internally and externally

Operations support and enhancement of the data integration hub

This development effort will utilize an agile methodology based upon the approach currently in use at HHSC for the Texas Integrated Eligibility Redesign System (TIERS). As a member of the agile development team, the worker responsibilities may include:

Data acquisition from a variety of data sources for multiple uses.

Developing complex SQL scripts to transform the source data to fit into a dimensional model, then to create views and materialized views in Oracle.

Developing automation with Informatica IICS or Power Center to pull data from external data sources and transform it to fit into a dimensional model.

Collaborating with other members of the Data Engineering Team on the design and implementation of an optimal data design.

Verification and validation of SQL scripts, Informatica automation and database views.

Developing automated means of performing verification and validation.

Participating in all sprint ceremonies

Work closely with the Architects and Data Engineering Team on implementation designs and data acquisition strategies.

Enhance and maintain the Java web site that provides Tableau dashboards to an array of users with different roles.

Develop mockups and work with customers for validation

Working closely with other members of the team to address technical problems

Assisting with the implementation and configuration of developmental tools

Producing and maintaining technical specifications, diagrams, or other documentation as needed to support the DD&I efforts

Participation in requirements and design sessions

Interpreting new and changing business requirements to determine the impact and proposing enhancements and changes to meet these new requirements

Skills Needed

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 system 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 planning and delivering software platforms used across multiple products and organizational units.

8

Required

Experience designing and developing scripts using Python

8

Required

Experience on an agile sprint team

8

Required

Experience with JIRA software

8

Preferred

Excellent oral and written communication skills.

6

Preferred

Proven ability to write well designed, testable, efficient code by using best software development practices

4

Preferred

Understanding of security principles and how they apply to healthcare data

4

Preferred

Experience with state of the art software components for a performance metrics data visualization or business intelligence environment

4

Preferred

Effectively self-manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.

4

Preferred

Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience.

3

Preferred

Prior experience in the Healthcare Industry

2

Preferred

Prior experience with an HHS agency

2

Preferred

Prior experience working with PII or PHI data

2

Preferred

Expertise and hands on experience with Web Applications and programming languages such as HTML, CSS, JavaScript, JQuery and API's

2

Preferred

Prior experience creating website/user interfaces by using standards HTML/CSS practices

2

Preferred

Functional knowledge or hands on design experience with Web Services (REST, SOAP, etc.)

2

Preferred

Experience developing dashboards and reports using Tableau, including connecting to external data sources.

Job Tags

Hourly pay, Local area,

Similar Jobs

Advantage Sales and Marketing

Part Time Shift Supervisor in Costco Job at Advantage Sales and Marketing

Minimum: Maximum: We want you to help us shape the future of shopping experiences and deliver on our purpose of connecting people with the products and experiences that enrich their lives. Joining Advantage Solutions means joining a network of 65,000 teammates serving...

Liberty Healthcare Corporation

Caregiver (entry-level / training provided) Job at Liberty Healthcare Corporation

 ...Liberty of Oklahoma Corporation is now hiring for multiple entry-level Habilitation Specialist positions at the Laura Dester Children...  ...~10:30 pm to 7:00 am As a full-time employee of Liberty Healthcare in this role, you can expect: ~ Starting pay of $18.54 per... 

Loves Travel Stops & Country Store

Class A Fuel Tanker Driver Job at Loves Travel Stops & Country Store

 ...******* BASIC PURPOSE: Gemini Motor Transport operates trucks across the United States,...  ...Stops, wholesale and retail customers. Our Fuel Transport positions are among the best in...  ...in our business, for our professional drivers and loyal customers. COMPENSATION AND... 

ARDENT SERVICE

PERSONAL ASSISTANT Job at ARDENT SERVICE

This position can be work from home anywhere in the United States!!! APPLY & GET STARTED -$600 WEEKLY ! My Name is John Cook 73 years . My wife and i are currently seeking...  ...experience needed! We train! Bonuses! Wages Paid Weekly via Direct deposit/check depend on... 

Transformity

Software Engineer Job at Transformity

 ...big anime fan. Parents have owned multiple liquor stores.Raj (Founding Engineer): studied CS and Business @ Northeastern, worked at Chewy, built multiple products/startups before this, is a frontend wizard, a designer, and a baller (hes very tall).Param (CEO):...