Dutech’s Job
ETL Informatica Power Center Developer
Austin,TX
DatePosted : 3/12/2024 6:53:10 AM
JobNumber : DTS101765841JobType : Contract
Skills: mappings and workflows to automate ETL processes using Informatica Power Center and IDMC, administering IDMC and Informatica Power Center, 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.
Job Description
- 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 and/or IDMC 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
- All other duties as assigned.
- CANDIDATE SKILLS AND QUALIFICATIONS
|
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. |
|
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 |
SHARE THIS JOB
