Informatica IICS(Mumbai, Chennai, Hyderabad, Bangalore, Ahmedabad)

Skillset: Informatica IICS DeveloperExperience Range : 4 to 8Location:(Mumbai, Chennai, Hyderabad, Bangalore, Ahmedabad)Job DescriptionBUSINESS INTELLIGENCE ETL DEVELOPER IICS (Informatica Cloud)The IICS (Informatica Cloud) Developer is a key, hands on role that will develop and deliver solutions that enable the collection, transformation, and management of information from one or more sources. This role will be integral in re-platforming the ETL to Informatica Cloud IICS.The ideal Developer for this role can handle end-to-end Data Warehouse and Data Integration by taking into consideration the business cases, objectives, and requirements. The technical domain of the position includes the Data Integration, App & API Integration, Data Replication and Mass Ingestions services of Informatica Intelligent Cloud Services. In addition, the responsibilities will include data integration, data architecture, information delivery, infrastructure, testing, performance tuning for all components of the project.The candidate should have the following key responsibilities:Understand pain points from a customer/vertical perspective for developing specific solutions. Identify the customer segment to position the new offering and develop business case for the new service offeringAnalyzing data integration requirements, analyzing data sources and targets, business rules, and transformation logicAnalyzes the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibilityCreate functional design for overall business intelligence solutionsDesign, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimizationDesign data integration and conversion strategy, exception handing mechanism, data retention and archival strategyDesigning and developing data extraction, cleansing, transformation, and loading processes and workflows to load dataDebug 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 methodologiesCreate artifacts from perspective of technology, product, domain and infrastructure as applicableData Quality managementGuiding other team members and external vendors to perform the sameAbility to effectively work in a fast-paced, energetic team environmentDesired skills for informatica architect include:Experience using cloud along with Informatica power center and data warehouse expertiseBackground in developing workflows, triggers along with integration and conversion experience using Informatica PowerCenter and Informatica CloudHands on experience in working with different databases e.g., SQL server, Oracle etc.Hands on experience in Unix shell scripting to track /automate the jobs using scripts and should be able to write/debug Shell ScriptsDemonstrated experience with data integration architectures, data analysis and implementationDemonstrated experience with Enterprise level Data WarehousingDemonstrated experience with SQL and PL/SQLDemonstrated experience and ability to deliver results quickly in a fast-paced environment on multiple projectsAbility to work with other IT groups and business usersExperience with BFSI projects a strong plusPreferred:Informatica Cloud CertificationQualifications:The candidate should have a bachelor's degree in computer science or in a related field. He should have a minimum of 4 years of experience in modeling and business system designs with a minimum of overall 8 years IT experience. His software skills should be excellent. He should have good observation skills and must be able to manage multiple deliveries at the same time. Having good communication skills would be considered an asset. At last, but not the least, he must have good organizing skills and should be able to work effectively in a team.