Business Analyst-SQL & Informatica
1 week ago
The Role is that of a BA to work on Informatica (on the data mart layer over an existing data warehouse).
To get technically involved in the Design and Development of Database objects such as Tables, Views, Index, Stored Procedures, Packages, Functions, Triggers, and Integrity Constraints.
Skills/access needed for testing support of integration work.
Basic SQL (write some queries, execute complex queries and add a simple filter, copy results to Excel).
Basic Informatica (override query, execute workflow, check status of workflow).
Basic Salesforce (write simple query in Workbench, execute and export to CSV).
Intermediate Excel (import data from SQL and Salesforce, manipulate/vlookup data to confirm the data matches).