Description

Qualification

·       BE Computer Science and Engineering

Professional Training 

·      SQL Development, SAS EG, SAS DI, Object-orientated Programming (e.g. C#, Java)

Experience Required:

Experience in the following tools (3+ years)

o  SAS Management Console 
o  SAS DI, SAS Enterprise Guide 
o  Base SAS 
o  SAS Web Report Studio, SAS Delivery Portal, SAS OLAP Cube Studio, - SAS Information Maps, SAS BI 
o  SAS Stored Process, SAS Datasets & Library

·       Experience to configure/install applications in the servers(windows/Linux/Unix) and
basic knowledge of DNS, Ports, and Firewalls (3+ years) 
·       Experience managing and further developing distributed systems and
clusters for both batch as well as streaming data (Hadoop/Spark and/or Kafka/Flink)
·       Experience in handling semi-structured data sets(eg. JSON,XML) (3+ years)
·       Experience in C# or Java (3+ years)
·       Banking and Finance, Financial accounting and Reporting Environment
·       Expertise in writing advanced SQL Query, Stored Procedures and functions
·       ETL Tools SAS platform Tools like SAS DI / SAS Enterprise Guide andMicrosoft SQL Server.
·       Sound understanding of Financial Reporting(Balance Sheet/Profit and Loss) and Risk Reporting.
·       Developing within database and specifically Microsoft SQL Server and/or Oracle (minimum of 3+ years required).

Responsibility

·       Consolidate and analyze financial data (budgets, income statement forecasts ,Balance Sheet, Profit and Loss) taking into account company’s goals and financial standing
·       Build Stored procedure and ETL Jobs to Reconcile transactions by comparing and correcting data
·       Contribute to data warehouse design and components, relational database management systems, and database design solutions
·       Develop SQL Server T-SQL procedures/functions for batch processing as well as reports, in line with user requirements
·       Build SAS EG,SAS DI jobs
·       Research and resolve discrepancies in financial data ,Manage the month-end close process.
Skills

·      Solving Complex Problems
·      Testing and Troubleshooting
·      Regulatory Compliance
·      Financial Reporting
·      ETL/ETT/ETM Tools and Process
·      Risk Management
·      Data Warehouses
·      Data Marts
·      Balance Sheet,Profit & Loss,Market Risk
·      Data Modeling
·      SAS, SAS BI, MS SQL Server, T-SQL in data warehousing/batch

Domain : Bank

Years of Experience 5 + years

Education

 BE Computer Science and Engineering