Tech Support Engineer - Fresher sql queries

Job Title:      Health Connect Integration Engineer -Lead

Experience:   12-15 Years

Location:      Bangalore, Chennai, Pune, Trivandrum

Work mode:   On-site

Primary Skills : Intersystem healthconnect/ healthshare/ Ensemble, IRIS, cache sql, cache object script, HL7

Roles and Responsibilities:

InterSystems Health connect Expertise:

• Extensive experience and expertise in Intersystems HealthConnect integration technologies, including in-depth knowledge of Health Connect integration engine, tools, and best practices.

• Hands on expertise in Intersystem healthconnect/ healthshare/ Ensemble, IRIS, cache sql, cache object script.

Leadership and Team Management:

• Strong leadership skills with a proven ability to lead and manage a team of integration engineers, providing guidance, mentorship, and creating a collaborative work environment.

Integration Strategy and Planning:

• The ability to develop integration strategies, roadmaps, and prioritise integration projects in alignment with organizational goals and healthcare industry requirements.

Healthcare Data Standards:

• In-depth knowledge of healthcare data standards, particularly HL7, and the ability to ensure compliance with these standards in integration solutions.

Project Leadership:

• Proven experience in leading integration projects from inception to completion, with a focus on meeting quality standards, timelines, and budgetary constraints.

Secondary Skills:

Technical Guidance:

• Providing technical guidance and support to resolve complex integration challenges, reviewing and approving integration designs, mappings, and transformations.

Quality Assurance:

• Ensuring the quality and adherence to industry standards and best practices in all integration projects, conducting integration reviews, and driving continuous improvement initiatives.

Stakeholder Communication:

• Effective communication skills to communicate progress, challenges, and project status to stakeholders and senior management, managing expectations, and providing regular updates.

Scalability and Performance Optimization:

• Collaborating with the team to optimize integration solutions for performance and scalability, implementing enhancements to accommodate growing data exchange requirement.

Pega Developer:

Total Yrs of Experience: 6 to 7

PEGA Experience: 6 years

Certification:

Must – CSSA or valid CLSA – part 1

Nice to have - CLSA

Job description:

Must

•            At least 6+ yrs experience in PEGA implementation

•            Hands on experience in OOAD, technical architecture definition

•            Working experience on database SQL programming , J2EE

•            Experience with BPM implementation methodology like SmartBPM, Scrum and onshore-offshore mode.

•            Experience with client facing management role at onsite/offshore

•            Experience with estimation

•            Experience with project planning, scheduling, risks/issues identification,

•            Experience in business development activities like proposal response, solution building, client presentation

•            Strong leadership and people management skill

Nice to Have

•            Knowledge on DSM, mobile Framework

•            Experience with App-server configurations, deployment in complex technical environment

•            PMP/Prince II certification

Job location-Hyderabad, Bengaluru, Mumbai, Pune and Goa

CTC – As per market standard
Notice Period-Max 15 -30 days joiners

Responsibilities:

• Work with Database Architect to understand the design considerations for the BI Next Gen Data Warehouse.
• Take accountability of the development / update of the DW Database Objects and Code as per the requirement.
• Take accountability of the development / update of the PowerBI and SSRS Reports.
• Take accountability of Unit Testing the developed solution.
• Be available for weekend job monitoring and troubleshooting, as necessary.
• Ensure that all delivery timelines are adhered to.
• Work with QA (Testing) team to test the DW / Report Solution and fix as necessary.

Job Requirements:

• 8 - 10 years of experience in SQL Server database development.
• Excellent understanding of SQL Server 2016 and above.
• Excellent understanding of T-SQL. Must have the ability to analyze, debug and write complex T-SQL code.
• Very good hand-on knowledge on query tuning and performance optimization.
• Excellent understanding of SQL Server Integration Services and SQL Server Reporting Services.
• Excellent understanding of PowerBI.
• Should be completely aware of coding standards and should be able to develop high performance & scalable database applications.
• Exceptional Problem Solving and Analytical Skills.

Excellent communication skills (oral and written).

ABOUT US. (https://www.ashnik.com/" target="_blank">https://www.ashnik.com/)

Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.

As a team culture, Ashnik is a family for its team members. Each member brings in different perspective, new ideas and diverse background. Yet we all together strive for one goal – to deliver best solutions to our customers using open source software. We passionately believe in the power of collaboration. Through an open platform of idea exchange, we create vibrant environment for growth and excellence.

THE POSITION

Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.

QUALIFICATION AND EXPERIENCE

• Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
• Experience of working in a production support environment
• Engineering or Equivalent degree
• Passion for open-source technologies is desired

ADDITIONAL SKILLS

• Install & Configure PostgreSQL, Enterprise DB
• Technical capabilities PostgreSQL 9.x, 10.x, 11.x
• Server tuning
• Troubleshooting of Database issues
• Linux Shell Scripting
• Install, Configure and maintain Fail Over mechanism
• Backup - Restoration, Point in time database recovery
• A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
• A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.

RESPONSIBILITIES

• Monitoring database performance
• Optimizing Queries and handle escalations
• Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
• Implement security features
• DR implementation and switch over

LOCATION: Pune 
Experience: 2 yrs plus

Job Description:

Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:

• Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.
• Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.
• Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).
• SQL Query tuning and performance tuning.
• Develop/migrate existing scripts to SSIS.
• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.
• Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.
• Importing and exporting the data from different sources using tools, writing required scripts.
• Works closely with other members of the team to accomplish the projects.
• Assists project teams to design and develop core business components utilizing  industry-accepted analysis and design standards.
• Provides and/or assists with, project management and project leadership.
• Create and maintain documentation for all the projects.
• Working with NOSQL databases (Mostly on MongoDB) .

PRIMARY SKILLS: 

TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.

SECONDARY SKILLS:

Database Administration

REQUIRED SKILLS:

• 3+ years of professional experience in working with MSSQL Server 2008 and above.
• 3+ years of professional experience in writing TSQL scripts.
• Thorough experience in SQL query tuning and performance tuning.
• Experience in developing and maintaining SSIS packages.
• Experience in working with NoSQL databases. MongoDB would be preferable.
• Fluent knowledge of MSSQL server DBA.
• Should be a good team player and should possess good attitude and work ethics.
• Should possess excellent communication and written skills.

PREFERRED SKILLS:

• MSSQL DBA.
• SSIS.
• NOSQL, MongoDB

Job Description

We are looking for .NET developers with following skill sets for building .NET applications.

Asp.Net with MVC 4.0+, Razor, Multi-threading, jQuery, Angular, SOAP API, Web API 2.0, DI Container, IOC, Bootstrap, Bootstrapper, HTML5, MS SQL

Primary responsibility will be to design and develop three layers of applications, and to coordinate with the rest of the team working on different layers of the infrastructure. A commitment to collaborative problem solving, sophisticated design, and quality product is essential.

Job Category            :  Software Engineer
Location                     : Delh

Experience                : 2 to 4 Years

Position Title: Senior Dot Net Developer

Key Responsibilities:

• Individual/ Team.
• Design, build, and maintain efficient, reusable, and reliable code
• Integrate data storage solutions
• Ensure the best possible performance, quality, and responsiveness of applications
• Identify bottlenecks and bugs, and devise solutions to mitigate and address these issues
• Help maintain code quality, organization, and automatization
• Timely submission of reports as necessary and achieving monthly goals is critical to this role.

Competencies:

Should possess sound communication and conflict management skills. 

Experience and Knowledge Requirements:

At least 2 years working experience with MS SQL, Asp.Net Web Form & windows services are mandatory.

Qualification:

MCA / B. Tech/ M.Sc. IT

Required Skillset:

• Strong knowledge of .NET framework
• Strong understanding of object-oriented programming
• Skill for writing reusable libraries
• Familiar with various design and architectural patterns
• Basic understanding of Common Language Runtime (CLR), its limitations, weaknesses, and workarounds
• Experience in generics collections. Client-side libraries like jQuery & Angular 1.3
• Proficient understanding of code versioning tools such as Git, SVN, and TFS
• Solid working experience on MVC, Singleton, abstract factory, facade design patterns

• Opportunity to work in a fast-paced environment aimed at creating a very high impact
• Exposure to different business functions in a fintech organization, helping each function to become successful with your work
• Opportunity to work with a diverse team of smart and hardworking professionals from various backgrounds
• Amazing work culture with endless opportunities for personal and professional growth Independence to put your thoughts/ideas into the executable business projects
• Ability to directly implement solutions and see them in action; critical partner for all decision-making in the organization
• Interact with people from various backgrounds
• A mix of Statisticians, Consultants, Business and Programmers
• Flat organization structure with open and direct culture
• Merit-based fast-growth environment - Market-leading compensation and benefit

Responsibilities

• As a Fraud Investigator, you'll lead multiple complex fraud investigations simultaneously in your area of responsibility and you'll write clear and concise reports for investigation findings and report outcomes to Avail finance's management. In addition, you are going to make this a success by conducting audit activities (prepare, execute, report) and customer screening in line with our Internal Audit procedures and Due Diligence Program.
• Identify risk trends in your area and translate them into learning and solutions, sharing best practices and facilitating the risk owner and business manager to make decisions.
• Actively anticipate trends and requirements and provide support for Avail finance's global anti-fraud procedures and standards for fraud identification and management of investigations to be the benchmark.
• Act as a representative Interact and engage with senior stakeholders in the Area.
• Participate in, provide input, and lead initiatives for the FICS Knowledge Practice.
• Able to translate Area and Global risk trends into proactive actions.
• Document findings and conclusions in line with the prescribed tools and methods.
• Responsible for the entire documentation and reporting of fraud/audit/customer screening in line with Signify Internal Audit procedures and systems
• Conduct customer screenings as part of the Due Diligence Program.
• Conduct compliance audit activities and contribute to fraud prevention within Avail Finance. - Work experience in NBFCs / Fraud Analytics in Banks / Fintech / Lending organizations in India would be a big plus

About You :

• You put the Customer First by identifying risk trends in your area of expertise and translate these into learnings and solutions.
• You are Greater Together by collaborating across teams to build on our strengths and diversity and work towards our shared goal.
• You are a Game Changer by innovating. Together we set ourselves apart and continue to lead in the market.
• You have a Passion for Results by working smarter and faster to deliver excellence