The candidate should have 9-12 years of experience in handling Data Warehousing and Data Integration Projects involving various Technologies. Worked as IICS Admin as core skill.
Platform support and strong admin knowledge.
Designing and developing data integrations using Informatica Cloud(IICS)
Well versed with all IICS Client Components.
Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies
Involved in complete end to end ETL project lifecycle.
Good expertise in creating complex Taskflows, reusable components and user function.
Experience in advanced concepts like partitioning, optimization, and performance tuning.
Good knowledge in SQL and data analysis.
Good in Agile development methodology.
Monitor all performance metrics for various production systems and identify root cause for all technical issues and recommend solutions.
IT experience in Analysis, Design, Development, Implementation, Testing of Data Warehousing and Data Integration Solutions using IICS
Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
Creates ETL Mappings, Mapplets, Workflows, Work
"LTI values diversity and inclusion and is committed to the principles of Equal Employment Opportunity
EOE/Minority/Female/Veteran/Disabled/Sexual Orientation/Gender Identity."