Lead Software Engineer Informatica & Data Integration
Role details
Job location
Tech stack
Requirements
Strong hands-on experience with Informatica PowerCenter (or Informatica Intelligent Cloud Services) for ETL development, data integration, and workflow orchestration.
Extensive experience with Acorn applications/platforms, including development, configuration, support, and integration.
Strong proficiency in Oracle Database, Microsoft SQL Server, and Essbase for database design, development, performance tuning, and data analysis.
Expertise in writing complex SQL, stored procedures, views, functions, and performance optimization.
Experience in designing and maintaining enterprise data integration solutions and ETL pipelines.
Strong understanding of data warehousing concepts, data modeling, and data migration.
Experience troubleshooting production issues related to ETL processes and database performance.
Good to Have: Experience working with Mainframe technologies, including integration with enterprise applications.