2) Expertise in developing OLAP cubes and developing complex calculations, Aggregations, implementing a dynamic security model using MDX/ DAX functions in - Azure Analysis service- or (SSAS)
3) Extensively used performance monitor/SQL profiler/DMVs to solve deadlocks, to monitor long-running queries and trouble-shoot cubes SQL and T-SQL. Roles & Responsibilities : 1) "SSAS" OR "Azure Analysis services" Lead Developer with 7+ years of experience in SSAS Azure Data Model Development, SSAS Data model Deployment in Azure, Querying data from SSAS Azure to build Reports.
2) Design and Create SSAS/OLAP/OLTP/Tabular cubes and automate processes for analytical needs.
3) Writing optimized SQL queries for integration with other applications, Maintain data quality and overseeing database security, Partitions and Index.
About MNC
Similar jobs
Proven work experience as a Database Programmer, Database Developer, or similar role.
Strong proficiency in SQL and hands-on experience with PostgreSQL.
Solid understanding of relational database concepts and principles.
Experience in database design, schema modeling, and optimization.
Familiarity with database administration tasks, such as user management, backup and recovery, and performance tuning.
Ability to write efficient SQL queries, stored procedures, and functions.
Detail-oriented with a focus on data accuracy and integrity.
Familiarity with software development methodologies and programming languages is a plus.
Title: Technical Analyst - OTM
Experience: 3-9 Years
Work Location: Mohali
Shift Timing: Rotational Shift 24x5
Notice Period: Immediate to 30 days Max
Key Skills: OTM, OBIEE, BI Publisher, Oracle ERP
Job Description:
The Oracle Transportation Management Technical Analyst will share the responsibility for design, implementation, and support of business solutions based on Emerson’s instance of Oracle Transportation Management commonly referred to as SCO (Supply Chain Optimization). The Technical Analyst utilizes expertise in Oracle Transportation Management to provide assistance in the ongoing implementation, enhancement, and support of SCO functionality.
Roles and Responsibilities:
- Provide support (e.g., break/fix, how to expertise, enhancements, monitoring, testing, troubleshooting) for the SCO application.
- Works collaboratively with Corporate Logistics and SCO IT Program/Project Managers to understand program requirements and assist with the evaluation of alternative solutions.
- Assist with program rollout activities, including business unit and trading partner on-boarding, project coordination, status reporting and communication to program management.
- Proactively monitors processes to identify trends; analyses/predicts trends and develops a long-range plan designed to resolve problems and prevent them from recurring to ensure high service levels.
- Ensures SCO system documentation is complete and maintained.
- Works effectively in a global highly matrixed team environment.
Skills & Experience Required:
- 4 to 8 years of IT experience, including implementation of Oracle Transportation Management.
- OTM Expert, both Functionally and technically (Setup configuration, Order Management, Shipment management, Financials, rates, master data, bulk planning parameters, VPDs, user configuration, screen set development, SQL queries, Tracking Events and working with CSV & XML files).
- Hands on experience with triage of day-to-day OTM systems issues and providing resolution on complex issues.
- Knowledge of Logistics management principles and processes.
- Broad knowledge and experience with various ERP systems. Working knowledge of Oracle eBusiness Suite (Procurement, Shipping, XML Gateway) is highly preferred.
- Working knowledge of BI Publisher, FTI/OAC, OBIEE and ETL.
- Good knowledge of EDI and any other Middleware systems.
- Strong customer service orientation with strong written and verbal communication skills, including comfort with presenting to diverse technical and non-technical audiences at all levels of the organization.
- Ability to multi-task and work within diverse multi-disciplinary global project teams.
- Detail-oriented with strong problem-solving skills.
- Comfortable with performing detailed data analysis to identify opportunities and gain higher level insight.
- Knowledge on GTM (Global Trade Management) will be a plus.
- Some travel might be required.
Education
- Bachelor’s degree in computer science, Information Systems, or another related field.
Please find the below skills which is required for L3 & Tech Lead Roll-
- Explanatory questions so as to evaluate English like
- Production Issue analysis & their resolutions (mainly server-side issues)
- Involvement and Role in UAT & Production Deployments & upgrade activities.
- Work domain: BFSI/Telecom/Logistics/Aviation etc
- Linux/ Unix Experience
- Application Server- Tomcat/ Apache
- Web-Services - REST API, HTTP Methods, HTTP Error Codes
- Experience with Outages, Disaster Recovery, DC-DR
- Protocols- SSL, TLS, SSH, FTP
- Basic Networking- server connection, IP Address, Changing Ports, Deleting Logs,
- Exp on DNS, DHCP,
- Experience with a Load balancer
- The idea of Audit or Vulnerability assessment Report of the system
- Database or SQL concepts
Requirements:
· UIPath certification
· Proficient in UI Path Platform, Test Manage, Test Suite, with 6+ years of Experience on Test Automation
· Hands-on experience in building automated scripts using Low-Code No-Code Platform (UIpath)
· Experience on Testing SOAP or REST API
· Experience building data driven tests and frameworks for Web, Windows, and Micro services.
· Understanding of test methodologies (regression, functional, unit, integration, code coverage, performance, etc.)
· Experience building data driven tests and frameworks for Web, Windows, and Micro services.
· Designing and developing test automation frameworks and understanding of test automation design patterns and software testing principles.
· Familiarity with Relational Databases and SQL
· Bachelor's degree in computer science, engineering or related field
· Minimum of 7 years of experience in software testing and test automation
· Minimum of 5 years of experience in UIPath test automation
· Strong knowledge of test automation frameworks and tools
· Experience with continuous integration and continuous delivery (CI/CD) pipelines
· Ability to analyze and debug complex issues
· Excellent problem-solving skills
· Strong communication skills and ability to work collaboratively in a team environment
· Knowledge of agile methodologies
Flexibility
Need to be flexible with respect to working times, provide two hours overlap with IST (Central Time) and UK time on an ongoing basis.
If you are passionate about test automation and have experience with UIPath, we encourage you to apply for this exciting opportunity. We offer a competitive salary, excellent benefits, and opportunities for growth and development.
- You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
- Development of high quality database solutions
- Create complex functions, scripts, stored procedures and triggers to support application development.
- Develop, implement and optimize stored procedures and functions using T-SQL
- Review and interpret ongoing business report requirements
- Build appropriate and useful reporting deliverables
- Analyze existing SQL queries for performance improvements
- Fix any issues related to database performance and provide corrective measures.
- MIS Automation
- Provide timely scheduled management reporting
- Create Business dashboard using Tableau BI Tool
Requirement / Desired Skills:
- 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
- Excellent understanding of T-SQL programming
- Excellent understanding of Microsoft SQL Server
- Good knowledge of HTML and JavaScript
- SQL Server Reporting Services and SQL Server Analysis Services
- Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)
Briefly describe Mandatory Skills:
We are looking for a MIS Analyst to participate with other Analysts in the team to convert the data into reports in various forms and thereby provide meaningful insights to the users of the reports and help them in decision making process. Experience Level – 1-2 yrs. of experience as MIS executive/analyst Responsibilities - · Managing the data including creation, updates, and deletion · Collecting the data, interpreting, analyzing, and developing the reports and dashboards · Generating reports from single or multiple systems · Processing confidential data and information according to the guidelines · Create visualizations and reports for requested projects in MS Excel and PowerBI platforms · Develop and update documentation Skills / Requirements - · Strong knowledge and experience in Advance MS Excel (MUST HAVE) · Basic knowledge of reporting tools like Power BI or Tableau · Basic Knowledge of SQL queries · Strong mathematical and analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy · Ability to analyze large data set and create meaningful visualization and reports · Analytical mind with a problem-solving attitude · Excellent communication · BSc/ MSc in Computer Science MSc/MCA, Engineering, or relevant field |
The position will coordinate closely with the head of engineering, the architect, and product managers to build a new healthcare software platform, Document customer meetings well and assess new requirements, build and manage relationships with key personnel, successful project delivery.
5 - 7 years of Healthcare Industry interoperability knowledge (HL7 and FHIR) for Medical Record sharing between Healthcare Organizations
Excellent familiarity with Interoperability Healthcare Standards Organizations and Initiatives
Excellent knowledge of FHIR specifications
Experience building HL7
Job Description
Role- Technical Writer – SaaS Product
About Saras Analytics
We are a passionate group of engineers, analysts, data scientists, and domain experts building products and offering services to accelerate the adoption of data as a strategic asset.
Our Products
Daton is our ETL platform for analysts and developers. Daton replicates data from SaaS platforms such as Google Analytics, Salesforce, Amazon, and Facebook Ads to cloud data warehouses like Amazon Redshift, Google BigQuery, and Snowflake. Daton consolidates data from a variety of data sources into a data warehouse within minutes and allows analysts to focus on generating insights rather than worrying about building and maintaining a data pipeline.
Halo is our eCommerce focused Business Intelligence and Analytics platform. Halo helps eCommerce businesses save time and money by automating the replication, transformation, preparation, and quality control of data for reporting and analysis. Halo transforms silos of eCommerce data into actionable data sets and useful reports that help you grow your business. Visit https://sarasanalytics.com/" target="_blank">https://sarasanalytics.com/
Responsibilities:
· Responsible for developing technical documentation detailing product features
· Responsible for creating product manuals, detailed how-to guides and FAQs
· Responsible for developing and maintaining technical documentation for both external usage and internal guidance across various teams.
· Responsible for setting up new processes and improve existing technical documentation process
· Responsible for converting product support questions into how to guides
· You would be working closely with product managers, product support and engineering teams to gather insights to document
Eligibility:
- 2-6 years of experience as a Technical Writer and in product documentation.
- Familiarity with third-party API integration analysis.
- Excellent logical, analytical and communication skills to interact with the Development team.
Requirements
· 2-6 years of experience as a Technical writer in SAAS products
· Engineering background in IT or Computer Science
· Excellent written and oral communication skills
· Familiarity with APIs, databases, and SQL
· Hands on experience with documentation and automation tools
· Hands on experience with version control tools
· Ability to grasp complex technical concept and make them easily understandable through documentation while paying attention to detail
· Prior work experience in E-Commerce domain is a plus
Informatica PowerCenter (9x ,10.2) : Minimum 2+ years experience
SQL / PLSQL: Understanding of SQL procedure. Able to convert procedures into Informatica mapping.
Good to have- Advantage if you have knowledge of Windows Batch Script.
Product Support Engineer (L1 Support) – Immediate Requirement.
Key skills
- 1-3 years exp in Product Support Role.
- Need to Understand the product and features, to demonstrate the end users.
- Sound knowledge on Java and SQL
- Need to Analyze and Resolve the Product specific queries, MySQL.
- Consistently Deliver the customer requirements.
- Engage with Development team and manage the progress of cases.
- Should be able to cope up with high pressure work environment.
- Work model will be 24X7.
Must require
- Good Communication both verbal and written
- Analytical skills
- Team player
- Preferred male applicants only