Sr. ETL Data Engineer (Informatica/Oracle)

Neos is Seeking a Sr. ETL Data Engineer (Informatica / Oracle) for a contract role for with our client in Austin, TX. • ONSITE - ONLY CANDIDATES CURRENTLY RESIDING IN THE AUSTIN, TX AREA WILL BE CONSIDERED • • • The primary work location will be 4601 W Guadalupe St, Austin, Texas 78751 Position is ONSITE at the location listed above (NO REMOTE WORK). LOCAL ONLY candidates for this position (Within 50-mile radius). • Subject to change per the hiring team • • Interviews will be conducted ONSITE in Austin. No calls, no emails, please respond directly to the “apply” link with your resume and contact details. Description Of Services • Develop the DAP/PMAS Report on Medicaid Personal Care Services • 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 Performance Management & Analytics System (PMAS). As a member of the agile development team, the worker responsibilities may include: • Filling the role of a technical leader, leading an agile development team through a project. • 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 Power Center/IICS 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. • 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 • All other duties as assigned. Candidate Skills And Qualifications 8 yearsRequired — Experience developing mappings and workflows to automate ETL processes using Informatica Power Center or IICS. 8 yearsRequired — Experiencing acquiring and integrating data from multiple data sources/technologies using Informatica Power Center or IICS for use by a Tableau data visualization object. Data source techs should include Oracle, SQL Server, Excel, Access and Adobe PDF. 8 yearsRequired — Experience designing and developing complex Oracle and/or Snowflake SQL scripts that are fast and efficient 8 yearsRequired — Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project. 8 yearsRequired — 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 years Required — Experience in planning and delivering software platforms used across multiple products and organizational units. 8 yearsRequired — Proven ability to write well designed, testable, efficient code by using best software development practices 6 YearsPreferred — Excellent Oral And Written Communication Skills. 6 yearsPreferred — Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required. 4 YearsPreferred — Experience On An Agile Sprint Team 4 yearsPreferred — Understanding of security principles and how they apply to healthcare data 4 yearsPreferred — Experience with state of the art software components for a performance metrics data visualization or business intelligence environment 4 yearsPreferred — Bachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience. 4 YearsPreferred — Prior Experience In The Healthcare Industry 4 yearsPreferred — Prior experience with an HHS agency 4 yearsPreferred — Prior experience working with PII or PHI data Preferred 4 yearsPreferred — Experience designing and developing scripts using Python 4 years Preferred — Experience with JIRA software 2 yearsPreferred — Functional knowledge or hands on design experience with Web Services (REST, SOAP, etc.) 2 years Preferred — Experience designing and developing code using Java and JavaScript 2 yearsPreferred — Experience developing CI/CD pipelines with GitHub and Git Actions 2 YearsPreferred — Experience As a Mulesoft Developer 2 yearsPreferred — Experience developing code in C# #DICE