SENIOR APPLICATIONS DEVELOPER

Overview

DEPARTMENT OF ECONOMIC SECURITY Your Partner For A Stronger Arizona. Our Mission is to strengthen individuals, families, and communities for a better quality of life. SENIOR APPLICATIONS DEVELOPER (SENIOR INFORMATICA DEVELOPER) Job Location: Division of Technology Services (DTS), 1400 West Washington Street, Phoenix, Arizona 85007. Posting Details: Salary: $90,000 - $100,000; Grade: 27; Closing Date: Open Until Filled.

Position Summary

The Department of Economic Security, Division of Technology Services (DTS) is seeking an experienced and highly motivated individual to join our team as a Senior Applications Developer (Senior Informatica Developer). This position is responsible for the complete lifecycle and management of ETL processes and database systems. This role collaborates with business, development, and testing teams, facilitates accurate data reporting within organization standards, maintains 24/7 system availability, investigates issues, and researches opportunities for process improvements. This individual provides technical guidance to junior developers and collaborates with business analysts and architects to contribute to projects that enhance system functionality and support business requirements.

Work Arrangement

This position may offer the ability to work remotely, within Arizona, based on department needs and meeting performance measures.

The State of Arizona supports a work culture with flexibility, autonomy, and trust. Remote work is subject to approval and not an entitlement.

Job Duties

Essential duties 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.
• Other duties as assigned related to the position.

Knowledge, Skills & Abilities

Knowledge:

• Strong understanding of data warehousing concepts and ETL processes.
• SQL and dimensional data models; data modeling experience for data warehouse design.
• REST APIs.
• Informatica Cloud, data warehousing concepts, and BI architecture.
• Data modeling / data warehouse design concepts.
• Different scripting languages.
• Azure DevOps.

Skills:

• ETL data management, data warehousing design and implementation, administration.
• Developing, maintaining and testing IICS workflows.
• Testing and defect resolution.
• Strong problem-solving and analytical skills.
• Experience with SDLC and Agile methodologies.

Ability:

• Translate business requirements into technical solutions.
• Work effectively independently or in a team.
• Prioritize tasks and manage multiple tasks concurrently.
• Build strong relationships inside and outside the organization.
• Write technical documentation.
• Use testing frameworks, databases and test environments.

Selective Preference(s)

This ideal candidate will have:

• Five plus years of advanced Informatica design and development skills using Informatica PowerCenter and PowerExchange.
• Experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager.

Pre-Employment Requirements

• Bachelor’s degree plus 8+ years of programming and analysis experience (or equivalent).
• Employee shall obtain and maintain a valid Level One fingerprint clearance card per DES requirements.
• Background and reference checks; employment contingent upon completion and accommodations.
• All new State employees must complete the E-Verify program.

Benefits

The Arizona Department of Economic Security offers a comprehensive benefits package including:

• Medical, dental, life, and short-term disability insurance plans.
• Participation in the Arizona State Retirement System (ASRS) and long-term disability plans.
• 10 paid holidays per year.
• Vacation time accrual.
• Paid Parental Leave – up to 12 weeks per year (pilot).
• Sick time accrual.
• Deferred compensation, wellness plans, tuition reimbursement.
• Stipend opportunities, infant at work, rideshare and transit subsidies.
• Career advancement and employee development opportunities.
• Flexible schedules for work/life balance.

Remote work option is not an entitlement and may be terminated at agency discretion. Learn about Paid Parental Leave and benefits on the benefits page.

Retirement & Contact

State employees participate in ASRS with optional deferred compensation. Details provided on first day.

Questions? Contact Alex Rivera at or The State of Arizona is an Equal Opportunity Employer. Reasonable accommodations available upon request.

#J-18808-Ljbffr

---