Informatica Lead in Saint Louis, MO

View All Technical Services jobs

Industry:

Technical Services   •  

5 - 7 years

Posted 8 weeks ago

Description

7 Years of experience in Informatica Development and database(Min 4 years of experience in Teradata). Good Knowledge on DWH concepts Ability to gather requirements and convert business requirements to technical requirements. Prepare technical specifications documents. Experience of developing ETL application using Informatica PowerCenter (development experience, not just support experience). Involved in creating the mappings in order to extract the data from source to target using Informatica designer. Evaluate all functional requirements and map documents and perform troubleshoot on all development processes Documents all technical specifications and associate project deliverables. Design all test cases to provide support to all systems and perform unit tests. Should analysis the data and develop understand the ETL specifications. Develop mappings if required Develop Informatica 9x & 10x mapping, session and workflow. Involved in creating the sessions, commandtasks, workflows using the workflow designer. Good at working with transformations including complex transformations Involved in building autosys to schedule the ETL Workflows. Familiar with Stored Procedures and implementing them in the ETL jobs of Informatica. Worked on the HLD and LLD document. Very good at UNIX and LINUX shell scripting Strong Database Experience with strong knowledge of writing complex SQL queries and Stored procedures. Strong Experience in Teradata utilities. Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks. Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills. Team player, Motivated, able to grasp things quickly with analytical and problem solving skills. Comprehensive technical, oral, written and communicational skillsShould have Strong Analytical and interpersonal skills with good written and verbal communication.