About the Role: We are looking for a highly skilled SQL Server Developer with at least 5 years of hands-on experience in designing, developing, optimizing, and maintaining SQL Server databases. The ideal candidate will have a strong background in writing complex T-SQL queries, stored procedures, functions, triggers, and views, along with expertise in performance tuning and query optimization. Key Responsibilities: Database Development & Maintenance Design, develop, and maintain SQL Server databases to support business applications. Write complex T-SQL queries, stored procedures, user-defined functions, views, triggers, and table-valued functions. Create and manage indexes, partitions, and schemas for performance optimization. Implement data integrity, referential constraints, and best practices for database design. Performance Optimization: Analyze query execution plans and perform query tuning to improve performance. Monitor database performance using tools like SQL Profiler, Extended Events, and DMVs. Identify and resolve database bottlenecks, deadlocks, and blocking issues. Data Management & Integration: Develop and maintain SSIS (SQL Server Integration Services) packages for ETL processes. Work with large datasets and handle data cleansing, transformations, and migrations. Database Security & Backup: Implement user roles, permissions, and data encryption for security. Schedule and monitor database backups and recovery plans. Ensure high availability and disaster recovery mechanisms are in place. Collaboration & Documentation: Work closely with application developers, business analysts, and QA teams to deliver robust solutions. Prepare technical documentation for database designs, stored procedures, and deployment steps. Participate in code reviews and enforce best coding practices.
Designation : Legal Analyst Location : Noida Contact Person : Sonakshi Gupta (HR) Roles and Responsibilities The Legal Analyst will be responsible for performing Regulatory Content Management of multiple Regulators. The Legal Analyst will be responsible for the prompt, accurate and efficient populating of Metadata fields in the CMS Tool in accordance with the link based updates supplied in the Excel sheet. The candidate will be responsible for checking for Rules from the updates and categorizing it based on whether the Rules has been Introduced / Amended / Referenced / Repealed. The candidate will also be responsible for identifying Citations and adding Rules Mentioned in the update. The Legal Analyst will be responsible for the addition, amendment and deletion of Rules in the respective regulatory library of each monitored Regulatory Body maintained on the CMS Tool. The candidate will also be responsible for contribution to related Filler Projects. Required Candidate profile Prior legal review and analysis experience in a legal analyst role. Prior work experience with content summarization and management. Good command over English language Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint, Outlook). Kindly mark your attendance or apply by sharing your updated resume o below mentioned email ID sonakshi.gupta@aptaracorp.com
Job Purpose : As a Manager - Graphic Design, you should understand the entire process of overall visual design requirements of a large account and the projects within/under the account. You will be responsible for shaping the visual output of various media files/elements. You will manage the day-to-day task of your team and ensure customer requirements are met and exceed expectations. You need to have a creative flair and a strong ability to translate requirements into design. You should be familiar with eLearning and the underlying principles of how visual design can impact learning. You should have a high-level understanding of design strategies, various types of learning modalities like microlearning, gamification, interactive videos, branching scenarios, mobile based learning, learning experience platforms, etc. Responsibilities: Participate in pre-sales activities (RFPs, RFQs, RFIs, etc.) and create prototypes/pilots as per clients specifications and requirements. Responsible to provide innovative solutions to customers by using new technology, techniques, and creative ideas. Ability to work on effort estimates and the assumptions for the proposal/SOW based on the design solutions provided. Conduct team meetings from time to time and maintain a healthy work environment. Create and develop deliverables as per project specifications, quality standards, and design strategy. Conduct peer reviews of the deliverables at different stages of training development. Participate in org level activities induction training, project-specific functional training, recruitment activities (candidate interviews, test evaluations, etc.). Coordinate with Lead/Manager/Delivery Manager for different activities (planning, solutioning, training, RFPs/RFQs/RFIs, etc.). Attend client calls and ensure that the client's feedback and requirements are addressed. Participate in people management activities resolve conflicts, manage expectations. Manage large team and accounts. Coordinate with vendor to ensure the quality and timely delivery. Audit the graphic design processes. Key Tasks: Conceptualize visuals based on requirements and prepare rough drafts and present ideas. Oversee and manage design and layouts, and provide guidance as needed to the Design Leads. Attend design consultation meetings for unusual or large-scale projects. Create project specific design guidelines and checklist documents, also ensure adherence from the team. Work in all design and development tools (Adobe CC Suite, Articulate-360, Camtasia, and other rapid development tools, etc.). Ensure adherence to brand guidelines and maintain consistency. Ability to work independently and manage responsibilities and priorities in a dynamic and time-critical environment. Learn new tools, design approaches, methodologies as per the trends in graphic/visual design. Conduct team trainings, keeping in mind the current and future requirements of the industry. Communicate with team members and address all issues related to team morale. Expert in creating custom UI and custom interactions for rapid tools such as Storyline 360, Captivate, etc. Expert in Accessibility Compliance. Meet all project requirements and exceed expectation to WOW the customer with enhanced customer experience. Qualification: A Graduate in Fine Arts (GD Art, BFA, or MFA) OR A degree/diploma/certification in Graphic Design Added Advantage: Human Computer Interaction (HCI), Human Factors International (HFI), or AR-VR Certification.
Hi All, Aptara is hiring for Indesign : Company Profile: Aptara provides digital publishing solutions that deliver significant gains in cost, quality and time-to-market for content publishers. With comprehensive solutions across all delivery media, Aptaras expertise includes content technology solutions, eBook creation, app development, publishing services, content conversion, and eLearning. Founded in 1988 around its unique publishing technical expertise, Aptara is a company with over 5000 professionals deployed globally and serving leaders in Media and Publishing, Information Services, Professional Services, Manufacturing, Technology, Engineering, Hospitality, Healthcare and Government. For more information visit www.aptaracorp.com. Job description: Adobe, Indesign, Illustrator, photoshop. Layout pages as per clients requirement and specification within the stipulated time. Making sure all marked corrections are properly interpreted and diligently carried out, no errors induced. Knowledge of Adobe Photoshop/Illustrator will be added advantage. Candidate should be open to work in rotational shifts. Studies and familiarizes oneself with project rules, specifications and updates of the assigned project. Works on assigned file as per the set instructions. Interested candidates can come for F2F round of Interview & share resume on atul.kumar1@aptaracorp.com Contact Person :- Atul Kumar ( HR ) Aptara A37, Gate No 8, Sector 60 Noida Near by 59 metro station Please share your updated resume over my mail ID.
Role: Research Analyst Employment type: Full time Experience: 5-8 years experience as a Research Analyst Contact Person : Atul Kumar (HR) Job Description: Conduct secondary research to analyse data and information Use the web and private / public databases as resources for finding information about author and editor misconduct Perform analysis of documents after reading Create detailed reports of researched details Organize and store data Export reports and manipulate them in Microsoft Excel Excel manipulation includes sorting, filtering, hiding or un-hiding columns, adding/deleting rows/columns and copying/pasting text Upload manipulated Excel files/sheets into a shared Google Drive Folder Required Candidate Profile: Good verbal and written communication skills Expertise with Office applications such as MS Excel, MS Word, Google Drive, and Google Sheet Strong internet browsing skills and have analytical/logical knowledge. Open to working late evening shifts Professional and self-motivated Excellent at multitasking and time management Eye for detail/accuracy Contact Person - Atul Kumar ( HR ) Contact Number - 8510950575 Mail ID - Atul.kumar1@aptaracorp.com
Roles and Responsibilities: Ensure the content or piece of writing is free of any errors, be it factual or grammatical. To sub-edit text written by a number of authors to ensure consistent house style. To proofread files and documents to check for grammar, spelling, and punctuation. To check for visual problems (e.g., tabs, alignment, consistency of fonts and spacing, etc.) To revise scientific language for flow, usage, and clarity and ensure facts, data, and scientific units have been used correctly. Responsible for fact-checking, medical spell checks, and conducting other quality control reviews. To guide other team members on editorial policies, styles, and best practices. To convey edits and queries in a productive, friendly, and concise format with the content creator and internal team. To check reference lists for completeness, correct spelling, etc. Rephrase written text and ensure document structure and content are consistent. To forward proofread materials for approval and publication. Desired Candidate Profile Fluent in both spoken and written English. Minimum 1-8 years of professional experience working as QC in the publishing industry for Books Should know to understand and execute specifications/instructions provided by the customer Ready to work in flexible shifts Interested candidates can share their update resume on the below mentioned email ID. Contact Person:- Sonakshi Gupta (sonakshi.gupta@aptaracorp.com) APTARA, A-37, Gate no 8, Sector 60, Near by 59 metro station, Noida
Role & responsibilities Excellent written communication in English (grammar, clarity, and tone) Ability to understand technical issues and respond appropriately via email Strong comprehension and documentation skills Proficiency in using support tools, ticketing systems and email platforms
Job Description : Strong Command over English in written as well as in Verbal. Going thoroughly through the copyedited and typeset articles and checking for the grammatical and stylistic errors. Communicating with the Publisher if there is any query or question. Giving regular feedback to the editorial and the composition team so that the errors can be minimized. Collating the author corrections and providing the marked PDF to the team for making the corrections. Ensuring that all the corrections have been taken in correctly before sending the files to the Publisher. Tracking the WIP articles and holding daily meetings with the editorial and composition team to discuss the status. Holding training programs with the editorial team with the aim of improving the quality of the copyediting. Contact Person- Atul Kumar (HR) Contact Number - 8510950575 Mail I'd - atul.kumar1@aptaracorp.com
Hi All, Greetings!!! We are conducting walk in Interviews , kindly check the following details:- Role & responsibilities To provide quality customer support services via Calls, E-mails, and Chats Answer incoming calls, e-mails, and chats while responding to customer's queries or issues Provide product and service information to customers with focus on First Time Resolution Research, identify, and resolve customer complaints using applicable software Route calls, email, and chat to appropriate resources Follow up with customers where necessary via outbound calls or e-mails, whichever is applicable Preferred candidate profile A bachelors degree from a reputed university (for permanent post) or undergoing graduation studies (for contractual position) Superior listening, verbal, and written communication skills Excellent Typing Skills (25-30 wpm or better) with good accuracy (90% and above) Should be willing to stretch the work hours, as and when required, as per client requirement Open for Noida location and night shifts Perks and benefits A clear and neutral accent without any mother tongue influence (MTI) Confident and pleasing personality Experience in a technical troubleshooting process (preferred, not mandatory) Computer Savvy and proficient in relevant computer applications Knowledge of customer service practices and principles Bring your Updated CV Contact Person :- Atul Kumar ( HR ) Contact Number :- 8510950575 Address;- A-37, Gate No 9, Block - A, Sector - 60, Noida, near by 59 metro station, Noida
Excellent verbal, written, and interpersonal communication skills. Critical thinking and problem-solving skills are essential. • Willingness to manage multiple tasks at once and adhere to process and deadlines. • Ability to clearly communicate, expressing requirements and expectations. • Assist Project Managers in day-to-day tasks for reports and data gathering. Candidates with knowledge of Power BI and reporting knowledge will be an added advantage Managing project management documents such as the project plan, schedule, etc. Executing a variety of project management administrative tasks, such as monitoring project progress, creating project status reports for project managers and stakeholders, etc. Assisting Project Managers in resource planning and alignment Assisting Project Manager in maintaining records/reports for multiple requirements like licenses, hardware requests, submission of daily hours, etc. Working closely with the systems, HR, and Admin teams for completion of task