Job Description :
- Informatica experience. Preferably in recent project. - Good knowledge experience of Oracle SQL, PL/SQL. Preferably in recent years. - Data Architect/ Analyst, Data Modelling Data Preparation. - Experience in MSTR
Responsibilities: Must Have Skills: MSTR, Informatica, Data Analysis, PL/SQL
- Hands on experience in developing Stored Procedures, Views and Functions, Complex queries using Oracle PL/SQL.
- Interact with cross-flow teams, Business analysts and Business User to gather requirements and provide solutions appropriate to their needs.
- Identify any performance bottlenecks with Informatica (Source, Target, Transformation) and provide recommendation to fix the issue.
- Worked on PL/SQL performance tuning based on explain plan and data set architecture.
- Experienced with creating Unit Test Cases for mapping and code reviews.