Detail Job Description:• Build and support
ETL mapping/workflows using Informatica tool.
• Define transformation rules for source to t
arget mappings and develop the software components to support the transformation
• Interact with Business Intelligence Lead, other staff, and other program technical staff as needed to ensure proposed development strategy and implementation meets programs objectives
• Ensure all software developed for migration of production data is developed, controlled, and tested to the same quality level as production software
• Facilitate the production release of new functionality and provide support of production issues.
Requirements and General Skills:• Extensive experience with Informatica ETL development and application troubleshooting, workload management, performance tuning. Experience working with high volume transactions is desired.
• Experience with Vertica and Teradata environments and its tool set is desirable
• Experience developing and implementing best practices in ETL specifics to process control, exception management in an
EDW environment.
• Experience working with Web Logs is a plus
• Good interpersonal skills, with ability to work across functional lines, and at many levels.
• Ability to work on assigned tasks independently and execute with minimal direction.
• Must be able to work on multiple projects simultaneously, meet project deadlines, and work under tight timelines.
Technical Skills:- Informatica
- Teradata (or any databases like oracle/Vertica/sqlserver). Teradata tools (FastLoad, MLoad, BTEQ)
- Unix scripting
- Automation tool (tidal/autosys/control M etc)
- Having "Java plugin for Informatica " experience would be highly desirable since that would encompass SOAP,
- Java/web services, and XML experience.
Good to have skills are below