Senior Specialist - Data Engineering

About the Role

Provide L2/L3 production support for the Informatica MDM platform, ensuring high availability of MDM CDIPC and associated integrations. This role involves performing root cause analysis, incident management, and problem management, while managing Informatica infrastructure, servers, repositories, and application environments. This position supports AWS migration and IDMC modernization initiatives and includes implementing monitoring, observability, automation, and performance optimization. The role participates in architecture reviews and modernization roadmap planning, ensuring compliance with SLA, security, and operational governance.

Required Skills

Informatica MDM Administration Expert

• MDM Platform: Informatica MDM Hub, SIF APIs, Batch framework, Match & Merge, Trust Framework, Hierarchy Manager, Data Stewardship, Business Entity Services, Provisioning Tool
• Operational Support: Repository maintenance, Hub Console administration, User role management, Batch monitoring, Queue monitoring, Error resolution, Metadata management

Informatica Infrastructure Administration Expert

• Application Servers: Tomcat, WebLogic, JBoss (if applicable)
• Informatica Components: MDM Hub, Process Server, ActiveVOS, Data Director, Provisioning Tool, Business Entity Services
• Administration Activities: Installation, Configuration, Patch upgrades, DR setup, Backup recovery, Capacity planning, Environment refresh

CDIPC Administration Support Expert

• Core Skills: CDIPC Runtime Engine, Secure Agent Administration, Connection Configuration, Parameter Management
• Runtime Monitoring: Production Support, Workflow failures, Session failures, Connectivity issues, Performance bottlenecks, Restart recovery procedures
• Monitoring: Job execution monitoring, Log analysis, Operational reporting

Database Administration Knowledge

• Strong: Databases Oracle (Preferred), SQL Server, PostgreSQL
• Skills: SQL tuning, PL/SQL, Query optimization, Database monitoring, Index analysis, Statistics collection, Data correction support

AWS Administration

• Strong: AWS Services EC2, RDS, S3, IAM, VPC, CloudWatch, CloudTrail, Lambda, Secrets Manager
• Responsibilities: Environment provisioning, Security management, Backup strategies, Monitoring setup, Cost optimization, Disaster recovery planning

Informatica IDMC Knowledge

• Strong: Services Cloud Data Integration, Cloud Application Integration, Cloud Mass Ingestion, Cloud Data Quality, MDM SaaS, Customer 360
• Administration: Secure Agents, Runtime Environments, Elastic Integration Services, Connection Management, Package Deployment, User Administration
• Migration Readiness: OnPrem to IDMC assessment, Asset inventory, Connectivity setup, Validation strategy, Deployment automation

Benefits and Perks

• Comprehensive Medical Plan Covering Medical, Dental, Vision
• Short Term and Long-Term Disability Coverage
• 401(k) Plan with Company match
• Life Insurance
• Vacation Time, Sick Leave, Paid Holidays
• Paid Paternity and Maternity Leave