Data Analyst - Banking Domain

- Must have 4-6 Years of working experience on Oracle SQl.

- Should be able to write moderate to complex Oracle SQL.

- Strong experience in Excel involving VLOOKUP & Pivot and writing Macros.

- Experience of Banking Domain.

- To Extract & Validate Data for the Onshore Team for the Data Quality Assessment using Oracle SQL.

- To Extract Exception/Faulty Data using Oracle SQL.

- Create statistics in Excel regarding the Failed and Passed Data Quality Rules.

- Assessment of extracted data for its impact to business.

- To create test Cases in HP-ALM and Executing them.

- Perform Data Profiling using Informatica.

- Creating and scripting Oracle SQL's for testing Data Quality Rules.

- Work and communicate closely with onshore team regarding failures of Data Quality Rules.

- Trouble shoot problems in Oracle SQL's and provide solutions to data problems.

- Escalate problems with data and Data Quality Rules to Onshore Team

SHIFT: Should be ready to work in 1-9 or 2-10pm shift when required