SQL DB Dev Analyst

WHO YOU ARE

To be successful in this role, you’ll need to have the following skills:

·         Love for coding: A fanatic about writing beautiful and scalable code.

·         A sense of analytics: Strong analytical and troubleshooting skills. Should be resourceful, innovative and inventive.

·         Dynamic: Should be comfortable in dealing with lots of moving pieces. Have exquisite attention to detail, and are comfortable learning new technologies and systems. 

·         Team player: Knack for influencing without being authoritative. Pitch in wherever the team needs help, from writing blog posts to supporting customers.

·         Accountability: High sense of ownership for your code and relentlessness to deliver projects with high business impact. 

KEY QUALIFICATIONS

·         BE/BTech in Computer Science or related field. 

·         5+ years of professional production and development experience with leading-edge server and database technologies (e.g., Python, Java, Node.js, Scala, Spring Boot, MySQL, and NoSQL databases).

KEY SKILLS

·         Strong computer system analysis and design skills in current methodologies and patterns Experience with professional production cloud (AWS preferred).

·         Experience with RESTful Services and APIs.

Work Location: Bangalore

Job Type: Full-time

Experience Level: 5-10 years

Job Description:

We are looking for a talented Java Developer with a strong background in multithreading, microservices , Spring Boot, data structures and algorithms, and SQL, specifically within the banking sector. The ideal candidate will be responsible for designing and implementing high-performance applications that cater to our financial services.

Key Responsibilities:

• Develop and maintain robust, scalable Java applications using Spring Boot.
• Implement multithreading concepts to enhance application performance and responsiveness.
• Design and optimize data structures and algorithms for efficient data processing.
• Collaborate with business analysts and stakeholders to understand requirements and translate them into technical solutions.
• Write complex SQL queries and optimize database interactions to ensure high performance.
• Conduct code reviews and contribute to team best practices and standards.
• Troubleshoot and resolve issues in a timely manner, ensuring minimal impact on business operations.
• Stay updated with the latest trends in Java development and banking technology.

Required Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• Proven experience as a Java Developer, added advantage in the banking or financial services domain.
• Strong proficiency in Java, with a deep understanding of multithreading concepts.
• Hands-on experience with the Spring Boot framework and Microservices
• Solid understanding of data structures and algorithms and their application in solving complex problems.
• Proficient in SQL and experience with relational database management systems (e.g., Oracle, MySQL).
• Strong analytical and problem-solving skills, with the ability to work under pressure.
• Excellent communication skills and the ability to work

If interested, Kindly drop cv in linkedIn: linkedin.com/in/ranjini-c-n-36b674131

• 1-5 years of experience in Java Development.
• Very good with DSA - Java programming.
• Hands-on experience in working with REST APIs & Web Services.
• Good Database design skills - SQL
• Write well-designed, testable, efficient code.
• Contribute to all phases of the development lifecycle.

Work Location : Bangalore

Work mode : Work from office.

Experience - 2 to 6 Years

Work Location - Pune

Datametica is looking for talented SQL engineers who would get training & the opportunity to work on Cloud and Big Data Analytics.

Mandatory Skills:

• Strong in SQL development
• Hands-on at least one scripting language - preferably shell scripting
• Development experience in Data warehouse projects

Opportunities:

• Selected candidates will be provided learning opportunities on one or more of the following: Google Cloud, AWS, DevOps Tools, Big Data technologies like Hadoop, Pig, Hive, Spark, Sqoop, Flume, and KafkaWould get a chance to be part of the enterprise-grade implementation of Cloud and Big Data systems
• Will play an active role in setting up the Modern data platform based on Cloud and Big Data
• Would be part of teams with rich experience in various aspects of distributed systems and computing

Primary Role

• As an SSRS Report Engineer, the primary job role is to develop a transactional data report using Microsoft SQL Service Reporting Service 2016 or above.
• This includes developing high performing Stored Procedures, Functions, and corresponding reporting formats.
• Required to design the required logics for the queries and collaboratively coordinate with the rest of the team.

Main Duties / Responsibilities

• Design & implement high performing T-SQL queries as per the functional specification.
• Create Technical Specification.
• Effective troubleshooting of technical issues and bugs.
• Package deployment and release management.
• Provides technical support to customers.
• Participate in Requirements discussions.
• Must be able to manage timelines and task priorities.
• Attention to detail and maintaining high-quality standards is a must.

TECHNICAL KNOWLEDGE

• Experience in Microsoft SQL Server 2016 (or above) and Microsoft SQL Service Reporting Service 2016 (or above).
• Knowledge of T-SQL including complex SQL queries, stored procedures, views and functions.
• Experience with usage of indexes and T-SQL performance tuning techniques.

QUALIFICATIONS

• Bachelor’s Degree or an equivalent qualification

• As a polyglot developer Ideally, you should have:
• 1.5+ years of development experience using any of technology java, scala, python or any similar exciting technologies.
• Hands-on experience in coding, and implementation of complex, custom-built applications Working knowledge of build tool like maven/sbt and code versioning systems like git/bitbucket/cvs/svn
• Familiarity with few databases, like MySQL, Oracle, PostgreSQL, SQL Server, NoSQL etc Great OO skills, including strong design patterns knowledge
• Good communication and ability to work in a consulting environment is essential

• Think through hard problems in a consultancy environment, and work with amazing people to make the solutions a reality Work in a dynamic, collaborative, non-hierarchical environment where your talent is valued over your job title or years of experience
• Build custom software using the latest technologies and tools Craft your own career path

• Providing solution to real problems in Bigdata world.
• RnD on using the latest tools,techniques and cloud services.
• Automating the manual-timetaking tasks.
• Hands-on coding, usually in a pair programming environment.
• Working in highly collaborative teams and building quality code
• Working in lots of different domains and client environments
• Understanding the business domain deeply

 Review all job requirements and specifications required for deploying the solution into the production environment. 

 Perform various unit/tests as per the checklist on deployment steps with help of test cases and maintain documents for the same. 

 Work with Lead to resolve all issues within the required timeframe and inform for any delays. 

 Collaborate with the development team to review new programs for implementation activities and manage communication (if required) with different functions to resolve issues and assist implementation leads to manage production deployments. 

 Document all issues during the deployment phase and document all findings from logs/during actual deployment and share the analysis. 

 Review and maintain all technical and business documents.  Conduct and monitor software implementation lifecycle and assist/make appropriate customization to all software for clients as per the deployment/implementation guide 

 Train new members on product deployment, issues and identify all issues in processes and provide solutions for the same. 

 Ensure project tasks as appropriately updated in JIRA / ticket tool for in-progress/done and raise the issues. 

 Should take self-initiative to learn/understand the technologies i.e. Vertica SQL, Internal Data integration tool (Athena), Pulse Framework, Tableau. 

 Flexible to work during non-business hours in some exceptional cases (for a few days) required to meet the client time zones. 

Experience on Tools and Technologies preferred: 

ETL Tools: Talend or Informatica ,Abinitio,Datastage 

BI Tools: Tableau or Jaspersoft or Pentaho or Qlikview experience 

Database: Experience in Oracle or SS 

Methodology: Experience in SDLC and/or Agile Methodology