This role focuses on data integration, particularly using Informatica and Microsoft SSIS, to support financial data migration and system integration efforts. Here’s a summary based on the requirements and job duties you provided:
Education:
- Required: Bachelor’s Degree in Computer Science or Information Systems. (Equivalent work experience can be substituted on a year-for-year basis.)
- Preferred: Informatica certification.
Experience:
- Minimum: 5 years in systems integrations and/or ETL (Extract, Transform, Load).
- Required Skills: Proven track record with integration tools like Informatica and Microsoft SSIS. Ability to provide detailed examples of past projects using these tools successfully.
Primary Duties and Responsibilities:
- Define impacts of the Florida PALM implementation on existing Department interfaces.
- Develop migration plans for current interfaces, adopting newer technologies like Informatica.
- Outline data inputs and outputs for Department assets interfacing with the Department of Financial Services (FLAIR), including manual entry, scripting, batch uploads, extracts, interfaces, and reporting.
- Design and implement data integration solutions with an emphasis on accuracy and integrity in financial data.
- Collaborate with the Comptroller’s Office to understand data requirements, and create data models for financial reporting and analysis.
- Evaluate and implement appropriate tools for secure and efficient data integration.
- Develop and conduct testing plans for data accuracy and reliability.
- Mentor CLIENT staff on Informatica best practices.
- Document data integration processes for compliance and team knowledge sharing.
- Ensure adherence to existing development standards and create detailed source-to-target mapping documents.
- Work closely with the reports remediation team to meet FPST project data requirements.
- Participate in Agile Scrum processes, including daily stand-ups, sprint planning, and retrospectives.
Job-Specific Knowledge, Skills, and Abilities (KSAs):
- Data Integration: Expertise in ETL/ELT pipelines, especially using Informatica Cloud (IICS services).
- SQL Proficiency: Strong SQL skills with databases such as DB2 v12, SQL Server, Azure SQL, and Snowflake Data Cloud.
- Informatica Cloud Data Integration: Minimum of 7 years of experience, including services like Cloud Data Integration, Mass Ingestion, Data Quality, and Cloud Data Governance.
- Data Warehousing & Lakehouse Architectures: 3+ years in implementing architectures with Snowflake Data Cloud.
- Teamwork and Communication:
- Ability to work independently or as part of a team.
- Effective communication with both technical and non-technical team members.
- Knowledge of Agile Project Management and SCRUM frameworks.
Preferred KSAs:
- Certifications: Informatica Cloud CDI and Snowflake Data Cloud.
- Additional Technical Skills:
- Experience building ETL/ELT pipelines with IICS, integrating databases like Oracle, DB2 on ZOS, SQL Server, Azure SQL, and Snowflake Data Cloud.
- Familiarity with Power Exchange Connectors for ZOS in Informatica Cloud CDI.
This role is well-suited for candidates with strong data integration experience in financial data environments, particularly those who can support and enhance financial reporting and analysis through efficient, secure data pipelines and collaborative cross-functional work.
