Johnson Controls
Produces HVAC, fire, security and building automation systems to optimize and protect buildings globally.
Content & Data Migration Specialist
Manage ETL & data migration between Salesforce and legacy systems, ensuring data quality.
Job Highlights
About the Role
You will build, test, and deploy data load and migration scripts while establishing repeatable ETL strategies. The position supports data extracts, reporting, and management requests from both business and technical stakeholders. You will lead solution designs, delivering scalable real‑time solutions, and participate in all Agile development activities, including PI planning and sprint reviews. • Build, test, and deploy data load and migration scripts. • Develop repeatable ETL strategies and manage data processes. • Support data extracts, reporting, and management requests. • Lead solution designs and deliver scalable real‑time solutions. • Participate in Agile cycles, including PI planning and sprint reviews. • Automate pipelines using Azure DevOps. • Apply SAFe Agile framework principles.
Key Responsibilities
- ▸data migration
- ▸etl development
- ▸data extraction
- ▸solution design
- ▸azure devops
- ▸safe agile
What You Bring
The ideal candidate has 6–8 years of experience with ETL tools such as Informatica, Microsoft SSDT, Talend, DBAmp, and Data Loader, and a proven record in Salesforce data management. Strong skills in SQL, PL/SQL, T‑SQL, Perl, and Windows batch automation are required, along with experience using data‑cleansing utilities like DemandTools and address validators. Familiarity with cloud storage (AWS S3, Azure Blob, Cloudinary) and a background in IT quality assurance round out the profile. • 6–8 years of ETL experience with tools like Informatica, SSDT, Talend, DBAmp, Data Loader. • Proven expertise in Salesforce data management. • Strong SQL/PLSQL/T‑SQL, Perl, and Windows batch scripting skills. • Experience with data‑cleansing tools (DemandTools, D&B, Address Validator). • Familiarity with cloud storage services (AWS S3, Azure Blob, Cloudinary).
Requirements
- ▸informatica
- ▸talend
- ▸salesforce
- ▸sql
- ▸aws
- ▸etl
Benefits
Johnson Controls offers a competitive salary, comprehensive benefits, and clear pathways for professional growth within a dynamic, innovation‑driven team. Employees contribute to high‑quality solutions that enhance client success and drive smarter, more sustainable buildings.
Work Environment
Office Full-Time