Sr. SQL Developer (Banking Domain experience)

• Bachelor's degree required, or higher education level, or foreign equivalent, preferably in area wit
• At least 5 years experience in Duck Creek Data Insights as Technical Architect/Senior Developer.
• Strong Technical knowledge on SQL databases, MSBI.
• Should have strong hands-on knowledge on Duck Creek Insight product, SQL Server/DB level configuration, T-SQL, XSL/XSLT, MSBI etc
• Well versed with Duck Creek Extract Mapper Architecture
• Strong understanding of Data Modelling, Data Warehousing, Data Marts, Business Intelligence with ability to solve business problems
• Strong understanding of ETL and EDW toolsets on the Duck Creek Data Insights
• Strong knowledge on Duck Creek Insight product overall architecture flow, Data hub, Extract mapper etc
• Understanding of data related to business application areas policy, billing, and claims business solutions
• Minimum 4 to 7 year working experience on Duck Creek Insights product
• Strong Technical knowledge on SQL databases, MSBI
• Preferable having experience in Insurance domain
• Preferable experience in Duck Creek Data Insights
• Experience specific to Duck Creek would be an added advantage
• Strong knowledge of database structure systems and data mining
• Excellent organisational and analytical abilities
• Outstanding problem solver

• Hands on Work experience as a Python Developer
• Hands on Work experience in SQL/PLSQL 
• Expertise in at least one popular Python framework (like Django, Flask or Pyramid)
• Knowledge of object-relational mapping (ORM)
• Familiarity with front-end technologies (like JavaScript and HTML5)
• Willingness to learn & upgrade to Big data and cloud technologies like Pyspark Azure etc.
• Team spirit
• Good problem-solving skills
• Write effective, scalable code

Job Description:      

Min 2 to 4 Years of experience in C# and ASP.NET, Web application development.

Knowledge about cloud programming or migration to cloud is preferred.

 Mandatory skills:

• Proficient in Web Application development using ASP.NET, C# with .Net version 4.0/ 4.5.
• Experience with SQL Server or any other equivalent Database and know how to build efficient queries.
• Strong knowledge on jQuery, AJAX, JavaScript, HTML5, CSS3 and Bootstrap.
• Experience in debugging in multiple browsers.
• Strong understanding of object-oriented programming.
• Clear understanding of SVN or an equivalent VCS.
• Familiar with IIS and deploying code to Web Server.
• Should have excellent analytical and communication skills.

 Responsibilities:

• Good hands on designing, coding, debugging, technical problem solving, and writing Unit Test cases, etc.
• Translate use cases into functional applications
• Design, build, and maintain efficient, reusable, and reliable C# code
• Ensure the best possible performance, quality, and responsiveness of applications
• Help maintain code quality
• Able to work well in a team setting

 Academic Qualifications Required:

•  B.E. / B.Tech. /MSC in Computer Science or IT.

 Qualifications

M.C.A

B Tech

Required Candidate profile

Primary Duties

• Build a broad knowledge across various systems and processes via knowledge transfer and capture any missing information on the wiki

• Gather software requirements by talking to various stakeholders and document them

• Implement software solutions after discussing the requirements and taking direction from the Technical lead and talking to other colleagues within and outside the team

• Provide necessary effort and time estimates for tasks to aid scheduling and prioritization

• Provide necessary 3rd line support to the Operations teams including software fixes as needed

• Work on any BAU development activity including on-boarding new data sets and delivering new markets into the system

• Work with external vendors from time to time to gather necessary requirements for new data or changes to existing data specifications

• Maintain pro-active communication with relevant stakeholders and keep them updated on progress

General

• Any other duties commensurate with the post holder’s position and seniority; and
• All employees should understand that it is their personal responsibility to comply with all organisational, statutory and regulatory policies and procedures.

Experience, Knowledge & Skills

Essential

• 4+ years’ experience of programming in Java.
• 4+ years’ experience working with SQL including complex queries, stored procedures, views, database design and solid understanding of database concepts (preferably SQL Server)
• Experience of both Linux and Windows environments, scripting and tools
• Willing to carry out operational data tasks alongside developing new solutions
• Well organised with the ability to prioritise and manage multiple streams of work
• Excellent communication skills

Beneficial

• Experience working with Cloud environments (preferably AWS)
• Experience in handling financial data sets and familiarity with financial instruments (equities, futures, FX)
• Experience working with data pipelines and building ETL solutions
• Experience working with tools like Flink, Kafka and Tableau

Educational & Professional Qualifications

• Educated to degree (or equivalent) level or higher.
• A degree with mathematical and computing content (e.g. Computer Science, Maths, Physics)

• Strong experience working as a .Net developer.
• Proficient in Microsoft .NET development using C#. Experience with web development technologies including http://asp.net/">ASP.NET, MVC, EF, HTML, JavaScript, Angular, JQuery, AJAX, and CSS.
• Experience designing and developing enterprise-grade software.
• Experience with source control management systems and deployment environments.
• Experience with debugging, performance profiling and optimization.
• Comprehensive understanding of object-oriented and service-oriented application development techniques and theories.
• Internally motivated, able to work proficiently both independently and in a team environment.

• Experience in Web and Mobile Applications
• Agility and ability to adapt quickly to changing requirements and scope and priorities
• Experience in Java, Python.
• Deep understanding of data structures and microservices.
• Knowledge of Node.js
• Understanding the nature of asynchronous programming and its quirks and workarounds
• Familiarity with front-end technologies
• User authentication and authorization between multiple systems, servers, and environments
• Interaction with multiple data sources
• Good understanding of SQL
• Understanding fundamental design principles behind a scalable application
• Understanding differences between multiple delivery platforms, such as mobile vs. desktop, and optimizing output to match the specific platform.
• Implementing automated testing platforms and unit tests
• Proficient understanding of code versioning tools, such as Git .