Rate: Open

• Develop new ETL application using Informatica Power Center to load large amounts of data from multiple data sources into Data Repository using Oracle database
• Develop Data Integration procedures using Informatica suite of tools
• Develop SQL programs and Stored Procedures as required for the
• ETL processes and Data Integration activities
• Provide support to technical team, write the necessary required documentation as per CWTs methodology for
• ETL processes, develop unit test plan, test cases and resolve ETL related test problems
• Participate in planning activities with our business team to establish scope, priorities, work estimates and schedules
• Coordinate, plan, communicate, develop and review business presentations and documentation as required
• Work with the application teams to understand the nature of ETL interfaces and the architecture of the application.
• Design the appropriate interface interactions for each, while being cognizant of opportunities for reuse and standardization of interactions across applications
• Identify, mitigate and provide solutions to project issues and risks
• Provide mentorship and direction to move junior analysts within the team

• Demonstrated experience in designing ETL processes using Informatica for high-volume, complex data environments
• Data warehouse data modeling experience
• Proficiency in relational databases concepts; 9+ years of experience in Oracle and SQL*Plus programming; strong
• Conceptual knowledge of Oracle database fundamentals and administration.
• Having DBA experience is a plus
• Demonstrated Strong experience using the Informatica Suite of Tools
• Power Center version 8 or higher, Power Exchange version 8 or higher
• Strong experience in the design and development of mappings, transformations, sessions and workflows in PowerCenter
• Excellent Written and Verbal skills; Ability to Communicate effectively with all levels especially Executives
• Strong knowledge of software installation, configuration, ETL development, object migration and performance tuning /optimization and Informatica command line utilities.
• Strong experience in SQL in the Oracle environment
• Agile methodologies
• Work in a team environment
• Travel Industry data knowledge experience