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 support informatica installation, configuration, maintenance scheduling and software patches and upgrades.
· Record cases with Informatica/ITO teams for product issues /requirements and own accountability in closing the ticket.
· Support Informatica Code migration according to Middleware SCM path and ford approval process.
· Support user’s creation, user group’s management, connections and version control for Informatica Cloud services.
· Support development teams with performance tuning and troubleshooting issues.
· Generate Scheduling standards by monitoring Autosys runs and help refine refresh frequencies for Middleware and subscription systems.
· Monitor System properties for ICS/ICRT/Secure agents and notify proactively for executing system scalability tasks.
· Support disaster recovery process for Middleware primary and secondary production environment.
· 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
We don't just make history -- we make the future. Ford put the world on wheels over a century ago, and our teams are re-inventing icons and creating groundbreaking connected and electric vehicles for the next century. We believe in serving our customers, our communities, and the world. If you do, too, come move the world and make the future with us.
Ford is a global company with shared ideals and a deep sense of family. From our earliest days as a pioneer of modern transportation, we have sought to make the world a better place – one that benefits lives, communities and the planet. We are here to provide the means for every person to move and pursue their dreams, serving as a bridge between personal freedom and the future of mobility. In that pursuit, our 186,000 employees around the world help to set the pace of innovation every day.
Privacy Policy: https://www.ford.com/help/privacy/
