14061 – Informatica Data Integration Developer (Onsite) – Austin, TX
Start Date: ASAP
Type: Temporary Project
Estimated Duration: 12 months with possible extensions
Work Setting: Position will be 3 days remote with 2 days (Mondays and Wednesdays) required to be onsite at the location listed above.
Required:
• Availability to work 2 days/week at the Client’s site in Austin, TX (required);
• Experience developing mappings and workflows to automate ETL processes using Informatica IICS, IDMC or Power Center (8 years);
• Experience acquiring and integrating data from multiple data sources/technologies using Informatica for use by a Tableau data visualization object, including Snowflake, Oracle, SQL Server, Excel, Access and Adobe PDF (8 years);
• Experience designing and developing complex SQL scripts that are fast and efficient (8 years);
• Experience as a system analyst for data analytics, performance management system, or data warehousing project (8 years);
• Experience with technical writing and diagraming, 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);
• Experience in planning and delivering software platforms used across multiple products and organizational units (8 years);
• Experience designing and developing scripts using Python (8 years);
• Experience on an agile sprint team (8 years);
• Experience with JIRA software (8 years).
Preferred:
• Excellent oral and written communication skills (8 years);
• Experience writing well designed, testable, efficient code by using best software development practices (6 years);
• Experience with security principles and how they apply to healthcare data (4 years);
• Experience with software components for a performance metrics data visualization or business intelligence environment (4 years);
• Experience self-managing multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments (4 years);
• Bachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience (4 years);
• Experience in the Healthcare Industry (3 years);
• Experience in an HHS agency (2 years);
• Experience working with PII or PHI data (2 years);
• Experience with Web Applications and programming languages such as HTML, CSS, JavaScript, JQuery and API’s (2 years);
• Experience creating website/user interfaces by using standards HTML/CSS practices (2 years);
• Experience with Web Services (REST, SOAP, etc.) (2 years);
• Experience developing dashboards and reports using Tableau, including connecting to external data sources (2 years).
Responsibilities:
• Understand business objectives and problems, identify alternative solutions, and perform cost/benefit analysis of alternatives;
• Analyze user requirements, procedures, and problems to automate processing or improve existing computer systems;
• Write detailed descriptions of user needs, program functions, and steps required to develop or modify computer programs;
• Review computer system capabilities, specifications, and scheduling limitations;
• Develop complex SQL scripts to transform source data to fit into a dimensional model, then create views and materialized views in Oracle;
• Develop automation with Informatica IICS or Power Center to pull data from external sources and transform it to fit into a dimensional model;
• Enhance and maintain the Java website that provides Tableau dashboards to users with different roles.