Data Integration Engineer

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.

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.