At Motorola Solutions, we're guided by a shared purpose - helping people be their best in the moments that matter - and we live up to our purpose every day by solving for safer. Because people can only be their best when they not only feel safe, but are safe. We're solving for safer by building the best possible technologies across every part of our safety and security ecosystem. That's mission -critical communications devices and networks, AI-powered video security & access control and the ability to unite voice, video and data in a single command center view. We're solving for safer by connecting public safety agencies and enterprises, enabling the collaboration that's critical to connect those in need with those who can help. The work we do here matters.
Department Overview
Our IT organization has a critical role in driving extraordinary business results. Through a strong partnership with other areas of our business, we bring innovative thinking to every conversation and deliver with integrity. We’re looking for people who bring great ideas and who make our partners’ ideas better. Intellectually curious advisors (not order takers) who focus on outcomes to creatively solve business problems. People who not only embrace change, but who accelerate it.
Job Description
Responsibilities:
You will be responsible for data integration/data mashing from multiple systems/warehouses to the centralized Heroku Postgres database. Additionally you will conduct development of new Postgres queries/functions/procedures in order to expose data to Salesforce Cloud Platform.
Finally you will be accountable for new data structures creation for current/new data sets coming to Centralized Postgres Database.
Skill Set Requirements:
MUST HAVE
very good working knowledge of SQL and ability to write database procedures/functions in database Procedural Language (for example PL/pgSQL, PL/SQL or T-SQL),
experience in optimization of complex database queries/procedures, (knowledge about postgres DB tuning and Postgres DB performance optimization would be an asset),
experience in data integrations across multiple systems/platforms with usage of ETL/ELT tolls ( like Informatica, Oracle Data Integrator, Xplenty, Talend, Pentaho, etc.)
NICE TO HAVE
Good Knowledge of json
Experience in working in SOA (Service oriented architecture) environment
Experience with Oracle (PL/SQL mainly)
Bash scripting in Unix\Linux
Python knowledge
Basic Requirements
Bachelor's degree in computer science (or equivalent experience)
Experience with SQL/relational databases
Experience working with DBMS and ETL tools
Familiarity with Agile approaches to development a plus
Problem-solving and analytical skills
Travel Requirements
None
Relocation Provided
None
Position Type
Experienced
Referral Payment Plan
No
EEO Statement
Motorola Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or belief, sex, sexual orientation, gender identity, national origin, disability, veteran status or any other legally-protected characteristic.
We are proud of our people-first and community-focused culture, empowering every Motorolan to be their most authentic self and to do their best work to deliver on the promise of a safer world. If you’d like to join our team but feel that you don’t quite meet all of the preferred skills, we’d still love to hear why you think you’d be a great addition to our team.
We’re committed to providing an inclusive and accessible recruiting experience for candidates with disabilities, or other physical or mental health conditions. To request an accommodation, please email ohr@motorolasolutions.com.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Business Development and Sales
Industries
Telecommunications
Referrals increase your chances of interviewing at Motorola Solutions by 2x