YOU MUST APPLY TO THIS LINK TO BE CONSIDERED: https://www.azstatejobs.gov/jobs/senior-informatica-developer-remote-options-arizona-united-states-phoenix
The Department of Economic Security, Division of Technology Services, is seeking an experienced and highly motivated professional to join our team as a Senior Informatica IDMC Developer (Applications Development Senior). The individual in this role will be responsible for the complete life cycle and the management of Master Data Management (MDM) processes and database systems.
Essential Duties and Responsibilities include but are not limited to:
- Design, develop, and optimize ETL workflows and mappings using Informatica SAS MDM and Intelligent Data Management Cloud (IDMC).
- Troubleshooting and resolving technical issues. Fixing bugs or issues within the software.
- Document ETL processes, workflows, and best practices.
- Collaborate with data architects, analysts, and business stakeholders to understand data integration needs and implement solutions.
- Informatica Administration.
Knowledge of:
- Informatica REST APIs.
- Informatica Cloud, specifically SAS MDM (IDMC).
- MS SQL Server.
- Data warehousing concepts and BI architecture.
- Different scripting languages.
- Data Modeling / Data Warehouse Designing concepts.
- AZURE DEVOPS.
Skills In:
- Expertise in Master Data Management aspects - Data collection, standardization, Ingestion, Match / Merge rules and Survival conditions.
- Expertise in ETL data management areas such as ETL and database architecture and design, data warehouse design and implementation, and administration.
- Developing, maintaining and testing all IDMC workflows.
- Strong problem-solving and analytical skills, conducting the testing process, and resolving all defects.
- Strong SQL experience and an understanding of dimensional data models to design a robust and secure Data modeling experience to design Datawarehouse.
- Strong skills in all phases of the Software Development Life Cycle (SDLC) using Agile methodologies.
- Excellent communication skills.
Ability to:
- Translate business requirements into technical solutions.
- Work effectively.
- Prioritize tasks and work concurrently on multiple tasks.
- Build strong relationships inside and outside the organization.
- Write technical documentation.
- Work well independently and in a team environment.
- Use or maintain testing frameworks, test libraries, databases, and test environments.
The ideal candidate for this position will have:
- Bachelor's degree OR Five plus years of advanced Informatica design and development skills using Informatica SAS MDM and Power Exchange.
- Experience in developing Informatica ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
YOU MUST APPLY TO THIS LINK TO BE CONSIDERED: https://www.azstatejobs.gov/jobs/senior-informatica-developer-remote-options-arizona-united-states-phoenix