11+ SQL Query Analyzer Jobs in Chennai | SQL Query Analyzer Job openings in Chennai

• Proficient with SQL Server/T-SQL programming in creation and optimization of complex Stored Procedures, UDF, CTE and Triggers
• Overall Experience should be between 4 to 7 years
• Experience working in a data warehouse environment and a strong understanding of dimensional data modeling concepts. Experience in SQL server, DW principles and SSIS.
• Should have strong experience in building data transformations with SSIS including importing data from files, and moving data from source to destination.
• Creating new SSIS packages or modifying existing SSIS packages using SQL server
• Debug and fine-tune SSIS processes to ensure accurate and efficient movement of data. Experience with ETL testing & data validation.
• 1+ years of experience with Azure services like Azure Data Factory, Data flow, Azure blob Storage, etc.
• 1+ years of experience with developing Azure Data Factory Objects - ADF pipeline, configuration, parameters, variables, Integration services runtime.
• Must be able to build Business Intelligence solutions in a collaborative, agile development environment.
• Reporting experience with Power BI or SSRS is a plus.
• Experience working on an Agile/Scrum team preferred.
• Proven strong problem-solving skills, troubleshooting, and root cause analysis.
• Excellent written and verbal communication skills.

GL, AR, Expenses. May need Cash Management if it becomes in scope.

Load Rapid Implementation spreadsheet, GL Allocations, Journal, AP, Expense approval workflow & SLA configs

POSITION SUMMARY:

Should have completed minimum TWO end-to-end Fusion Finance implementation, up-gradation, lift & shift and support projects experience,

  Experience in Oracle Cloud (Fusion) Financials Functional in GL, AP, AR, FA, Cash Management, FAH, Intercompany, Expenses Management, RMCS, Procurement modules,

  Should understand business requirements, fit-gap analysis, and preparation of functional design documents,

  Should be able to manage the Finance track independently, interact with clients, conduct business requirements and training sessions, etc,

  Should conduct CRP, UAT & SIT sessions with clients/stakeholders,

  Experience in implementing financials cloud, configuring workflows, issue resolution and customization across all finance modules,

  Solid understanding of Enterprises Structure, COA, Structure, and Hierarchies, Flex fields, extensions set up in Fusion Financials,

  Experience in working with Oracle support for various issue resolutions,

  Experience in various financial data upload/migration technique (FBDI & ADFDi) and related issue resolutions,

  Reporting (Financial Reporting Studio (FRS), SmartView, OTBI),

  Experience in supporting Period closure activities,

  Knowledge on tax (Withholding and Transaction tax) setups,

  Experience in reconciliation financial data between GL and Subledger modules,

  High-level Knowledge of end-to-end integrations of Financials modules with other modules like Projects/Procurement/SCM/HCM,

  High-level Knowledge of other fusion modules (SCM or PPM) functionality is a plus,

  Should have excellent communication and presentation, strong analytical and problem-solving skills.

  Qualifications

  Graduation from a reputed institute,

  CA/CWA/CA-Inter or MBA will be an added advantage,

  Oracle fusion certifications will be an added advantage,

Qualification:

• 3+ Years’ software development experience in Core Java, Hibernate and swing
• User Interface technologies: XML, HTML, HTML5/Application Cache /WebSQL, Backbone, Enyo, SmartClient
• Should have worked of opensource ERP OpenBravo – not mandatory, preferred.
• Proficient in SQL Queries using PostgreSQL / MySQL
• Good analytical and communication skills.
• Should be able to manage development team
• Should be able to independently gather and analyze requirements with end users
• Should have developed APIs Preferably developed Mobile application / app
• Knowledge of development of Jasper Reports
• Preferably knowledgeable of business functions like sales/ purchase/ inventory
• Participate in technical design, development, testing, and documentation of plug-ins, modules or vertical requested by partners.

Job Functions:

• Provide technical support for open bravo application.
• Develop, test and deploy features that are given by the functional team.

JoVE is the world-leading producer and provider of science video solutions with the mission to improve scientific research and education. Millions of scientists, educators, and students use JoVE for their research, teaching, and learning. Our institutional clients comprise over 1,000 universities, colleges, and biopharma companies, including such leaders as Harvard, MIT, Yale, and Stanford. As a rapidly growing company, with offices in the USA, UK, Australia, and India servicing clients in over 60 countries, we are seeking talented and ambitious individuals to join our company.

The Role

We are seeking a dynamic and innovative Marketing Specialist with a passion for the biopharma sector. This role will focus on promoting JoVE’s unique solutions to biopharma companies. The ideal candidate will have a proven track record in B2B marketing, particularly within the life sciences, and will excel in creating content and executing lead-generation marketing campaigns that resonate with biopharma audiences.

Responsibilities

• Develop and execute marketing strategies tailored to biopharma companies
• Design and implement multi-channel marketing campaigns, including email marketing, social media, and paid ads to drive lead generation and audience engagement
• Create completing content for case studies, newsletters, blogs, social media, ads, and email campaigns
• Collaborate with the sales and product teams to align marketing initiatives with business goals
• Engage with industry professionals through events, webinars, and strategic partnerships to expand JoVE’s presence in the biopharma market
• Organize and deliver webinars and events at conferences
• Analyze marketing performance data and leverage insights to optimize strategies. Monitor KPIs such as lead generation, engagement, and conversion rates, providing actionable recommendations for improvements

Requirements

• A Bachelor’s degree in business, marketing, or life sciences
• 5+ years of experience in B2B marketing with a strong focus on the biopharma sector
• Strong understanding of the biopharma industry, including R&D processes and market trends
• Proficiency in marketing automation tools (such as HubSpot)
• Experience with Salesforce and B2B prospecting tools, such as LinkedIn Sales Navigator
• Excellent written and verbal English communication skills
• Strong analytical and problem-solving skills

Why Join JoVE?

• When working with JoVE, you can expect a compensation package competitively placed within the local market.
• You will make a direct impact in accelerating science research and in improving student learning in science education.
• Opportunity to work with global teams and in an environment that promotes innovation and collaboration.
• Our strong promotion from within culture draws a clear path to advance your career with us.

Responsibilities:

- Collaborate with cross-functional teams including front-end developers, designers, and system administrators to develop robust and scalable server-side applications.

- Design and implement RESTful APIs and services using Node.js, ensuring efficient data handling and integration.

- Develop database schemas and models for MongoDB, optimizing queries and ensuring data integrity.

- Implement data migration and transformation tasks between different data sources.

- Write efficient and reusable code, following best practices and coding standards.

- Conduct thorough testing and debugging of applications to identify and fix issues promptly.

- Collaborate with DevOps team to deploy applications on servers or cloud platforms.

- Continuously monitor application performance and optimize it for scalability and reliability.

- Stay updated on emerging technologies and trends, actively suggesting improvements and innovative solutions.

Requirements:

- Strong proficiency in Node.js and JavaScript.

- Solid understanding of server-side development and asynchronous programming concepts.

- Experience working with NoSQL databases (e.g., MongoDB).

- Knowledge of database design and query optimization techniques.

- Familiarity with web application security principles and best practices.

- Proficiency in using version control systems (e.g., Git).

- Good understanding of agile development methodologies.

- Excellent problem-solving and analytical skills.

- Effective communication and collaboration abilities.

Job Overview: We are seeking a dedicated Senior Statistical Programmer to join our dynamic team. You will be responsible for the development, quality control, and documentation of statistical (SAS) programming deliverables for clinical research studies.

Key Responsibilities:

1.      Lead and oversee the development of SAS programs for the management and statistical analysis of clinical trial data.

2.      Develop, test, and validate statistical tables, listings, and graphs (TLGs) in support of the statistical analysis plan.

3.      Support the generation and review of protocols, data management plans, study reports, and other regulatory documents.

4.      Provide input to the statistical analysis plan, table shells, data integration plans, and mock-ups.

5.      Ensure data quality by designing and validating key data checks and listings.

6.      Develop specifications for derived datasets and perform data transformation as necessary.

7.      Collaborate effectively with data management and biostatistics teams, clinicians, and other project stakeholders.

8.      Guide junior programmers and provide mentoring as needed.

9.      Keep abreast of new developments in SAS programming and clinical research, and act as a subject matter expert for the team.

Required Qualifications and Skills:

1.      Bachelor's or master’s degree in Statistics, Mathematics, Computer Science, or a related field.

2.      Minimum of 3 plus years of statistical programming experience in the pharmaceutical, biotech, or CRO industry.

3.      Excellent SAS programming skills and proficiency in SAS/Base, SAS/Macro, SAS/Graph, and SAS/STAT.

4.      Familiarity with CDISC SDTM and ADaM data standards.

5.      In-depth understanding of clinical trial data and extremely complex statistical methods.

6.      Excellent problem-solving skills and a proactive approach to identifying and resolving issues.

7.      Strong written and verbal communication skills, with the ability to translate complex data into understandable results.

8.      Proficiency in English, with excellent written and verbal communication skills.

9.      Prior experience leading teams or projects is highly desirable.

Preferred Skills:

1.      Experience in oncology, immunology, respiratory, infectious diseases, or neurosciences is a plus.

2.      Knowledge of other statistical software such as R or Python is a plus.

3.      Knowledge of regulatory guidelines (FDA/EMA/ICH) is preferred.

As a Technical Architect, you need to be

• Technology Expert
• Creative and self-driven
• Customer centric
• Visionary
• Comfortable operating in fast paced environment

You will closely work with Head of Product Engineering responsible for for the platform development, Chief Technology Officer driving the technology innovation, Software Development Leaders, Program Manager, SCRUM Masters, UX Designers

You will be responsible for

• Driving and defining the technical architecture of the Core SaaS platform
• Develop high-level technical specifications and design of the platform
• Define technical product roadmap to continuously enhance the platform.
• Communicate successfully all concepts and technical guidelines to development team
• Promotes and ensures use of appropriate techniques, methodologies and tools
• Bring in best of the class architectural practices in the platform

Your Qualifications

• 8 – 15 years of software product development experience, with majority of them is hands on experience developing in enterprise software product
• Experience in developing and hosting PaaS or SaaS based products/platform with hands on experience in multiple cloud platforms like AWS, Azure, Google Cloud and so on
• Experience developing enterprise- grade software products that can perform, scale, and integrate into a broad enterprise ecosystem
• Can mentor train existing team members on aspects of architecture, design and explain, document and elaborate architecture and design changes
• Strong background in architectural principles, patterns and anti-patterns
• Must have contributed to technology tools evaluation and technical proof of concept applications
• Should have experience in multiple tech-stacks including Data Analytics tech-stacks as well.

Hiring for Lead Auditor (QMS / ISMS) role.

Job description Below :

• Preparation Dept. Objective reports.
• Preparation of Internal Audit Schedule & Coordination /opening meeting and closing meeting.
• Follow up for Internal Audit closing of Observations.
• Preparation of Management review meeting Input & Output reports.
• Coordination Certification Audit and Surveillance (TUV-SUD) Audit for ISO 9001:2015 and ISO 27001:2013.
• Follow up for closing of Observations.
• To update QMS & ISMS Manual, Procedures, Policies, Risk Assessment Plan, SOA & Formats.
• Internal Audit of ISO - QMS & ISMS standards.

• Experience working on large enterprise application integrations. Deep understanding and delivering solution using common messaging patterns
• Experience with Enterprise Service Bus/Azure Service Bus preferred
• Deep understanding and experience with agile development practices, including unit testing and continuous integration.
• Willingness to take on additional responsibility to ensure team success and quality solutions.
• Team player that understands how your own work is important to the team's success.
• Ability to multitask across different projects.
• Become a partner and trusted advisor to the internal development team on best-fit technologies and best practices.
• Familiarity with object serialization to one of the following: XML, JSON, BSON.
• Database development skill using SQL Server a must.
• A deep understanding of the .NET platform.
• Experience with the ASP.NET MVC. C#, JavaScript, Microservices, Web API, WPF
• Exposure to an ORM such as Entity Framework or NHibernate or equivalent implementation.
• Windows server and Azure development experience
• Queuing experience using MSMQ (or equivalent).
• Development experience using HTML5/CSS/JavaScript frameworks such as AngularJS or Ember or equivalent.
• Professionalism to include written and oral communication and the ability to communicate collaboratively in front of a whiteboard. An ability to understand your audience and adjust your communication style appropriately.
• A desire to constantly learn and share new knowledge
• A caring attitude – care about what you do, who you do it with, and how you’re going to be successful in the end.
• 10+ yrs. professional software development experience.
• Solid working knowledge of four or more of the following technologies:
• Authoring APIs compliant with REST standards
• Development using HTML5/CSS/JavaScript frameworks such as AngularJS or Ember or equivalent
• Development using Silverlight or WPF JQuery

• Designing, developing, implementing, and releasing high quality custom software solutions.
• Applying the very best technical agile patterns and practices when building custom software solutions.
• Collaborating with customers to provide technical consultation and assistance when required.
• Working with CTO, Software Development Manager and Architect, but will be expected to work independently on complex, non-routine tasks and projects. You may interact with end-users and other technical personnel to identify and correct issues.
• Maintaining continuous, open, consistent professional communication with peers and team members. Openly listen to others and confirm understanding to ensure everyone is on the same page.
• Working closely with team members on quality-related activities.

Net Engineer:

Job Descriptions: Senior .NET Cloud (Azure) Practitioner

Job Description Experience: 8-12 years (approx.)

Notice period : 15-20 days max.

Location :Chennai(1^st preference),Bangalore and Hyderabad

Mandatory Skills

·       Strong Restful API, Micro-services development experience using ASP.NET CORE Web APIs (C#);

·       Must have exceptionally good software design and programming skills in .Net Core (.NET 3.X, .NET 6)  Platform, C#, ASP.net MVC, ASP.net Web API (RESTful), Entity Framework & LINQ

·       Good working knowledge on Azure Functions, Docker, and containers

·       Expertise in Microsoft Azure Platform - Azure Functions, Application Gateway, API Management, Redis Cache, App Services, Azure Kubernetes, CosmosDB, Azure Search, Azure Service Bus, Function Apps, Azure Storage Accounts, Azure KeyVault, Azure Log Analytics, Azure Active Directory, Application Insights, Azure SQL Database, Azure IoT, Azure Event Hubs, Azure Data Factory, Virtual Networks and networking.

·       Strong SQL Server expertise and familiarity with Azure Cosmos DB, Azure (Blob, Table, queue) storage, Azure SQL etc

·       Experienced in Test-Driven Development, unit testing libraries, testing frameworks.

·       Good knowledge of Object Oriented programming, including Design Patterns

• Cloud Architecture - Technical knowledge and implementation experience using common cloud architecture, enabling components, and deployment platforms.

·       Excellent written and oral communication skills, along with the proven ability to work as a team with other disciplines outside of engineering are a must

·       Solid analytical, problem-solving and troubleshooting skills

Desirable Skills:

·       Certified Azure Solution Architect Expert

o   https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-900-exam-preparation-microsoft-azure-fundamentals-524%2F&;data=05%7C01%7C%7Cb1b4eb5832414d395d6a08dac6664f6b%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638040439967432270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=sjIg554Fzuhah%2BLm1FC7znr9WrbVWw8PuvmoYbeDDmc%3D&reserved=0" target="_blank">Microsoft Certified: Azure – Fundamentals Exam AZ-900

o   https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-104-exam-preparation-microsoft-azure-administrator-1-1332%2F&;data=05%7C01%7C%7Cb1b4eb5832414d395d6a08dac6664f6b%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638040439967432270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=U%2Fusuw7eB2%2BOcqrLLaFhFLUiPXKxsOFiMogcbeXk83o%3D&reserved=0" target="_blank">Microsoft Certified: Azure Administrator – Associate Exam AZ-104

o   https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-204-exam-preparation-developing-solutions-for-microsoft-azure-1208%2F&;data=05%7C01%7C%7Cb1b4eb5832414d395d6a08dac6664f6b%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638040439967432270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=8NS7FvcbCzFhLiXHXvBVqSyC3e3ffjDNYH95UiQh1eY%3D&reserved=0" target="_blank">Microsoft Certified: Azure Developer – Associate Exam AZ-204

o   https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Facloudguru.com%2Fblog%2Fengineering%2Fwhich-azure-certification-is-right-for-me%23devops-engineer&;data=05%7C01%7C%7Cb1b4eb5832414d395d6a08dac6664f6b%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638040439967432270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=c69xXIJIf480QdSEQ8VuIpQZIK2YSm4iI2D6arpWKCU%3D&reserved=0" target="_blank">Microsoft Certified: DevOps Engineer Expert (AZ-400)

o   https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Facloudguru.com%2Fblog%2Fengineering%2Fwhich-azure-certification-is-right-for-me%23solutions-architect&;data=05%7C01%7C%7Cb1b4eb5832414d395d6a08dac6664f6b%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638040439967432270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=gnCQGt%2Bnu9MJNaLRde%2FuEve0K8V8EJpVmjAUTrJKSDE%3D&reserved=0" target="_blank">Microsoft Certified: Azure Solutions Architect Expert (AZ-305)

·       Good understanding of software architecture, scalability, resilience, performance;

·       Working knowledge of automation tools such as Azure DevOps, Azure Pipeline or Jenkins or similar

Roles & Responsibilities

·       Defining best practices & standards for usage of libraries, frameworks and other tools being used;

·       Architecture, design, and implementation of software from development, delivery, and releases.

·       Breakdown complex requirements into independent architectural components, modules, tasks and strategies and collaborate with peer leadership through the full software development lifecycle to deliver top quality, on time and within budget.

·       Demonstrate excellent communications with stakeholders regarding delivery goals, objectives, deliverables, plans and status throughout the software development lifecycle.

·       Should be able to work with various stakeholders (Architects/Product Owners/Leadership) as well as team -  Lead/ Principal/ Individual Contributor for Web UI/ Front End Development;

·       Should be able to work in an agile, dynamic team environment;