Location: PAN India(All LTI-Mindtree Office Locations)

Job description: 

• Design interfaces packages and load plans in ODI 12c

• Ensure correctness and completeness of Data loading Full load Incremental load

• Contribute in estimation Planning of ETL activities for the project plan

• Helping the team in writing complex queries Stored Procedures in Oracle

• Should have an expert level knowledge on how to handle index partitions and synonyms in Oracle database

• Optimizing execution time of interfaces by implementing best practices

• Coordinate with Project Manager and all leads to ensure implementation as per agreed scope

• Attend meetings and provide relevant clarifications on ETL work to both Internal as well as external stakeholders

• Take the complete ownership of ETL work in the project

• Interact with Business and IT team members to get clarifications on requirements implementation aspects