Informatica_4-6 Yrs_Pune

Short Description

Primary/ Must have
• 4-6 years of development experience in Informatica
• Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations
• Ability to understand and analyze the data to find patterns and valuable business insights
• Good knowledge of Unix scripting
• Experience in integration of various data sources like Teradata, Hadoop, SQL Server, and Flat Files into the staging area
• Expert in designing Parallel jobs using various ETL transformations. 
• Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
• Expert knowledge of Teradata (or similar DB), SQL Stored Procedures, Triggers, and data querying optimization
• Excellent communication, interpersonal, analytical and leadership skills, self-motivated, quick learner and a team player. Ability to work in a team and individually, independent thinker, focused on meeting deliverables in a remote environment
• Clear understanding of RDBMS, ER, 3rd n forms, OLAP dimensional Models

 

Qualifications

Job Responsibilities

Primary/ Must have
• 4-6 years of development experience in Informatica
• Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations
• Ability to understand and analyze the data to find patterns and valuable business insights
• Good knowledge of Unix scripting
• Experience in integration of various data sources like Teradata, Hadoop, SQL Server, and Flat Files into the staging area
• Expert in designing Parallel jobs using various ETL transformations. 
• Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
• Expert knowledge of Teradata (or similar DB), SQL Stored Procedures, Triggers, and data querying optimization
• Excellent communication, interpersonal, analytical and leadership skills, self-motivated, quick learner and a team player. Ability to work in a team and individually, independent thinker, focused on meeting deliverables in a remote environment
• Clear understanding of RDBMS, ER, 3rd n forms, OLAP dimensional Models

Secondary/ Desired skills
• Experience on visualization tools like Tableau, Business Objects XI3.1, Qlikview, Crystal Report is a strong plus
• Financial Services experience will be a strong plus
• Ability to research and troubleshoot technical problems
• Ability to effectively interact with, present information to, and respond to questions from all levels of the organization and partners. 
• Ability to communicate complex analysis in a clear, precise, and actionable manner
• Comfortable with ambiguity, creative thinking and leading change