Software Development Specialist 3

In today's data-driven world, Informatica Developers play a critical role in ensuring the integrity, reliability, and accessibility of data assets, which are foundational for business decision-making and strategic planning. Informatica Developers implement robust data governance practices, ensuring adherence to regulatory requirements such as HIPAA, and PII and FTI. As one of the leading state agencies, DCY has lot of ETL jobs that supports the BI reports and wide range of data sharing requests from multiple agencies.

Preferred Qualifications:

1. Demonstrated proficiency in data warehouse concepts with substantial experience in constructing Facts and Dimensions, including handling Slowly Changing Dimensions (SCD1, SCD2, etc.).

2. A minimum of three years' expertise in crafting and managing intricate SQL queries.

3. Minimum of three years of hands-on experience with Informatica PowerCenter, Alteryx Designer, or similar tools, specializing in the development and maintenance of ETL processes to ensure optimal performance, scalability, and data accuracy and integrity.

4. Extensive experience in optimizing and fine-tuning existing ETL processes to enhance efficiency and performance.

5. Good experience in production support.

6. Good experience in handling large volumes of data and building data marts using Informatica and experience with IDQ.

7. Proficient in utilizing data visualization tools such as Cognos, Power BI and Tableau to enhance analytical experiences.

8. Skilled at quickly adapting and providing efficient solutions to data warehouse requirements.

9. Adhere to best practices to identify and implement optimal solutions for any given problem.

At the State of Ohio, we take care of the team that cares for Ohioans. We provide a variety of quality, competitive benefits to eligible full-time and part-time employees*. For a list of all the State of Ohio Benefits, visit our Total Rewards website ! Our benefits package includes:

• Medical Coverage
• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems ( such as OPERS, STRS, SERS, and HPRS ) & Optional Deferred Compensation ( Ohio Deferred Compensation )

*Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.

Qualifications

60 mos. combined work experience in any combination of the following: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.

-Or completion of associate core program in computer science or information systems; 42 mos. combined work experience in any combination of the following: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.

-Or completion of undergraduate core program in computer science or information systems; 36 mos. combined work experience in any combination of the following: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.

-Or equivalent of minimum class qualifications for employment noted above. Note: The official position description on file with the designated agency is to reflect the required, primary technology directly relating to the duties of the position. Only those applicants possessing the experience in the required, primary technology listed in the position description & job posting are to be considered for any vacancies posted. The job posting must list the required technology commensurate with the position in question.

Job Skills: Software Development/Implementation