Job Description :
Role: IICS Consultant Location: Los Angeles, CA Rate: $65 Remote/Onsite: Initial Remote ok Hiring Type: TP End Client: NA Mandatory skills: IICS, Support experience JD: Strong skills and robust experience in Informatica Intelligent Cloud Services (IICS), Informatica Power Center and SQL, Azure SQL Data Warehouse experience, Data migration to Microsoft Azure; Prior experience and expertise with this platform will be advantageous. Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization. Analyzes the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibility, Debug and tune data integration processes. Aalyze 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. Requirement analysis for Data Integration, Design ETL documents and develop jobs as per the requirement. Ensure adherence to client standard policies and quality compliance enterprise metadata definition