BI Backend Developer

Job Profile

Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.

Main Responsibilities:

• To work on existing and future applications as required
• Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
• Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
• Report status to management on project progress
• Identify and escalate related issues and risks
• Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies 
• Assess current modules and offer performance improvements techniques  
• Make sure Database Design Standards/coding standards established by ABD are followed
• Constant communication with ABD leadership team in US.
• Problem Solving ability with “Can-do” attitude
• IT experience in Banking industry is preferred

Candidate Profile:

• Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
• Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
• Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
• Experienced in MS Excel VBA and macro scripting
• Knowledge of data Encryption in database

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

Job Description:  

As a L3 analyst, you will play a key role within the Application Management team, leading services for its customer(s). This service has responsibility for the smooth daily operational running of the Client platform both in the cloud and on-premises. The Client application is business critical and centrally manages data for trading, settlement, risk, client and regulatory reporting systems. As a L3 analyst, you will be responsible for supporting complex infrastructure and application issues raised by L1/L2 support teams, and business analysts. You would also be working on client requests for enhancements, fixes, maintaining custom code, and following the best practices such as Agile, DevOps, etc.

The role is a technical role requiring a good technical knowledge of SQL/PLSQ, Core Java along with good debugging skill while supporting client implementations. You should have basic understanding on Unix system and commands. The ability to troubleshoot issues, assist users and help write specifications is essential. This position also works with product management to improve the software engineering processes and practices associated with continuously building, deploying, and updating software and environments.

• Accountability and primary responsibility/duties:
• A typical day would look like as follows: -
  • 40% support issues.
  • 40% configuration/development work.
  • 20% continuous improvement, automation, CICD, so on.
• Activities would range across the lifecycle from discovery to post-implementation support.
• Understanding client’s requirement, replicate the problem and providing the solution
• Understanding and developing new requirements coming in from BAs (Business Analysts) and customers.
• Update the existing functionality based on client needs.
• Develop changes that cater to enhancing the product and/or fixing production issues
• Prepare product releases of software components. (Java/SQL-PLSQL)
• Contribute in all phases of the development cycle. (development/Deployment/Testing, peer review)
• Create technical document for all changes made.

Required Qualifications/Knowledge/Skills

• Bachelor’s degree in Computer Science or related field
• Strong basics and working experience in following technologies: -
  • Core Java.
  • SQL / PLSQL coding.
  • Object Oriented Programming concepts and data structures.
• Working knowledge on Unix platform
• Working knowledge on XSLT and XML handling
• Basic understanding App & web server working knowledge (JBOSS, WebLogic and WebSphere) and debugging skills.
• Advantageous to have:
  • Working understanding on CICD, Dev-ops technologies.
  • Queuing technologies including Kafka, MQ, Solace.
  • Scripting including Python, Unix, java.
• Hands on knowledge of Dev ops processes and tools Good interpersonal and communication skills.
  
  

About Sportz Interactive

Sportz Interactive (SI) works with its clients and partners to revolutionize the sports fan experience across consumption points by creating best-in-class, kickass products. SI was founded in 2002 as a B2B sports content business. Through the years, it gained immense reputation for its state-of-the-art hosted solutions, digital simulators, match centers and fantasy games. Sportz Interactive has a fantastic reputation in the online sports community, having worked with clients across the globe including the likes of The International Cricket Council, STAR Sports, Yahoo!, AOL, Eurosport, Castrol, Web 18, NDTV, Nimbus, Times of India, Rediff.com and Singtel amongst others. 

Sportz Interactive provides in-depth sports information and content and specializes in product development for the web, mobile and other interactive platforms. 
http://www.sportzinteractive.net/">www.sportzinteractive.net 

Designation: Senior Associate 

Office Location: Goregaon East, Mumbai

Position description:

3+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills.

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

As a Software Engineer at Quince, you'll be responsible for designing and building scalable infrastructure and build applications to solve some very interesting problems in the logistics and finance tech space.

Responsibilities:

• Design and architect solutions on the cloud for various business problems with workflow efficiency and scale in mind.
• Be on the forefront with the business team to learn, understand, identify and translate function requirements into technical opportunities.
• End-to-end ownership - from scoping the requirements to the final delivery of the solution with keen eye to details and quality.
• Build and improve logistics components for this innovative M2C supply-chain model.
• Build and maintain scalable ETL data pipelines.

Requirements:

• Bachelors/Masters/PhD in Computer Science or closely related subject.
• 1-5 years of experience in building software solutions.
• Good at data structures and their practical applications.
• Proficiency in Kotlin, Java, Python.
• Experience in deploying and maintaining applications on cloud platforms (Ex: AWS, Google cloud).
• Proficiency with SQL and databases - relational and/or nosql (Snowflakes, AWS RedShift, etc).
• Experience with messaging middleware such as Kafka is good to have.

• 7 years of hands-on experience on database development
• Very strong and hands-on in Oracle Database and PL/SQL development
• Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
• Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
• Working experience in development of ETL process, DB Design and Data Structures
• Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
  Excellent written and verbal communication skills

• Hands on Java experience with minimum 8 yrs. More experience is a plus but need to be hands on.
• Server side programming experience with technologies: Spring, Hibernate & Swing is a plus
• Good DB knowledge, hands on PL/SQL or T-SQL
• Experienced to work on Linux, git, IntelliJ, Eclipse
• Experience of designing and developing end-to-end solutions.

Job Role – SDE2

Duration – 12 months

Location – HYD

Key Skills:

• 3- 5 years
• Understanding databases and building reports
• Ideal candidate should have experience in Cosmos, Kusto and powerbi
• Mandatory experience in some Database query language(such as SQL)