Job Description

Description

The Department of Information Technology Services at West Virginia University is currently accepting applications for a Data Integration Engineer (Professional Technologist 3).

About the Opportunity

We are seeking a Data Integration Engineer with solid hands-on experience in Informatica Intelligent Data Management Cloud (IDMC), including Cloud Data Integration (CDI) and Mass Ingestion. This role will focus on administration, pipeline support, troubleshooting, and SQL-based data integration tasks within our enterprise environment.

We strongly believe in work-life balance and keeping time for things we love outside our work. WVU offers generous benefits, including:

37.5-hour work week
13 paid holidays (staff holiday calendar)
24 annual leave (vacation) days per year or more based on years of service (employee leave)
18 sick days per year (for when you’re ill, for when you need time to care for sick family, for your own, or your family’s, regularly scheduled medical appointments. Who is family for the purpose of this leave? A lot of people in your life including immediate relatives and in-laws as well as others considered to be members of your household living under the same roof)
WVU offers a range of health insurance and other benefits
401(a) retirement savings with 6% employee contribution match, eligibility to continue health insurance, and other retiree perks. Looking for more retirement benefits information? Check out retirement health insurance benefits, retirement income, and FAQ’s.
Wellness programs
What You'll Do

Administer and support Informatica Intelligent Data Management Cloud (IDMC) services, including Cloud Data Integration (CDI) and Mass Ingestion.
Manage day-to-day operations of the Informatica platform, including user access, roles/permissions, environment configuration, and service monitoring.
Monitor, troubleshoot, and resolve integration job failures, performance issues, and connectivity problems to ensure high availability and reliability of data pipelines.
Configure and maintain Secure Agents, runtime environments, and connectivity to on-premises and cloud data sources.
Develop, maintain, and optimize ETL/ELT pipelines using Informatica CDI, ensuring efficient data movement and transformation.
Write and tune complex SQL queries to support data integration, validation, and performance optimization across relational databases.
Support code migrations and deployments across development, test, and production environments, following established SDLC and change management processes.
Configure and maintain connectors (databases, file systems, APIs, SaaS applications), including connection parameters and credentials.
Implement and support authentication mechanisms (OAuth, tokens, service accounts, API keys) in alignment with enterprise security standards.
Work closely with application teams, DBAs, and analysts to troubleshoot data issues and validate data flows.
Maintain and enhance operational documentation, including runbooks, troubleshooting guides, and standard procedures.
Assist with platform upgrades, patches, and new feature adoption in coordination with senior team members.
Participate in on-call support rotation for critical incidents and production support.
Continuously learn and apply new tools and features within the Informatica ecosystem and related technologies.
Collaborate with DBAs and infrastructure teams on physical database design and storage optimization.
Knowledge of cloud platforms (AWS/Azure) and connectivity to Snowflake and Informatica IDMC.
Unix/Linux/Shell Scripting.
Must have good Verbal and Written communication skills.
Able to learn new technologies.
Be available on an on-call basis for troubleshooting system and application problems as well as for critical deployments.
Other duties as assigned by Management.

Qualifications

Bachelor’s degree
A minimum of four (4) years combined experience involving:
Information Technology Experience
Experience working with relational databases (Oracle, SQL Server, Snowflake, PostgreSQL, etc.) using SQL for data querying, transformation, and analysis
Hands-on experience supporting and developing data integration pipelines using Informatica IDMC, including Cloud Data Integration (CDI) and/or Mass Ingestion
Experience administering or supporting data integration platforms in a production environment, including job monitoring, troubleshooting, and performance tuning
Any equivalent combination of related education and/or experience will be considered.
All qualifications must be met by the time of employment.
Knowledge, Skills, & Abilities

Solid understanding of Informatica IDMC administration, including Secure Agent setup, connection management, and job monitoring.
Strong proficiency in SQL for data transformation, validation, and performance tuning.
Good understanding of ETL/ELT concepts, data integration patterns, and data processing workflows.
Experience troubleshooting data pipeline failures, connectivity issues, and performance bottlenecks.
Familiarity with API integrations and working with REST/SOAP services.
Ability to work with structured and semi-structured data (JSON, XML, flat files).
Understanding of security best practices, including credential management and secure connectivity.
Experience with job scheduling, logging, and monitoring tools within Informatica or similar platforms.
Ability to create and maintain technical documentation (runbooks, SOPs, deployment steps).
Strong analytical and problem-solving skills with attention to detail.
Ability to work independently and manage multiple tasks in a fast-paced environment.
Effective verbal and written communication skills for collaborating with technical and functional teams.
Willingness and ability to learn new technologies and adapt to evolving data platforms.
Ability to work under pressure and meet deadlines while maintaining accuracy and quality.

Requirements

Licenses/Certifications

Familiarity with data integration concepts and willingness to pursue relevant certifications (e.g., Informatica IDMC, CDMP) within 12 months of employment.