Informatica Cloud Developer

IICS Technical Lead

1. Having Good Data Ware House, ETL ( Extract, Transform & Load ) Concepts.

2. Experience with Designing a Data Warehouse, Preparing Data Flow Diagram.

3. Interpretation of Architecture digram/Data flow diagram and design the ETL solution accordingly.

4. Having clear concepts on Slowly Changing Dimension ( SCD Type 1 & Type 2 ), Intermediate table, Truncate/Insert Tables.

3. Clear Concepts about various Active & Inactive Transformations.

4. Clear Concepts on developing the mapping following coding standards & naming convention. Capable of defining Coding standard for a new development project.

5. Clear concepts on Parameterization. Concepts on how to set up the configurations for a new development project.

6. Clear concepts on how to troubleshoot an issue in IICS ( Data Preview mode/ setting the Verbose mode in mapping Task ).

7. Concepts on various Performance improvement techniques like enabling Cache, Use of Persistent Cache, use of PDO ( Push Down Optimization ) etc.

8. Should have experience working with different files ( flat file, JSON/XML, csv, fixed width etc ).

9. Should have clear concepts on SQLs - different joins, analytical functions like rank, group by, string manipulation fuction like - substr, instr etc.

10. Should have knowledge on usage of basic unix commands - cd, cp, mv, mkdir, chmod, sed, grep, cut, awk etc.

11. Should have knowledge on job scheduling, how a third party job scheduler like IBM TWS, HCL DWC or Control M works.

12. Should have good stakeholder management skills.

13. Should have experience of leading a team.

Advanced/Good to have Skill

1. PC to IICS Migration experience.

2. Usage of RPA tool.

3. Experience of using any Cloud Migration accelerators.

4. Any scripting language like shell scripts/Python.

5. Experience working in RFP/Estimates."