Informatica IICS Developer

Must Have 10+ Years of Experience.

Must Have Skills:

· Informatica IICS, AWS Database Migration Service (DMS).

· SQL for crafting complex queries and optimizing them

· Data migration services db2 to Postgres experience is required

Required:

· Expertise in Informatica IICS, AWS Database Migration Service (DMS).

· Strong understanding of Extract, Transform, Load (ETL) processes and tools

· Experience with different database management systems such as PostgreSQL. Db2,

· Experience in data transformation, mapping, and conversion processes.

· Understanding of SQL for crafting complex queries and optimizing them. Ability to optimize database operations.

· Proficiency in Java and frameworks like Spring Boot.

· Experience with Java Persistence API (JPA) and Hibernate for ORM.

· Experience with testing frameworks like JUnit.

· Familiarity with BDD tools such as Cucumber for testing.

· Familiarity with tools and techniques for data validation and cleansing.

· Awareness of data security best practices and compliance requirements

· Familiarity with using cloud platforms for hosting databases and performing migrations Cloud.

Soft Skills:

· Excellent communication skills for collaborating with stakeholders.

· Project management abilities to plan and execute migration projects

Desired:

· Experience with scripting languages like Python or Shell scripting for automation tasks

· Performance Monitoring and Tuning - Ability to monitor system performance and conduct.

Java and frameworks like Spring Boot with BDD tools such as Cucumber for testing.