16 Sql Query Jobs

Role : Sr. Database Engineer Location : Pune Exp : 5-7 years Job Description : Oracle PLSql Developer The Associate shall perform the role of PLSQL Developer and shall be responsible for the following: • Hands on coding in SQL and PLSQL • Create/implement database architecture for new applications and enhancements to existing applications • Hands-on experience in Data Modeling, SSAS, Cubes, query Optimization • Create/implement strategies for partitioning, archiving and maturity models for applications. • Review queries created by other developers for adherence to standards and performance issues • PLSQL, TSQL, SQL Query Optimization, Data Models, Data lakes • Interact with Database, Applications analysts and Business users for estimations. • Do impact analysis of existing applications and suggest best ways of incorporating new requirements Proactively engage in the remediation of software issues related to code quality, security, and/or pattern/frameworks. Interested candidates can share their resume at Neesha1@damcogroup.com

Position Purpose Analyse business requirements and provide functional solutions for Forex applications. Supports a product owner by helping them analyze the business domain, stocking the product backlog, and grooming the product backlog. Analyze -business, production, security, and system requirements, study their impacts and contributes to estimation. Writes functional detailed specifications. Helps the team and product owner understand and describe problem to be solved by facilitating the discussions. Define policies and rules to guide business behavior and decision making. Write BDD test cases for each User Story. Perform UAT for all functional topics Responsibilities Direct Responsibilities Strong domain knowledge on Capital Markets with expert insights in Forex business with at least 3+ years of experience in this domain. Expert knowledge in Clearing, Custody & Settlement for more than one market. Ensures deliverables created as per Quality Management practices followed by the company, or as outlined for the project/release. Work with business analysts/users to understand requirements & help the IT team to develop good quality deliverables. Good hands-on experience on Agile practices acting ScrumMaster or Product owner role. Prepare BRD's based on the user needs & make sure document is detailed. Help the developer to reduce defects in IST/ UAT/production. Quality Focus is high. Identify risks and provide mitigation plan. Escalate issues on timely manner to the leads. Work Autonomously by taking ownership. Maintain very good working environment, Team spirit and Knowledge Sharing. To have a strong Customer Focus to provide a professional support service to both internal and external client. Gain application, business, and functional knowledge. Contributing Responsibilities Communicate ideas and develop strategy through presentations, demonstrations, specifications, supports and develops team members by sharingknowledge. Technical & Behavioral Competencies Experience 8 to 12 years Skills: Experience on Forex Domain Exposure to Capital Markets Functional knowledge. Exposure to Test Management tools & Functional Testing tools. Good communicator, fast learner & a Team player. Attention to detail, disciplined and reliable. Proactive, confident, and high motivation levels.- Business Analyst experience for 5 to 8 years.-SQL query knowledge Specific Qualifications (if required) Skills Referential Behavioural Skills(Please select up to 4 skills)Ability to collaborate / TeamworkDecision MakingCommunication skills - oral & writtenAdaptabilityTransversal Skills: (Please select up to 5 skills)Ability to develop and adapt a processAbility to manage / facilitate a meeting, seminar, committee, trainingAnalytical AbilityAbility to understand, explain and support changeChoose an item.Education Level:Bachelor Degree or equivalentExperience LevelAt least 5 years

Roles and Responsibilities: Interact with clients and internal functional people to understand domain requirements. Documentation- All the requirements are to be completely documented and explained to all the team members /client / stakeholders and are to be completed as per agreed template. Creation of Use Cases, User Stories, Business Requirement Document, Requirement Traceability Matrix, Functional requirement specification (FRS)/ Functional Specification Document (FSD), System requirement specification (SRS)/ System Requirement Document (SRD) etc. Creating Charts / Diagrams- As a part of documentation, certain aspects have to be expressed graphically for business related information. Diagrams such as Activity Diagrams, Use Case Diagrams, Data Flow Diagrams, Flow Charts etc. need to be part of it. Overall, as and when required the UML diagrams need to be part of the graphical representation. Provide functional inputs for Solution Design. Work closely with development teams to transfer the business knowledge and provide guidance. Desired Profile: Experience of at least 1 complete SDLC Should have a thorough understanding of trades and trade life cycle. Understanding of exchange traded instruments and their performance / risk measure is mandatory. Understanding of financial derivatives & Risk Measurement methodology (VaR) is a MUST Experience in Elicitation, analysis, and documentation of requirements (preferably for a risk management system) Excellent project documentation skills and good experience with project delivery and test governance process Advanced working knowledge of MS-Visio for different UML diagrams and MS-Office Suite like MS-Excel, Power Point. Willingness to dig into details and appetite, enthusiasm and desire to initiate change, and execute strategy. Excellent communication skills (oral and written) Prior experience in using CTRM software is preferred but not mandatory. Experience of working in an Agile environment (not mandatory) Preferable, but not mandatory, some programming experience / knowledge of statistical packages/ SQL querying experience/ Knowledge of ETL technologies. Able to build strong relationships with client and internal risk functions, business units Team player with good interpersonal and stakeholder management skills.

Windows Applications Development with Microsoft. NET Framework 4. Software development in Visual Studio 2010/2013& above, implementation of .net v4 framework or using PHP ver 5.x or skill set in Eclipse, Android SDK, Web service (SOAP, REST, JSON, XML) "Jquery App integration, App debugging, WCF, MVC. Should possess extensive knowledge of SQL query and Optimization Design, development, deployment and maintenance of ASP .net application, documenting process flow, ensuring best practices in development, Identify, prioritize, and execute tasks in the software development life cycle, develop tools and applications by producing clean, efficient code, Review and debug code etc. Candidates selected for NTRP and PRAKALP modules have to do development activities related to PGA Integration, CBEC Payment, Quick Payment, POS Payment, Additional Charges and Bi-Furcation, Publication cart, User Management for NTRP, Shopping Cart, Email Utility for sending email Candidates selected for Sanction module have to do development activities related ebill, budget control, API," Monthly account processing, Extra ordinary pension, COMPACT functionality and Pension arrears. Candidates selected for New Technology explorations have to do development work related to new technology implementation and PoCs. Role & responsibilities Preferred candidate profile Perks and benefits

Good experience required in Azure stack of integration technology-Logic app, Azure Function, APIM and Application insights. Technically sound in Dot Net technology. Good working knowledge & experience in Web API and SQL Server Should be able to carry out requirement analysis, design, coding unit testing and support to fix defects reported during QA, UAT phases and at GO Live times. Able to work alone or as part of a team with minimal or no supervision from Delivery leads. Strong Web API development using ASP.Net Core, Logic app, azure functions, APIM,Event Grid/Hub, KeyVault, Azure SQL Knowledge on SQL query

Expert at using D3.JS (java scripting based) visualizations and Tableau, to develop interactive dashboards. Comfortable with deploying and operationalizing dashboard to optimize for performance also at middle-ware layer

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting. Only Immediate Joiners.

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting. Only Immediate Joiners.

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting. Only Immediate Joiners.

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting.

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting.

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting.

About The Role WNS is hiring CAT Modeling professionals for a global reinsurance client acrossbelow mentioned skill-mix. Kindly refer to the job description mentioned against the desired skill-mix. 1.Portfolio Modeling (3+ years experience in end-to-end portfolio rollups) 2. Regulatory Reporting (4+ years experience in EDM/RDM/SCHEMA) 3. Model Validation (4+ years experience in Model Validation with tools like RMS/AIR) 4. Technical Solution (3+ years experience in SQL Query writing for CAT Modeling function) JOB DESCRIPTIONS: 1. Portfolio Modeling Good understanding Cat Modeling process and workflows Run vendor catastrophe modeling platforms (primarily RMS, AIR, Elements) for insureds and perform portfolio risk analyses. Working knowledge of RMS model scope across worldwide peril-regions regarding sub-perils, amplification, etc. along with basic understanding of cat-modelling four-box principle concerning exposure, hazard, vulnerability modules and translation of insurance and (re)insurance financial terms through coding in RMS and SQL. Assist clients in the understanding of catastrophe risk of individual insured through analytics based on catastrophe model results. Provide analytical support to catastrophe modeling team operations by sharing knowledge and information Develop processes and scripts for process improvements Provide timely and frequent feedback to team members. Preparing MIS reports Training and mentoring of team members inducted in the pricing process. Assisting in monthly post bind and portfolio rollup activities. Ensure all SLAs are met Communication with onshore SPOCs at regular intervals. 2. Regulatory Reporting Role and Responsibilities Good understanding Cat Modeling process and workflows. Run vendor catastrophe modeling platforms (primarily RMS, AIR, Elements) including accumulation analysis for reporting needs, whenever required Thorough knowledge of RMS EDM-RDM schema Ability to understand the requirements of regulatory submissions and further deliver them accordingly Understanding of RDS scenarios of Lloyds including Non-Modelled scenarios as well Working knowledge regulatory reports like LCM, RDS Scenarios, Terror Accumulations & reporting. Working knowledge of any other regulatory reports. Working knowledge of RMS model scope across worldwide peril-regions regarding sub-perils, amplification, etc. along with basic understanding of cat-modelling four-box principle concerning exposure, hazard, vulnerability modules and translation of insurance and (re)insurance financial terms. Provide analytical support to catastrophe modeling team operations by sharing knowledge and information Develop processes and scripts for process improvements Assisting in portfolio rollup activities. Ensure all SLAs are met Communication with onshore SPOCs at regular intervals. 3. Model Validation: : Perform model validation and provide recommendations on model use and/or required adjustments. Work with internal teams and external data providers on analysis, utilising available data including scientific information, claims and insured exposure Contribute to and lead Group projects as required, liaising with other teams globally. Produce customised reports on exposure and modelled results. Evaluate re/insurance pricing for individual accounts and product classes. Analyse catastrophe reinsurance structures and strategies to support reinsurance placements. Assist with the analysis of real time events and identify learnings from post-event reviews. Strong analytical and numerical ability, in order to interrogate large datasets Experience of working with re/insurance catastrophe data and/or catastrophe modelling software Excellent written and verbal communication skills, and the ability to explain technical concepts clearly Intermediate/Advanced Excel skills Pro-active attitude to identifying inefficient processes and developing improvementsDesirable Requirements Knowledge of commercial insurance and/or the catastrophe modelling industry Sound working knowledge of RMS/AIR and any other vendor modelling platforms Coding experience in a relevant language (e.g. SQL, VBA, R, C#) Experience in using mapping software (e.g. GIS) 4. Technical Solution (SQL query): Catastrophe Modelling Analyst in the Accumulation Management department, working with the Technical Solutions team The Technical Solutions team is focused on developing customized in-house tools and databases for the Accumulation Management team, to streamline processes and organize data in an efficient manner Technical role with large potential for growth in responsibilities Develop an understanding of existing Catastrophe Modelling processes, licensed software, and the various in-house tools used to automate processes Maintain existing Accumulation Management tools. Debug errors in the code when users experience issues Assist users with technical questions. Explain how tools work and deliver training sessions when required Test new functionality prior to launch to ensure that tools are working as intended Support team to design and develop new tools to automate processes. Update user guides when needed Work with colleagues around the globe on ad-hoc projects Qualifications Bachelors Degree in Mathematics/ Applied Mathematics/ Statistics/ Operations Research/ Actuarial Science Job Location Cookies Settings

Hi all, We are hiring for the role Azure Data Factory Experience : 7 - 9 Years Location: Bangalore Notice Period: Immediate Joiners only Skills: Design, develop, and maintain data pipelines using Azure Data Factory 2. Create and manage data models in PostgreSQL, ensuring efficient data storage and retrieval. 3. Optimize query performance and database performance in PostgreSQL, including indexing, query tuning, and performance monitoring. 4. Strong knowledge on data modeling and mapping from various sources to data model. 5. Develop and maintain logging mechanisms in Azure Data Factory to monitor and troubleshoot data pipelines. 6. Strong knowledge on Key Vault, Azure Data lake, PostgreSQL 7. Manage file handling within Azure Data Factory, including reading, writing, and transforming data from various file formats. 8. Strong SQL query skills with the ability to handle multiple scenarios and optimize query performance. 9. Excellent problem-solving skills and ability to handle complex data scenarios. 10. Collaborate with Business stakeholder, data architects and PO's to understand and meet their data requirements. 11. Ensure data quality and integrity through validation and quality checks. 12. Having Power BI knowledge, creating and configuring semantic models & reports would be preferred. If you are interested drop your resume at lakshmi.k@acesoftlabs.com .

We have an urgent opening for IT Engineer SAGE Software position with our esteemed client manufacturing automobile parts MNC at Pune - Khed location. experience on SAGE Software (ERP) is MUST Experience - 5+ Years Education - BE Computer Science Interested candidates mail your updated resume at unihr02@gmail.com Job Description - 5+ years of experience in Sage X3 ERP (support or implementation Projects). A consulting background with a record of delivering complex software solutions within defined timeframes and budgets. Strong business expertise, a keen understanding of business needs, and ability to ensure technical solutions. Experience in translating business requirements into solution specifications in Sage X3. Ability to effectively document business and technical designs. Ability to effectively prioritize and execute tasks in a high-pressure environment. Support, manage and maintain the organizations ERP and provide correct solution to end-users. Work closely with business stakeholders to define best practice standard operating procedures for all functional aspects of the business that are supported by the ERP and other open-source technology tools. Work closely with end users of sage, understand their requirements and execute the solution through successful development, testing, and training. Gather requirements and train users to effectively use the application Prepare user guides and manuals and required application related documentations. Demonstrate a strong technical platitude and understand both business and technical language and ideas. Excellent written and verbal communication skills, as well as organizational skills. Ability to collaborate and communicate effectively across the organization A creative self-starter, team player with the ability to multi-task and focus. Good problem-solving skills to move toward a projects successful completion. Knowledge of Warehouse Management System would be added advantage. Functional knowledge of Sales, Purchase, Manufacturing, Finance & Inventory module. Should understand 4GL Language of Sage X3. Must have experience in Crystal Report development & SQL Query tool. Should have experience in Table, Screen, Window, Object, Function creation. Experience in creating Sage Users & Assigning Roles to them. knowledge of SOAP Webservices would be added advantage. Technical Synopsis: Data base creation in SQL Server 2012. Creation & Customization of Data Types, Tables, Screens, objects, windows, Functions, views. Patch creations, patch integrations. Local Menus, Miscellaneous tables, inquires and requestors creations. Report generations, setting up workflows, Importing and Exporting data. Batch-process execution Creation of Dashboard for full business object lifecycle. Knowledge of SQL Query. Create reports using Business Objects and configure into Sage ERP X3 Creation of Subprograms, Web-Services & testing into Classic Soap Web service. Crystal Report Knowledge: Designing and developing Crystal and Business Intelligence reports for Sales, Purchase and financial data. Modify existing reports and develop new reports by analyzing databases, data sources, and structures. Ability to re-design or customizing the existing Views and Stored Procedures to suit the reporting needs. Create Report templates, Summary Reports, Master/Detail Reports and Parameterized Reports. Create Joins, Contexts and Aliases for resolving Loops and Universe Tuning. Design reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections. Experience in report customization via the use of Grouping, Sorting, Field Highlighting, Conditional Formatting, Running Totals, Summaries, Static & Dynamic Parameters, Static & Dynamic Graphic Objects, Custom Formulas and Custom Functions (SQL Queries). Functional Synopsis: Creation of Users. Product categories, products, product sites. Assigning products to product categories and in turn assign the products to product sites. Creation of Purchase request, purchase orders, shipment request, receipt and Purchase Invoice. Creation of Quote, Sales Order, Sales Delivery, Sales Invoice. Positive attitude is a must Knowledge of WMS (Added advantage).

SQL Query, SQL server, SQL . ETL