Job Title: Informatica Developer with Oracle PL / SQL
NOTE: Candidates MUST have good English.
Location: Mexico City, Mexico (REMOTE until COVID)
Rate: MXN 450 per hour
Contract Duration: 12+ months
Number of positions: 2
Should have minimum 5+ Year of Informatica Production Support Experience
Strong experience in developing Strategies for (ETL & ELT) mechanism using Informatica Power Center (9.X / 10.X) and Oracle Data Integrator (ODI 11.X / 12 C)
Strong experience in SQL & PL / SQL developed modularized applications with database procedures using database objects such as procedures functions packages triggers and cursors.
Experience in configuration management: Identifying and controlling the release of a product and its changes. Ensuring completeness and consistency of product among components
Hands on Experience on Informatica Power Center with SQL / T-SQL queries is mandatory
Should have good knowledge of the UC4 Job Scheduler
Basic knowledge of UNIX is mandatory, shell scripting is preferred.
Ability to design and develop Informatica mappings, sessions, workflows and identify areas of optimization
Ability to design, build, deploy and support end to end ETL processes
Demonstrate ownership of work assigned to self and immediate sub-ordinates
Update all documentation with task details and provide regular updates to team
Excellent oral and written communication skill and stake holder management.
Extensive experience as a solution provider for business information systems focusing on data analysis reporting ETL design Data migration and Analytics programming and integration.