Job Description
%3Cp%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EThe Department of Information Technology Services at West Virginia University is currently accepting applications for a Data Integration Engineer (Professional Technologist 3).%3C/span%3E%3C/p%3E%3Cp%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cstrong%3EAbout the Opportunity%3C/strong%3E%3C/span%3E%3C/p%3E%3Cp%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EWe 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.%3C/span%3E%3C/p%3E%3Cp style=%22-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);color:rgb(0, 0, 0);font-family:Arial;font-size:13.02px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:0px 0px 12px;orphans:2;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EWe strongly believe in work-life balance and keeping time for things we love outside our work. WVU offers generous benefits, including:%3C/span%3E%3C/p%3E%3Cul style=%22-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);color:rgb(0, 0, 0);font-family:%26quot;Open Sans%26quot;, %26quot;Segoe UI%26quot;, Frutiger, %26quot;Frutiger Linotype%26quot;, %26quot;Dejavu Sans%26quot;, %26quot;Helvetica Neue%26quot;, Arial, sans-serif;font-size:13.02px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:12px 0px;orphans:2;padding:revert;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;%22%3E%3Cli style=%22line-height:1.25;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E37.5-hour work week%26nbsp;%3C/span%3E%3C/li%3E%3Cli style=%22line-height:1.25;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E13 paid holidays (%3C/span%3E%3Ca style=%22color:rgb(4, 95, 171);line-height:inherit;text-decoration:none;%22 href=%22 style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3Estaff holiday calendar%3C/span%3E%3C/a%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E)%3C/span%3E%3C/li%3E%3Cli style=%22line-height:1.25;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E24 annual leave (vacation) days per year or more based on years of service (%3C/span%3E%3Ca style=%22color:rgb(4, 95, 171);line-height:inherit;text-decoration:none;%22 href=%22 style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3Eemployee leave%3C/span%3E%3C/a%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E)%3C/span%3E%3C/li%3E%3Cli style=%22line-height:1.25;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E18 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)%3C/span%3E%3C/li%3E%3Cli style=%22line-height:1.25;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EWVU offers a range of%26nbsp;%3C/span%3E%3Ca style=%22color:rgb(4, 95, 171);line-height:inherit;text-decoration:none;%22 href=%22 style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3Ehealth insurance and other benefits%3C/span%3E%3C/a%3E%3C/li%3E%3Cli style=%22line-height:1.25;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E401(a) retirement savings with 6% employee contribution match, eligibility to continue health insurance, and other retiree perks. Looking for%26nbsp;%3C/span%3E%3Ca style=%22color:rgb(4, 95, 171);line-height:inherit;text-decoration:none;%22 href=%22 style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3Emore retirement benefits information%3C/span%3E%3C/a%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E? Check out retirement health insurance benefits, retirement income, and FAQ’s.%3C/span%3E%3C/li%3E%3Cli style=%22line-height:1.25;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EWellness programs%3C/span%3E%3C/li%3E%3C/ul%3E%3Cp%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cstrong%3EWhat You%27ll Do%3C/strong%3E%3C/span%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EAdminister and support Informatica Intelligent Data Management Cloud (IDMC) services, including Cloud Data Integration (CDI) and Mass Ingestion.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EManage day-to-day operations of the Informatica platform, including user access, roles/permissions, environment configuration, and service monitoring.%3C/span%3E%3Cbr%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EMonitor, troubleshoot, and resolve integration job failures, performance issues, and connectivity problems to ensure high availability and reliability of data pipelines.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EConfigure and maintain Secure Agents, runtime environments, and connectivity to on-premises and cloud data sources.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EDevelop, maintain, and optimize ETL/ELT pipelines using Informatica CDI, ensuring efficient data movement and transformation.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EWrite and tune complex SQL queries to support data integration, validation, and performance optimization across relational databases.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3ESupport code migrations and deployments across development, test, and production environments, following established SDLC and change management processes.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EConfigure and maintain connectors (databases, file systems, APIs, SaaS applications), including connection parameters and credentials.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EImplement and support authentication mechanisms (OAuth, tokens, service accounts, API keys) in alignment with enterprise security standards.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EWork closely with application teams, DBAs, and analysts to troubleshoot data issues and validate data flows.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EMaintain and enhance operational documentation, including runbooks, troubleshooting guides, and standard procedures.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EAssist with platform upgrades, patches, and new feature adoption in coordination with senior team members.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EParticipate in on-call support rotation for critical incidents and production support.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EContinuously learn and apply new tools and features within the Informatica ecosystem and related technologies.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3ECollaborate with DBAs and infrastructure teams on physical database design and storage optimization.%26nbsp;%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EKnowledge of cloud platforms (AWS/Azure) and connectivity to Snowflake and Informatica IDMC.%26nbsp;%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EUnix/Linux/Shell Scripting.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EMust have good Verbal and Written communication skills.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EAble to learn new technologies.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EBe available on an on-call basis for troubleshooting system and application problems as well as for critical deployments.%3C/span%3E%3C/li%3E%3Cli%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EOther duties as assigned by Management.%26nbsp;%3C/span%3E%3C/li%3E%3C/ul%3E 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. *! Licenses/Certifications Familiarity with data integration concepts and willingness to pursue relevant certifications (e.g., Informatica IDMC, CDMP) within 12 months of employment. *! West Virginia University is a place of purpose and community. We take pride in our profound impact on the state of West Virginia and are committed to the personal and professional growth of our employees. From the groundbreaking R1 research at our flagship campus in Morgantown to the career-oriented programs at WVU Potomac State in Keyser, and the technology-intensive programs at WVU Tech in Beckley, the contributions of WVU employees resonate across the state, touching lives and shaping futures. At WVU, you will discover a supportive community that champions work-life balance and fosters a collaborative atmosphere. Our core values — service, curiosity, respect, accountability and appreciation — unite us as Mountaineers. Join us at West Virginia University, where your work will make a lasting impact. To learn more about WVU, visit wvu.edu. West Virginia University is an Equal Opportunity Employer. We invite all qualified applicants regardless of race, color, religion, sex, national origin, age, disability, genetic information, or Veteran status.