IICS Middleware Administrator

Design & Development: Lead the design and implementation of complex ETL workflows to extract data from disparate sources (relational databases APIs flat files cloud storage) and extract / load from/to Oracle HCM Cloud.
Performance Tuning: Monitor and optimize ETL jobs and SQL queries to ensure maximum system performance and minimize processing windows.
Data Governance: Implement data quality checks validation rules and error-handling routines to ensure the accuracy and reliability of corporate data.
Collaboration: Maintenance & Support: Troubleshoot and resolve data integration issues providing root-cause analysis and long-term technical solutions.
Documentation: Maintain comprehensive documentation for ETL processes data mappings and technical workflows.

Administrator and support all Informatica environments from Development through Production.
Liaise with other Systems Administrators ITO teams UNIX Network and DBAs and supportinformatica installation configuration maintenance scheduling and software patches andupgrades.
Record cases with Informatica/ITO teams for product issues /requirements and ownaccountability in closing the ticket.
Support Informatica Code migration according to Middleware SCM path and ford approval process.
Support users creation user groups management connections and version control forInformatica Cloud services.
Support development teams with performance tuning and troubleshooting issues.
Generate Scheduling standards by monitoring Autosys runs and help refine refresh frequenciesfor Middleware and subscription systems.
Monitor System properties for ICS/ICRT/Secure agents and notify proactively for executingsystem scalability tasks.
Support disaster recovery process for Middleware primary and secondary productionenvironment.
Monitor the environment to proactively identify troubleshoot and resolve issues. Conduct root
cause analysis to identify and resolve complex problems impacting service levels.
Administer security permissions for all users and ensure compliance to required Ford corporate
standards procedures guidelines and processes including audits.
Document the configuration of the system system controls and procedures.

Experience: A minimum of 4 years of professional experience in Data integration middleware technologies and software development principles along with excellent communication and leadership skills.

Technical Expertise: With Extensive experience:
IICS - Informatica Intelligent Cloud Services Administrator
IICS - Informatica Intelligent Cloud Services - Data Integration
IICS - Informatica Intelligent Cloud Services - Application Integration
Oracle HCM Cloud - HCM Extract BIP HDL Data loader Using IICS Cloud
Advanced proficiency in SQL (complex joins stored procedures indexing and query optimization).
Analytical Skills: Strong ability to perform data discovery and business analysis to understand data lineage and business logic.
Strong problem-solving and analytical skills