SQL Server Data Engineer, Salesforce Conversion

4 days ago

india, IN Atom Full time

Job Title: SQL Server Data Engineer – Salesforce Conversion (Oracle Fusion Source)

Company: Atom – Offshore Delivery Team

Location: India (Offshore) – Remote/Hybrid Type: Contract / Full-time


Role Summary:

Atom is looking for a hands-on SQL Server Data Engineer in our offshore team to lead

and execute the data conversion from Oracle Fusion to Salesforce. You will work closely with onsite

architects and functional teams to design, build, and optimize SQL Server–based staging and

transformation processes and ensure accurate, complete, and timely migration of data into

Salesforce.


Key Responsibilities

  • Design and build SQL Server–based ETL processes (T-SQL, stored procedures,
  • SQL jobs) for migrating data from Oracle Fusion into Salesforce. - Create and maintain staging
  • tables, mappings, and transformation logic to align Oracle Fusion data structures with Salesforce
  • objects.
  • Analyze Oracle Fusion data model (customers, accounts, contacts, opportunities,
  • transactions, etc.) and map it to Salesforce standard and custom objects. - Develop robust data
  • validation and reconciliation scripts/reports to ensure completeness and accuracy pre- and postload.
  • Optimize SQL queries and jobs for performance and scalability on large data volumes in SQL
  • Server.
  • Collaborate closely with onsite Salesforce functional/technical teams to align on object
  • model, required fields, and data constraints. - Work with Oracle Fusion functional/technical teams to understand source data, business rules, and data quality issues. - Troubleshoot and resolve dataload issues, referential integrity problems, and performance bottlenecks during mock cycles andcutover.
  • Prepare and maintain technical documentation (mapping documents, conversion design, runbooks, data dictionaries). - Support mock runs, dry-runs, and final cutover during Salesforce golive, including extended hours overlap with US time zones where required.


Required Skills & Experience

  • 5+ years of hands-on experience with Microsoft SQL Server in a data
  • engineering / ETL / data conversion role.
  • Proven expertise in T-SQL, including complex joins, window functions, stored procedures, views, functions, and SQL Server Agent jobs.
  • Experience delivering end-to-end data migration or data conversion projects as a primary SQL resource.
  • Strong working knowledge of Salesforce data model (Accounts, Contacts, Opportunities,
  • Cases, Activities, and custom objects).
  • Experience loading data into Salesforce using tools such
  • as Salesforce Data Loader, SSIS, or other ETL tools.
  • Practical exposure to Oracle Fusion (Cloud) / Oracle ERP as a data source – understanding of key master and transaction data entities.
  • Strong skills in data profiling, data cleansing, and data quality checks.
  • Ability to work in a fast-paced project environment with offshore–onsite collaboration.
  • Excellent communication skills in English


Nice to Have

  • Experience with integration platforms (OIC, Mulesoft, Boomi, Informatica, etc.) for
  • Salesforce integrations.
  • Prior involvement in end-to-end Salesforce implementations or large-scale CRM migrations.
  • Familiarity with SOQL, Apex basics, and Salesforce REST/SOAP APIs (for understanding and troubleshooting).
  • Experience working in cloud environments (Azure / AWS) hosting
  • SQL Server workloads.

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent

practical experience

  • Senior SQL Server Database Administrator – Azure

    2 weeks ago

    india, IN Maitsys Full time

    Experience Level: Senior (Minimum 10 years of professional experience)Job Summary:We are looking for an experienced Senior SQL Server Database Administrator (DBA) with strong expertise in Azure SQL Server and Azure SQL Subscription management. The ideal candidate will have a proven track record in managing, securing, optimizing, and migrating SQL Server...

  • SQL or Python Developer

    2 days ago

    india, IN HRM Counsel Full time

    We are looking for an experienced SQL or Python Developer to join our engineering team and help us create dynamic software applications for our clients. In this role, you will be responsible for writing and testing scalable code, developing back-end components, and integrating user-facing elements in collaboration with front-end developers. To be successful...

  • Data Engineer

    4 days ago

    india, IN Ignisov Consulting Services Full time

    Role: Data Engineer – HR Data ConversionJob Type: ContractJob Location: RemoteExperience: 5–10 yearsJob Description:Key Responsibilities:Develop and maintain ETL pipelines using Python and AirflowWork with SQL, GCP BigQuery, and cloud-based data workflowsBuild scalable solutions using Spark, Hive, HDFSDesign and optimize data models for HR data...

  • Data Engineer

    6 days ago

    india, IN Insight Global Full time

    Insight Global is seeking a Senior Data Engineer to design, build, and scale robust data solutions on Microsoft Azure. You’ll own modern data pipelines and models that power analytics and reporting across the business. The ideal candidate is hands‑on with SQL databases, Azure Data Lake Storage, Azure Data Factory (ADF), and Power BI, and is comfortable...

  • Salesforce COE

    2 weeks ago

    Bangalore Urban, Karnataka, India, IN Brillio Full time

    Job description:Location: Bangalore, India Required: 7+ Years in Salesforce Ecosystem Role Overview We are seeking an experienced Salesforce professional with 7+ years of expertise to join our team as an R&D and Innovation Lead (Salesforce COE). The ideal candidate will have a strong background in Salesforce COE (Center of Excellence), Presales, and...

  • Salesforce Test Engineer

    2 weeks ago

    , India, IN eJAmerica Full time

    IntroductionWe are seeking a skilled and experienced Salesforce Test Engineer to join our team in Bengaluru, Karnataka, India. As a Salesforce Test Engineer, you will be responsible for designing, developing, and maintaining efficient Salesforce applications, as well as collaborating with cross-functional teams to define and implement new features. If you...

  • Salesforce System Engineer

    1 week ago

    india, IN Deltek Full time

    Shift Timings : 6 pm to 3 am IST Position Responsibilities :We’re looking for a Salesforce System Engineer I–II who thrives in a fast-paced, collaborative environment and can work independently with minimal supervision. This role is ideal for someone who enjoys solving technical challenges, optimizing systems, and communicating clearly across global...

  • SQL Server integration production Support

    1 week ago

    Gurugram, Haryana, India, IN Tata Consultancy Services Full time

    Position-SSIS+Production supportSkills- SQL Server Integration Services, SQL, Python, Production Support, AutomationLocation- GurugramEcperience- 6 to 8 yearsNotice Period- 15/30 days or Immediate joinersShift- Early MorningJob Description-1. Automation & Scripting. 2.Experience in Python scripting for process automation. 3.Ability to convert manual steps...

  • Data Engineer

    1 week ago

    , India, IN Futran Solutions Full time

    Job Title: Data EngineerPosition Type: Full TimeJob Location: PuneExperience Required: 2 to 15 YearsCompensation: Best in MarketBenefits: PF, MediclaimRoles & ResponsibilitiesDevelop and optimize data pipelines.Ensure systems deliver required functionality with reduced defects.Analyze stored procedures and extract business logic.Write complex SQL queries and...

  • Senior Data Engineer

    2 weeks ago

    Gurugram, Haryana, India, IN Pacific Data Integrators Full time

    Role: Senior Data EngineerLocation: RemoteJob Type: Full-timeShift time: Open to work in EST shift (5PM to 2AM IST) Key ResponsibilitiesLead the design, development, and implementation of complex data integration solutions using Informatica Intelligent Data Management Cloud (IDMC).Develop, document, unit test, and maintain high-quality ETL applications that...