West Virginia University is seeking a Data Integration Engineer to join their Department of Information Technology Services. The role focuses on administering and supporting Informatica Intelligent Data Management Cloud services, managing data integration tasks, and ensuring the reliability of data pipelines.
Responsibilities:
- 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
Requirements:
- 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
- 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
- Familiarity with data integration concepts and willingness to pursue relevant certifications (e.g., Informatica IDMC, CDMP) within 12 months of employment