Job Title: Senior Consultant/Consultant – DW&BI (IICS)| IT Consulting
Job Location: Kolkata/Bangalore
• 5+ years into pure development experience as needed. • End to-end Data Warehousing and Business Intelligence Architect implementation experience • Expert knowledge of reports design and ETL design • Strong Hands-on experience in Informatica Power Center and cloud services. Expert knowledge in SQL. • At least 1 year of experience in Informatica Intelligent Cloud Services. • Well versed with all IICS Client Components like Data Integration, Administrator & Monitor. • Good understanding of the commonly used transformations like Source qualifier, joiners, union, aggregator, sorter, expression, transaction control, xml transformation, lookups etc. • Involved in at least one complete end to end ETL project lifecycle. • Good expertise in creating complex Taskflows, reusable components and user functions. • Experience in advanced concepts like partitioning, optimization, and performance tuning. • Solid Experience in writing complex SQL Queries, Unix Commands, Stored procedures • Analysis of requirement as per the Business Requirement Document and do impact analysis. • Mapping Development in Informatica 10.x and above • Design & Implement OLAP, ETL & Reporting Frameworks • IICS/Google Cloud experience is desired. • Excellent communication (Written & Oral) & Client Interfacing skills • Excellent Analytical & Organizational Skills • Creativity, Personal Drive, Influencing and Negotiating, Problem Solving. Building Effective • Relationships, Customer Focus, Effective Communication, Coaching • Knowledge of Competitive Products & Technology Desired Experience • Ability to work in a high-pressured, tight-deadline environment. • Must work well in a team environment as well as independent. • Excellent verbal/written communication and problem-solving skills; ability to communicate information to a variety of groups at different technical skill levels.