Data Warehouse Specialist - Remote - cyberThink : Job Details

Job Description: As a Data Warehouse Specialist, you will play a key role in migrating ETL workflows from Informatica PowerCenter to Informatica's Intelligent Data Management Cloud (IDMC). Working within the Enterprise Business Intelligence (EBI) team, you will utilize the Informatica Migration Toolset to support seamless transition and data integrity throughout the migration process. The role involves analyzing EBI data, implementing workflow automation, troubleshooting production issues, and optimizing ETL processes. Candidates must have a robust background in IDMC and cloud-based Informatica tools and adhere to rigorous data governance standards. This role demands an experienced professional with a deep knowledge of Informatica cloud-based migration tools, ETL processes, and workflow automation. Candidates must possess strong problem-solving skills and be ready to ensure the integrity and performance of data migrations in a highly regulated environment. Key Responsibilities:

• Lead the migration of ETL workflows from PowerCenter to Informatica's Intelligent Data Management Cloud (IDMC).
• Utilize Informatica Migration Toolset, address inconsistencies, and manually migrate ETL workflows where automation is insufficient.
• Analyze and validate EBI data, transformations, and integrations to ensure data accuracy and consistency post-migration.
• Recommend performance improvements and optimize ETL scheduling for efficiency and reliability.
• Work with EBI and agency stakeholders to ensure alignment on migration strategies and troubleshoot operational issues.
• Leverage expertise in Informatica PowerCenter, EDC, IDQ, IICS, and IDMC for successful workflow transitions.
• Monitor and support EBI workflows, communicating with subject matter experts on any failures, outages, or delays.
• Utilize CA Workload Automation DE for workflow automation and efficient ETL scheduling.
• Apply coding standards, release management procedures, and version control practices (GitHub) as directed.
• Safeguard data in accordance with EBI Data Governance and applicable regulations, ensuring compliance with state, federal, and industry standards.

Required Skills, Experiences, Education, and Competencies:

• Demonstrated experience in at least three IDMC or Informatica MDM SaaS projects (not on-premises EDC) as an implementer, developer, or tester.
• Proficiency in Informatica PowerCenter, EDC (Metadata Management), IDQ (Data Quality), IICS, IDMC, and HL7 library on Linux.
• Strong understanding of workflow automation, with hands-on experience using CA Workload Automation DE.
• Excellent troubleshooting and operational support skills for production systems, including workflow monitoring and performance tuning.
• Proven ability to collaborate with stakeholders and communicate effectively on technical issues and migration progress.
• Commitment to data governance and compliance, with experience in safeguarding sensitive information per regulatory standards.
• Ability to produce accurate time and resource estimates for task completion in collaboration with project teams.

The hourly range for roles of this nature are $40.00 to $80.00/hr. Rates are heavily dependent on skills, experience, location, and industry. cyberThink is an Equal Opportunity Employer.