Location: Saint Louis, MO,
New Jersey
Job Type: Full Time
Salary: $Marketvalu per Hour
Experience Desired: 6 - 8 Years
Last Update: Sep 22, 2020 08:03:02 AM
Full Job Description:
• 6-8 yrs. experienced Sr. Data Engineer with AWS, Informatica Power Center, Teradata and Unix skills
Description:
• 8 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, 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.
Company Type: Direct Employer
Contact Name : Shajahan
Contact Phone: 8622005150
Contact Email :
Number of Views: 241