ETL/SQL Solution Engineer

JOB DESCRIPTION/MINIMUM REQUIREMENTS:
• 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 and/or IDMC to pull data from external data sources and transform it to fit into a dimensional model.
• 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
• 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.
Minimum Requirements:
Years
Required/Preferred
Experience
8
Required
Experience developing mappings and workflows to automate ETL processes using Informatica Power Center and IDMC.
8
Required
Experience administering IDMC and Informatica Power Center
8
Required
Experiencing acquiring and integrating data from multiple data sources/technologies using Informatica Power Center and/or IDM for use by a Tableau data visualization object. Data source techs should include Oracle, SQL Server, Excel, Access and Adobe PDF.
8
Required
Experience designing and developing complex Oracle 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
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
Excellent oral and written communication skills.
4
Preferred
Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.
4
Preferred
Bachelor’s degree or greater in Computer Science, Information Systems, or Business or equivalent experience