Oracle and Informatica Developer

Job Title : Oracle Informatica Developer Location: Remote Years Of Experience : 5+ Years Job Description : Our team is seeking an experienced Oracle Informatica developer to join us. As a member of our team, you would be a self-starter and capable of working independently to high standards of quality. Requirements :

• 5+ years of relevant experience in Informatica and 3 years’ experience in Oracle or any relational databases. 
• Design, test, and implement data mapping and workflows to extract, transform and load data into the target environments (batch files, databases) 
• Expert SQL query skill in Oracle and SQL Server for any analysis and high-volume relational databases. 
• Ability to handle large datasets and different data types (XML, JSON, csv). 
• Analyse new data sources and integration of data into readily available formats while maintaining existing structures and govern their use according to business requirements. 
• Cross-platform development expertise, including consuming APIs. 
• UNIX shell scripting experience 
• Create new mappings, transition of PL/SQL ETLs to new mappings, or modification of existing mappings. 
• Create or Maintain Technical design documents and develop test plans for ETL unit testing and integration testing. 
• Analyse existing mappings and batch jobs. 
• Assist with troubleshooting ETL batch jobs, session failure, tunning mappings and more across environments. 
• Provide technical guidance and business process expertise on special projects or system issues. 
• Transfer knowledge and transition work to the team. 
• Manage daily technical challenges and communicate with management if there are any risks or issues. 
• Interact with the Enterprise Architecture and Application Security teams to ensure that solutions are built in adherence with the defined enterprise standards. 
• Collaborate with cross-functional teams to deliver high-quality solutions