4 Cleansing Processes Jobs

Location: Mumbai (Andheri East) Designation: Data Engineering/Analytics Job Summary: We are looking for a Data Engineer with up to 5 years of experience in ETL processes to lead the migration of MongoDB data to MSSQL. The ideal candidate will design, develop, and optimize data pipelines, ensuring seamless data transformation, integrity, and performance. Key Responsibilities: Design and implement ETL workflows for migrating data from MongoDB to MSSQL. Develop data transformation and cleansing processes to ensure data integrity. Optimize data pipelines for performance, scalability, and reliability. Collaborate with database administrators and business teams to define migration strategies. Work with SQL Server tools (SSIS, T-SQL) for data integration. Monitor and troubleshoot ETL workflows to ensure smooth operations. Maintain documentation for migration processes, data models, and pipeline configurations. Required Skills & Qualifications: Proficiency in MongoDB and MSSQL (schema design, indexing, query optimization). Strong knowledge of ETL tools (SSIS, Talend, Informatica). Experience in data migration strategies and performance tuning. Expertise in SQL Server (stored procedures, triggers, views). Understanding of data governance, security, and compliance. Preferred Qualifications: Experience with cloud-based data migration (AWS RDS). Knowledge of MongoDB aggregation framework. Exposure to CI/CD pipelines for database deployments.

You should have a total of 7-8 years of experience with at least 7 years of relevant experience. Your mandatory skills should include expertise in Salesforce Fusion and in-depth knowledge of APIs, including RESTful and SOAP web services. It is essential to have proficiency in data management, encompassing migration, cleansing, and validation processes. Additionally, familiarity with marketing automation concepts such as lead scoring, nurturing campaigns, forms, and landing pages is required. Strong problem-solving and analytical skills are crucial for diagnosing and resolving complex integration challenges. Your key responsibilities will involve the design and architecture of robust integration solutions between the marketing automation platform (Salesfusion/Sugar Market) and various CRMs (e.g., Salesforce, SugarCRM, Microsoft Dynamics), as well as other third-party systems. You will collaborate with sales, marketing, and IT stakeholders to define integration requirements and data flow processes. Furthermore, you will develop, test, and deploy custom integrations and data synchronization workflows using native connectors, APIs (REST/SOAP), and middleware platforms. Ensuring data integrity and consistency across all integrated systems by implementing and maintaining data mapping, transformation, and cleansing processes is essential. As the subject matter expert for all integration-related issues, you will provide timely troubleshooting and resolution, monitor system performance and data syncs, and proactively identify and resolve potential issues. Managing user profiles, permissions, and security settings related to integrations will also be part of your responsibilities. Moreover, you will automate manual processes by leveraging the marketing automation and integration capabilities of the platform. It is crucial to create and maintain comprehensive documentation of all integrations, data models, and workflows. Additionally, providing training and support to end-users on how integrated systems function and interact will be required.,

You will be part of the Critical Care (or relevant business unit) within the Finance department on a 1-year fixed contract at Kurla with low travel requirements. Your primary responsibility will be to clean and prepare legacy financial data to facilitate a successful migration to SAP. This will involve reviewing and resolving open items in vendor and general ledger accounts, as well as sanitizing and formatting data for upload. Ensuring data accuracy and integrity is crucial in this role to guarantee that the financial data is clean, consistent, and migration-ready for a smooth transition to the new system. You will report directly to the Finance Controller and will not have any direct reports. Key internal stakeholders you will collaborate with include Supply Chain, Shared Services, Procurement, and Central Functions, while external stakeholders will include Vendors and Banks. To qualify for this role, you need to be a graduate in any discipline with hands-on experience in SAP ECC 6.0, specifically in the Financial Information module. A strong understanding of financial data structures, reconciliation, and cleansing processes is essential. Your ability to identify, analyze, and resolve data discrepancies, along with being detail-oriented with excellent problem-solving and analytical skills, will be crucial for success in this position.,

As a Senior Software Engineer at Clarivate, you will be an integral part of our Technology team, focusing on data engineering, ETL, and script writing to create efficient data pipelines for data cleansing and structuring processes. To excel in this role, you should hold a Bachelor's degree in computer science or possess equivalent experience. Additionally, a minimum of 3 years of Programming Experience with a strong grasp of SQL is required. Experience with ETL processes, APIs, data integration, system analysis, and design is highly valuable. You should be adept at implementing data validation and cleansing processes to maintain data integrity and proficient in pattern matching, regular expressions, XML, JSON, and other textual formats. In this position, you will be analyzing textual and binary patent data, utilizing regular expressions to extract data patterns. Writing clean, efficient, and maintainable code according to coding standards, automating tests, and unit testing all assigned tasks are key responsibilities. You will collaborate closely with Content Analysts team to design and implement mapping rules for data extraction from various file formats. Furthermore, you will liaise with cross-functional teams to understand data requirements and provide technical support. Ideally, you would have experience with cloud-based data storage and processing solutions like AWS, Azure, Google Cloud, and a strong understanding of code versioning tools such as Git. At Clarivate, you will be part of the Data Engineer team, collaborating with multiple squads comprising Data Engineers, Testers, Leads, and Release Managers to process and deliver high-quality patent data from diverse input source formats. This permanent position at Clarivate offers a hybrid work model with 9 hours of work per day, including a lunch break, providing a flexible and employee-friendly work environment. Clarivate is dedicated to promoting equal employment opportunities for all individuals in terms of hiring, compensation, promotion, training, and other employment privileges. We adhere to applicable laws and regulations to ensure non-discrimination in all locations.,