Data Specialist

Description

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.