- Design develop test and deploy ETL ELT workflows using Informatica Intelligent Cloud Services IICS
- Develop data integration mappings mapping tasks taskflows and workflows
- Extract transform and load data from various sources including databases cloud platforms APIs and flat files
- Build and maintain data synchronization and data migration solutions
- Perform data validation data quality checks and reconciliation activities
- Troubleshoot and resolve performance issues in IICS jobs and mappings
- Collaborate with business stakeholders data architects and development teams to gather requirements
- Monitor maintain and support production environments
- Create technical documentation and adhere to coding standards and best practices
- Required Skills
- Solid hands on experience with Informatica IICS
- Experience in Data Integration Cloud Data Integration CDI and Application Integration
- Strong SQL skills and database concepts
- Experience with relational databases such as Oracle SQL Server PostgreSQL or MySQL
- Knowledge of ETL Data Warehousing concepts
- Experience with performance tuning and error handling
- Understanding of data modeling and data migration processes
- Experience with REST SOAP APIs and file based integrations
Technical Requirements:
- Strong hands on experience with Informatica IICS
- Experience in Data Integration Cloud Data Integration CDI and Application Integration
- Strong SQL skills and database concepts
- Experience with relational databases such as Oracle SQL Server PostgreSQL or MySQL
- Knowledge of ETL Data Warehousing concepts
- Experience with performance tuning and error handling
- Understanding of data modeling and data migration processes
- Experience with REST SOAP APIs and file based integrations
Preferred Skills:
Technology->Data Management - Data Integration->Informatica->Informatica - Data Quality,Technology->Data on Cloud - Datastore->Cloud based Integration Platforms->Informatica Intelligent Cloud services(IICS)