DEPARTMENT OF ECONOMIC SECURITY

Your Partner For A Stronger Arizona.

DES works with families, community organizations, advocates and state and federal partners to realize our collective vision: A thriving Arizona.

DES serves more than 3 million Arizonans. Our Mission is to strengthen individuals, families, and communities for a better quality of life.

SENIOR INFORMATICA DEVELOPER

Job Location:

Division of Technology Services (DTS)
1400 West Washington Street, Phoenix, Arizona 85007

Posting Details:

Salary: $90,000 - $111,000 

Grade: 27

Closing Date: February 24, 2025

Job Summary:

Would you like to be part of an amazing team that helps Arizonans thrive? At the Department of Economic Security (DES) we strengthen individuals, families, and communities for a better quality of life. DES is looking for individuals who are committed to service, community, and teamwork. To learn more about DES please visit des.az.gov; or click on the link here to view ‘Our DES’ video. Come Join the DES Team!

DES is seeking an experienced and highly motivated individual to join our team as a Senior Applications Developer (Senior Informatica Developer). This position responsible for the complete life cycle and the management of ETL (extract, transform, and load) processes and database systems. This role collaborates with business, development, and testing teams, as well as facilitates accurate data reporting within organization standards and maintains 24/7 system availability, investigates and analyzes issues, and researches opportunities for improvement of processes. This individual provides technical advice and guidance to the junior developers on the team while collaborating with business analysts and architects to contribute to projects that enhance system's functionality and support business requirements.

This position may offer the ability to work remotely, within Arizona, based upon the department's business needs and continual meeting of expected performance measures.

The State of Arizona strives for a work culture that affords flexibility, autonomy and trust. Across our many agencies, boards, commissions, many State employees participate in the State's Remote Work Program and are able to work remotely in their homes, in offices and in hoteling spaces. All work, including remote work, should be performed within Arizona, unless an exception is properly authorized in advance.

Job Duties:

Essential Duties and Responsibilities include but are not limited to:

• Design, develop, and optimize ETL workflows and mappings using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS).
• Troubleshoot and resolve technical issues. Fix 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 including monitoring running jobs, identifying performance bottlenecks, troubleshooting errors, and resolving issues related to data integration processes.

Knowledge, Skills & Abilities (KSAs):

Knowledge of:
• Strong understanding of data warehousing concepts and ETL processes
• SQL and understanding of dimensional data models to design a robust and secure Data modeling experience to design data warehouse
• REST APIs• Informatica Cloud, Data warehousing concepts and BI architecture
• Data Modeling / Data warehouse Designing concepts

Skills In:
• ETL data management areas such as ETL and database architecture and design, data warehouse design and implementation, administration
• Developing, maintaining and testing all IICS workflows.
• Conducting the testing process and resolve all defects
• Strong problem-solving and analytical skills
• Strong skills in all phases of the Software Development Life Cycle (SDLC) using Agile methodologies

Ability to:
• Translate business requirements into technical solutions
• Work effectively and independently or in a team environment
• Prioritize tasks and work concurrently on multiple tasks
• Build strong relationships inside and outside the organization
• Write technical documentation
• Use or maintain testing frameworks, test libraries, databases and test environments

Selective Preference(s):

This ideal candidate for this position will have: