SENIOR APPLICATIONS DEVELOPER (SENIOR INFORMATICA DEVELOPER)

State of Arizona; Brasil; Teletrabalho; BRL 476.000 - 530.000; Tempo integral

Resumo da oferta

A government department in Arizona is seeking a Senior Applications Developer to enhance service to communities through ETL workflows and data integration. The ideal candidate has extensive experience with Informatica and related tools. This role offers a salary between $90,000 - $100,000 and the option to work remotely, supporting work-life balance in a flexible environment.

Serviços

Medical, dental, and life insurance

Retirement system participation

Paid Parental Leave

Flexible schedules

Tuition Reimbursement

Qualificações

• Five plus years of Informatica design and development skills.
• Experience in developing Informatica mappings using Designer and Workflow Manager.
• Bachelor’s degree plus 8 or more years of programming experience.

Responsabilidades

• Design and optimize ETL workflows using Informatica.
• Troubleshoot and resolve technical issues.
• Collaborate with stakeholders to implement data integration solutions.

Conhecimentos

ETL data management

SQL

REST APIs

Informatica Cloud

Scripting languages

AZURE DEVOPS

Formação académica

Bachelor’s degree

Ferramentas

Informatica PowerCenter

Informatica Intelligent Cloud Services (IICS)

Descrição da oferta de emprego

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 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

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!

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 employees flexibility, autonomy, and trust. Across our many agencies, boards, and 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.
• Other duties as assigned related to the position.

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
• Different scripting languages
• AZURE DEVOPS

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:

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

Pre-Employment Requirements

• Bachelor’s degree plus 8 or more years of programming and analysis experience (or equivalent experience)
• Employee shall obtain and maintain a valid Level One fingerprint clearance card that meets DES requirements for a Level One card pursuant to Arizona Revised Statute 41-1969.
• Successfully pass background and reference checks; employment is contingent upon completion of the above-mentioned process and the agency’s ability to reasonably accommodate any restrictions.
• All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

Benefits

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

• Affordable 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 accrued at 4.00 hours bi-weekly for the first 3 years
• Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
• Sick time accrued at 3.70 hours bi-weekly
• Deferred compensation plan
• Wellness plans
• Tuition Reimbursement
• Stipend Opportunities
• Infant at Work Program
• Rideshare and Public Transit Subsidy
• Career Advancement & Employee Development Opportunities
• Flexible schedules to create a work/life balance

By providing the option of a full-time or part-time remote work schedule, employees enjoy improved work/life balance, report higher job satisfaction, and are more productive. Remote work is a management option and not an employee entitlement or right. An agency may terminate a remote work agreement at its discretion.

Learn more about the Paid Parental Leave pilot program here. For a complete list of benefits provided by The State of Arizona, please visit our benefits page

Retirement

State employees are required to participate in the Arizona State Retirement System (ASRS), the State sponsored retirement contribution plan and the Long-Term Disability (LTD) program after a 27-week waiting period. The ASRS defined benefit plan provides for life-long income upon retirement. You will also have the option to participate in a voluntary deferred compensation program to take advantage of tax-deferred retirement investments.

On, or shortly after, your first day of work you will be provided with additional information about the available insurance plans, enrollment instructions, submission deadlines and effective dates.

Contact Us

For questions regarding this career opportunity, please contact Alex Rivera at 480-910-0533 or [e-mail].

The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer. Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by contacting 480-910-0533 or [e-mail]. Requests should be made as early as possible to allow time to arrange the accommodation.