Johnson Controls

Data Specialist

Bangalore, Karnataka
Salesforce ETL SQL Server SQL PL/SQL T-SQL Perl Talend Informatica AWS Azure DBAmp
Description

Data Specialist

Location: Bangalore-Karnataka-India

Time Type: Full time

Job Description

Data Specialist

Overview:

Johnson Controls is seeking a talented and motivated Salesforce Data Migration Specialist to join our growing team. The specialist will be responsible for end‑to‑end migration of data from legacy systems into Salesforce using Salesforce tools and ETL expertise. This role will play a key part in designing, managing, and executing data migration processes between Salesforce, legacy applications, databases, and unstructured data source ensuring data integrity, accuracy, de‑duplication, and full compatibility with the Salesforce environment.

Key Responsibilities:

  • Analyze legacy data sources, assess data quality and define mapping/transformation for Salesforce objects.
  • Design, develop, and execute data migration strategies using DBAmp for SQL Server–Salesforce integration.
  • Automate recurring data loads, report generation, and file transfers using batch scripts, FTP/SFTP servers, and scheduling tools like Windows Task Scheduler.
  • Support data extracts, reporting, data management requirements from business and technical stakeholders.
  • Build and maintain ETL workflows in Talend and/or Informatica for data extraction, transformation, and loading.
  • Building strategy for repeatable ETL and data processes.
  • Collaborate with Salesforce administrators, developers, and business stakeholders to align migration with project goals.
  • Conduct migration testing, troubleshoot issues, and optimized performance.
  • Document migration processes, data models, and transformation logic for future reference

Required Skills & Qualifications:

  • Bachelor’s degree in computer science, Information Technology, Data Engineering, or a related field.
  • 3-5 years of experience with Salesforce DBAmp for SQL Server integration and Salesforce Data Loader, Data Import Wizard, Workbench.
  • Excellent in SQL, PL/SQL ,T-SQL, Perl skill and understanding of relational databases.
  • Experience with batch scripting and FTP/SFTP automation and scheduling tools.
  • Experience with Salesforce Sales Cloud or Service Cloud.
  • Knowledge of Salesforce data structures, APIs, and best practices for large-scale data migration.
  • Ability to work effectively in a collaborative, team-oriented environment.
  • Coordinating with teams spread across the globe.
  • Excellent verbal and written communication skills, with the ability to interact with technical and non-technical stakeholders.
  • Flexible in acquiring new data integration skills sets as recommended in the enterprise.
  • Relevant certifications (optional but beneficial): Salesforce Administrator, SQL Server, AWS/Azure.

Preferred Qualifications:

  • Hands-on expertise in Talend and/or Informatica ETL tools.
  • Familiarity with cloud storage integrations (AWS S3, Azure Blob, etc.).

Johnson Controls
Johnson Controls

0 applies

0 views

There are more than 50,000 engineering jobs:

Subscribe to membership and unlock all jobs

Engineering Jobs

60,000+ jobs from 4,500+ well-funded companies

Updated Daily

New jobs are added every day as companies post them

Refined Search

Use filters like skill, location, etc to narrow results

Become a member

🥳🥳🥳 452 happy customers and counting...

Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.

To try it out

For active job seekers

For those who are passive looking

Cancel anytime

Frequently Asked Questions

  • We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
  • We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
  • We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
  • We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
  • Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
  • Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
  • Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅

What Fellow Engineers Say