11 Sql Knowledge Jobs

Job Title: Logistics Specialist. The Logistics Analyst is responsible for . About the job (Job Responsibilities). Work closely with the internal stakeholders (viz Supply Chain, Sales, Planning, Customer Service etc) to translate the objectives into parameters for analytical models (Power BI) and reports/dashboards for global and cross-functional use.. Develop and maintain data and analytical models, including data logic and statistical analysis on business performance (incl. KPI’s) across the businesses and functions in an automated way.. Maintain, Monitor, and ensure data quality of the certified / centralized PBI reports.. Provide meaningful insights, which can be used to better understand and improve business performance.. Actively working on standardization and improvements of the certified reporting, dashboarding (Power BI) and related metrics.. Fulfill the information needs across the functions.. Design, develop, test, implement and maintain data models to derive relevant answers from datasets, which may include identification of attributes, exploratory data analysis and predictive analytics.. Supporting role to end users on PBI related questions (e.g. training, problem solving, etc).. Identify new data sources and evaluate emerging technologies for data discovery and analytics.. Cross-Domain Exposure: Gain the opportunity to work across diverse domains such as Supply Chain, Commercial, and Finance, enhancing your understanding of various data landscapes.. Innovation and Implementation: We encourage you to share your ideas and implement solutions using advanced tools and technologies such as Python, Machine Learning (ML), and Natural Language Processing (NLP). Help take Power BI capabilities to the next level.. Improve the full PBI landscape where possible: Fabric, Tenant maintenance, Power Platform utilization, Analytics, CoPilot, PPT integration etc.. [Not translated in selected language]. The position is based in Mumbai, India.. We believe you bring. The role is predominantly concentrated on Supply Chain Management, and the employee must possess experience and knowledge of. Supply Chain Planning. Logistics, Warehouse, Inventory, Freight. Export / Import etc.. Have a bachelor’s or master’s degree in supply chain management, Business Administration or a related field.. Have minimum 3 years of experience with Power BI modelling and reports design.. Strong and applied knowledge on DAX and HANA / Azure/ SQL integration.. Preferably worked with data from SAP and/or BW.. Have strong analytical skills, with proven capabilities in data modelling and data visualization.. Strong knowledge of supply chain processes and relevant legal regulations.. Have relevant experience in the fields of Integrated Supply Chain reporting – Logistics, Planning, Order Management, Customer Service etc. Able to come up with solutions to define business problems by leveraging pattern detection over large datasets and overseeing relationships between diverse systems.. A team player and able to communicate across different businesses, functions, and organizational levels.. Preferably have statistical modelling and machine learning expertise or have interest in data science.. Show more Show less

Liaise with internal teams (e.g., developers, delivery teams, solution and business analysts, and product managers) to identify testing scope Review requirements, specifications, and technical design documents to design test cases Create detailed, comprehensive, and well-structured automated test cases in GHERKIN or relevant Format aligned to QF methodologies Create end-to-end AT creation leveraging C# coding. Work closely with site reliability engineering team to investigate and fix failed automated tests. Requirements : Proficiency in programming (C# or Java preferred) Fundamental SQL knowledge and strong QA methodologies BS/MS in STEM, with 2-3 years of relevant experience Banking/financial domain knowledge is a bonus Clear communicator, proactive, and responsible Fluent in English

Project Role : Application Lead Project Role Description : Lead the effort to design, build and configure applications, acting as the primary point of contact. Must have skills : Palantir Foundry Good to have skills : NAMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Project Role :Lead Data Engineer Project Role Description :Design, build and enhance applications to meet business process and requirements in Palantir foundry.Work experience :Minimum 6 years Must have Skills :Palantir Foundry , PySpark, TypeScript (for customizing Workshop Forms & UI)Good to Have Skills :Experience in Pyspark, python and SQLKnowledge on Big Data tools & TechnologiesOrganizational and project management experience.Job & Key Responsibilities :Responsible for designing , developing, testing, and supporting data pipelines and applications on Palantir foundry.Configure and customize Workshop to design and implement workflows and ontologies.Configure and customize Workshop applications, including designing Forms, Workflows, and Ontology-based interactions.Write TypeScript to create dynamic and interactive Forms in Workshop for user-driven data entry and validation.Collaborate with data engineers and stakeholders to ensure successful deployment and operation of Palantir foundry applications.Work with stakeholders including the product owner, data, and design teams to assist with data-related technical issues and understand the requirements and design the data pipeline.Work independently, troubleshoot issues and optimize performance.Communicate design processes, ideas, and solutions clearly and effectively to team and client. Assist junior team members in improving efficiency and productivity. Technical Experience :Proficiency in PySpark, Python and Sql with demonstrable ability to write & optimize SQL and spark jobs.Hands on experience on Palantir foundry related services like Data Connection, Code repository, Contour , Data lineage & Health checks.Good to have working experience with workshop , ontology , slate.Hands-on experience in data engineering and building data pipelines (Code/No Code) for ELT/ETL data migration, data refinement and data quality checks on Palantir Foundry.Experience in TypeScript to create and customize Forms in Workshop, including form validation, user interactions, and data binding with Ontology.Experience in ingesting data from different external source systems using data connections and sync.Good Knowledge on Spark Architecture and hands on experience on performance tuning & code optimization.Proficient in managing both structured and unstructured data, with expertise in handling various file formats such as CSV, JSON, Parquet, and ORC.Experience in developing and managing scalable architecture & managing large data sets.Good understanding of data loading mechanism and adeptly implement strategies for capturing CDC.Nice to have test driven development and CI/CD workflows.Experience in version control software such as Git and working with major hosting services (e. g. Azure DevOps, GitHub, Bitbucket, Gitlab).Implementing code best practices involves adhering to guidelines that enhance code readability, maintainability, and overall quality. Educational Qualification:15 years of full-term education Qualification 15 years full time education

Hiring - MIS Executive Location - Borivali, Mumbai #Male Candidates - 7:00pm to 4:00am (Night Shift) #Female Candidates - 12:30pm to 9:30pm #5 Days Working (Saturday & Sunday off) Job Profile: The MIS Executive is responsible for overseeing the implementation, management, and maintenance of information systems within the organization. This role involves data analysis, report generation, system management, and ensuring the efficient flow of information across various departments. The MIS Executive collaborates with cross-functional teams to ensure that the systems meet the business's operational needs, and that data is accurate and accessible. Desired Skills: Strong analytical and problem-solving skills. Proficiency in database management, SQL, and data visualization tools. Good communication and interpersonal skills. Ability to work collaboratively in a team-oriented environment #Interested applicants share CV to meghna.patil@kgkmail.com

Job Title: Manual QA Tester Location: Bangalore Job Type: Full-Time Experience Level: 25 years Reports To: QA Lead / QA Manager About the Role: We are looking for a detail-oriented and proactive Manual QA Tester to join our growing team. In this role, you will be responsible for ensuring the quality and stability of our SaaS platform through comprehensive manual testing, issue tracking using Jira, and data validation using SQL. You will work closely with developers, product managers, and support teams to maintain a high-quality user experience. Key Responsibilities: Design, develop, and execute detailed test cases based on functional and technical requirements. Perform functional, regression, smoke, exploratory, and integration testing. Log, track, and manage bugs in Jira , ensuring clear documentation and effective communication with development teams. Perform SQL queries to validate data integrity and ensure back-end processes are working as expected. Collaborate with cross-functional teams during the SDLC to ensure product quality. Participate in test planning, estimation, and review sessions. Contribute to QA process improvement initiatives and share testing best practices. Required Skills and Qualifications: 2+ years of experience in manual testing of web-based applications, ideally SaaS platforms. Strong experience with Jira for bug tracking and agile workflow management. Good understanding of SQL and ability to write medium-complex queries for data verification. Familiarity with testing in an Agile/Scrum environment. Ability to document and troubleshoot errors clearly and effectively. Strong analytical and problem-solving skills. Excellent verbal and written communication skills. Attention to detail and a passion for delivering high-quality software. Nice to Have: Basic understanding of APIs and experience using tools like Postman . Exposure to test management tools such as TestRail , Zephyr , or Qase . Knowledge of automation basics or willingness to learn. What We Offer: Competitive salary and benefits Flexible working hours and remote work options Opportunity to work on a cutting-edge SaaS product with a collaborative team Career growth and learning opportunities in a supportive environment

Join us as a Full Stack Developer at Barclays, where you'll spearhead the evolution of our digital landscape, driving innovation and excellence You'll harness cutting-edge technology to revolutionize our digital offerings, ensuring unparalleled customer experiences, To be successful as a Full Stack Developer you should have experience with: Programming Core Java, Collections, Multi-Threading and Concurrency, OOPS concepts, Exception Handling, JVM Concepts, Spring Framework (Spring Boot, Spring Batch, Spring Integration), SQL Integration Micro Service Architecture, Developing and integration with Restful web services, Design Patterns UI/UX Angular, React, HTML/CSS/JS Some Other Highly Valued Skills Includes Devops Monitoring and tooling like ELK and App Dynamics, Build and Deployment tools, Docker, Kubernetes, Load Balancer principles, Experience working on highly scalable applications Database and Messaging SQL (Joins Indexing Transaction), No SQL( Mongo, Cassandra, CAP Theorem etc ), SQL Queries, Query Optimizations etc Caching Framework Concepts, Types of Caching, Principles of caching Priming, Eviction, Cache Miss, Consistency staleness, MRU etc; Messaging Kafka, Solace You may be assessed on key critical skills relevant for success in role, such as risk and controls, change and transformation, business acumen, strategic thinking and digital and technology, as well as job-specific technical skills, The role is based out of Pune, Purpose of the role To design, develop and improve software, utilising various engineering methodologies, that provides business, platform, and technology capabilities for our customers and colleagues, Accountabilities Development and delivery of high-quality software solutions by using industry aligned programming languages, frameworks, and tools Ensuring that code is scalable, maintainable, and optimized for performance, Cross-functional collaboration with product managers, designers, and other engineers to define software requirements, devise solution strategies, and ensure seamless integration and alignment with business objectives, Collaboration with peers, participate in code reviews, and promote a culture of code quality and knowledge sharing, Stay informed of industry technology trends and innovations and actively contribute to the organizations technology communities to foster a culture of technical excellence and growth, Adherence to secure coding practices to mitigate vulnerabilities, protect sensitive data, and ensure secure software solutions, Implementation of effective unit testing practices to ensure proper code design, readability, and reliability, Assistant Vice President Expectations To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness Collaborate closely with other functions/ business divisions, Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard The four LEAD behaviours are: L Listen and be authentic, E Energise and inspire, A Align across the enterprise, D Develop others, OR for an individual contributor, they will lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments They will identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes, Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues, Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda, Take ownership for managing risk and strengthening controls in relation to the work done, Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function, Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy, Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc) to solve problems creatively and effectively, Communicate complex information 'Complex' information could include sensitive information or information that is difficult to communicate because of its content or its audience, Influence or convince stakeholders to achieve outcomes, All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship our moral compass, helping us do what we believe is right They will also be expected to demonstrate the Barclays Mindset to Empower, Challenge and Drive the operating manual for how we behave,

About The Role Support and Maintenance of customers Adobe Campaign Classic platform Responsible for handling tickets in Production environment Perform RCA on recurring issue and provide permanent fixes Monitoring of the workflow and taking corrective actions Coordination of system-related activities between user and multiple technical teams Responsible for the upkeep and maintenance of Adobe Campaign application servers and coordination with DBA's Understanding integration of Adobe with other applications. Primary Skills 4 to 5 years of support and development experience with Adobe Campaign Classic (Neolane) Experience in working with different Adobe Campaign modules, like; Message Centre, Content Manager, FDA, etc. knowledge and experience with the following programming languagesHTML, XML, JavaScript and SQL Knowledge and experience of integrating Adobe Campaign with other system Basic knowledge on SQL and Unix Good communication and interpersonal skill and willing to travel if required as this roles involves directly working with end customer. Secondary Skilla Good to have Certification

Role & responsibilities: Data Analysis and Reporting: Analyzing business data to identify trends, patterns, and anomalies. Developing and maintaining reports and dashboards to provide insights into business performance. Presenting data in a clear and concise manner to support decision-making. System Management and Support: Managing and updating databases to ensure data integrity and accessibility. Troubleshooting data discrepancies and system issues. Providing technical support to end-users and resolving system problems. Process Improvement and Optimization: Identifying areas for process improvement and implementing solutions to enhance efficiency. Participating in business analysis activities to gather reporting and dashboard requirements. Translating business requirements into technical specifications. Collaboration and Communication: Collaborating with Cross functional Team and other departments to ensure data systems are effective. Communicating findings and recommendations to stakeholders. Data Quality and Security: Ensuring the accuracy and reliability of data used in reports and dashboards. Implementing security measures to protect sensitive data. Additional Skills and Qualifications: Analytical and Problem-Solving Skills: Ability to analyze data, identify trends, and develop solutions. Technical Skills: Proficiency in database management, reporting tools, and data visualization software. Communication Skills: Ability to communicate findings and recommendations clearly and effectively. Business Acumen: Understanding of business processes and operations. Preferred candidate profile: Specify required role expertise, previous job experience, or relevant certifications.

About The Role Java/Oracle profile X 4 Positions: Position Overview You will upgrade to Java 11 MSCI Data Management backend applications; this will require the upgrade of their current tech stack (mainly Spring). You will afterwards help with their migration to Azure Cloud. This will include the rewiring of Spring setup to Azure App Config and Key vault and the refactoring of services, so they run in a Kubernetes cluster. Responsibilities: Upgrade the Data management backend applications to Java 11 Update their tech stack Adapt their connectivity to Azure Cloud (App Configs, Keyvault) Validate the applications in their new Cloud environment. Desired Experience and Skills: Rock-solid core Java skills Good knowledge of SpringBoot + Spring JDBC Relational database experience preferably on Oracle, PL/SQL knowledge will be an advantage Pragmatic, keep it simple mentality Experience with Kubernetes is a plus Experience with cloud infrastructure (AWS or Azure) is also a plus No fuss attitude towards legacy application code

About The Role Position Overview You will update clients business applications implemented using the Google Web Toolkit, this will require the migration from GWT 1.7 to GWT 2.9.0 and from Sencha GXT 2.0.1 to 4.1.0 as well as the refactoring of custom components defined by MSCI. You will afterwards perform the migration to Azure Cloud of those GWT applications. Responsibilities: Upgrade the Data management GWT/GXT frontend applications to Java 11 Port them to Azure Cloud Take part inf applications testing Desired Experience and Skills: Rock-solid core Java skills At least 2 years of experience both with Google Web Toolkit and Sencha GXT Good knowledge of Spring JDBC + Spring beans Relational database experience preferably on Oracle, PL/SQL knowledge will be an advantage Pragmatic, keep it simple mentality Excellent time-management skills, ability to setup and follow through on a schedule, and work in a self-contained way No fuss attitude towards legacy application code

About The Role The candidate must possess in-depth functional knowledge of the process area and apply it to operational scenarios to provide effective solutions. He/she must be able to identify discrepancies and propose optimal solutions by using a logical, systematic, and sequential methodology. It is vital to be open-minded towards inputs and views from team members and to effectively lead, control, and motivate groups towards company objects. Additionally, he/she must be self-directed, proactive, and seize every opportunity to meet internal and external customer needs and achieve customer satisfaction by effectively auditing processes, implementing best practices and process improvements, and utilizing the frameworks and tools available. Goals and thoughts must be clearly and concisely articulated and conveyed, verbally and in writing, to clients, colleagues, subordinates, and supervisors. Process Manager Role and responsibilities: Understand the business model on why things are the way they are, ask relevant questions and get them clarified Breakdown complex problems in small solvable components, to be able to identify problem areas in each component Conduct cost/benefit analysis and feasibility studies for proposed projects to aid in decision-making Facilitate the implementation of new or improved business processes and systems Coordinate with business stakeholders to identify gaps in data, processes and suggest process improvements Understand and follow the project roadmap, plan data availability and coordinate with the execution team to ensure a successful execution of projects Prescribe suitable solutions with an understanding in limitations of toolsets and available data Fetch and analyze data from disparate sources and drive meaningful insights Provide recommendations on the business rules for effective campaign targeting Interpret analytical results and provide insights; present key findings and recommended next steps to clients Develop tangible analytical projects; communicate project details to clients and internal delivery team via written documents and presentations, in forms of specifications, diagrams, and data/process models Audit deliverables ensuring accuracy by critically examining the data and reports against requirements Collaborate on regional/global analytic initiatives and localize inputs for country campaign practices Actively work on audience targeting insights, optimize campaigns and improve comm governance Technical and Functional Skills: B Tech / BE / BSc / MBA degree or equivalent professionalDegreewith 10+ years of experience in marketing analytics or performance marketing professional experience in advanced analytics for a Fortune 500-scale company or a prominent consulting organization Reporting - Data Extraction tools, Advanced Excel, CRM Analytics, Campaign Performance Marketing, Analytics knowledge- Campaign Analytics Strong in numerical and analytical skills. Strong in Advanced Excel (prior experience with Google sheets is an added plus) 10 years of relevant experience in analytical and storytelling skills; ability to derive relevant insights from large reports and piles of disparate data Very Strong in SQL execution Advanced knowledge in using Power Bi reporting tool Experience in marketing analytics or performance marketing, concepts around campaign operations shall be clear like how does a paid media marketing works, campaigns acquisition, reactivations, cross-selling, brand awareness, measure and optimize the campaigns etc., Comfortable working autonomously with broad guidelines Passion for data andanalytics for marketing and eagerness to learn Excellent communications skills, both written and spoken; ability to explain complex technical concepts in plain English Ability to manage multiple priorities and projects, aligning teams to project timelines and ensuring quality of deliverables Work with business teams to identify business use cases and develop solutions to meet these needs using analytical approaches Manage regular reporting and ad-hoc data extract from other departments. Knowledge on analyzing digital campaigns and the tools/technologies of performance marketing Experience with Google sheet/Excel Hands-on experience in digital marketing and/or 1:1 marketing in any channel; expert level knowledge in campaign performance marketing and CRM MMM, A/B testing, attribution modeling is a plus Working knowledge of analytical/statistical techniques Experience in Hadoop environment- Hive, Presto is a plus Experience in Python/R