Data Specialist (Informatica PowerCenter & Teradata)

Hi,Please find an urgent requirement for a W2 contract role. Please respond ASAP

• 8 Years of experience in Informatica Development and database
• 2- 4 years of experience in Teradata
• Good Knowledge on DWH concepts
• Exposure in AWS related data services
• 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, command tasks, 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 scripts as well as SQL tuning.
• 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 skills
• Should have Strong Analytical and interpersonal skills with good written and verbal communication.