Social Media Marketer, Social Media Intern

Advanced SQL, data modeling skills - designing Dimensional Layer, 3NF, denormalized views & semantic layer, Expertise in GCP services

Role & Responsibilities:

● Design and implement robust semantic layers for data systems on Google Cloud Platform (GCP)

● Develop and maintain complex data models, including dimensional models, 3NF structures, and denormalized views

● Write and optimize advanced SQL queries for data extraction, transformation, and analysis

● Utilize GCP services to create scalable and efficient data architectures

● Collaborate with cross-functional teams to translate business requirements(specified in mapping sheets or Legacy

Datastage jobs) into effective data models

● Implement and maintain data warehouses and data lakes on GCP

● Design and optimize ETL/ELT processes for large-scale data integration

● Ensure data quality, consistency, and integrity across all data models and semantic layers

● Develop and maintain documentation for data models, semantic layers, and data flows

● Participate in code reviews and implement best practices for data modeling and database design

● Optimize database performance and query execution on GCP

● Provide technical guidance and mentorship to junior team members

● Stay updated with the latest trends and advancements in data modeling, GCP services, and big data technologies

● Collaborate with data scientists and analysts to enable efficient data access and analysis

● Implement data governance and security measures within the semantic layer and data model

We are looking for a Java Developer with minimum 3 to 8 years of experience.

Responsibilities and Duties:

• Java/Java EE application development while providing expertise in the full software development life cycle, from concept and design to testing.
• Contribute to all phases of the development life cycle
• Write well-designed, testable, efficient code
• Ensure designs comply with specifications
• Prepare and produce releases of software components
• Support continuous improvement by investigating alternatives and technologies and presenting these for architectural review

• Pixuate is a deep-tech AI start-up enabling businesses make smarter decisions with our edge-based video analytics platform and offer innovative solutions across traffic management, industrial digital transformation, and smart surveillance. We aim to serve enterprises globally as a preferred partner for digitization of visual information.

  Job Description

  We at Pixuate are looking for highly motivated and talented Senior DevOps Engineers to support building the next generation, innovative, deep-tech AI based products. If you are someone who has a passion for building a great software, has analytical mindset and enjoys solving complex problems, thrives in a challenging environment, self-driven, constantly exploring & learning new technologies, have ability to succeed on one’s own merits and fast-track your career growth we would love to talk!

  What do we expect from this role?

  • This role’s key area of focus is to co-ordinate and manage the product from development through deployment, working with rest of the engineering team to ensure smooth functioning.
  • Work closely with the Head of Engineering in building out the infrastructure required to deploy, monitor and scale the services and systems.
  • Act as the technical expert, innovator, and strategic thought leader within the Cloud Native Development, DevOps and CI/CD pipeline technology engineering discipline.
  • Should be able to understand how technology works and how various structures fall in place, with a high-level understanding of working with various operating systems and their implications.
  • Troubleshoots basic software or DevOps stack issues

  You would be great at this job, if you have below mentioned competencies

  • Tech /M.Tech/MCA/ BSc / MSc/ BCA preferably in Computer Science
  • 5+ years of relevant work experience
  • https://www.edureka.co/blog/devops-skills#knowledge">Knowledge on Various DevOps Tools and Technologies
  • Should have worked on tools like Docker, Kubernetes, Ansible in a production environment for data intensive systems.
  • Experience in developing https://www.edureka.co/blog/continuous-delivery/">Continuous Integration/ Continuous Delivery pipelines (CI/ CD) preferably using Jenkins, scripting (Shell / Python) and https://www.edureka.co/blog/what-is-git/">Git and Git workflows
  • Experience implementing role based security, including AD integration, security policies, and auditing in a Linux/Hadoop/AWS environment.
  • Experience with the design and implementation of big data backup/recovery solutions.
  • Strong Linux fundamentals and scripting; experience as Linux Admin is good to have.
  • Working knowledge in Python is a plus
  • Working knowledge of TCP/IP networking, SMTP, HTTP, load-balancers (ELB, HAProxy) and high availability architecture is a plus
  • Strong interpersonal and communication skills
  • Proven ability to complete projects according to outlined scope and timeline
  • Willingness to travel within India and internationally whenever required
  • Demonstrated leadership qualities in past roles

  More about Pixuate:

  Pixuate, owned by Cocoslabs Innovative Solutions Pvt. Ltd., is a leading AI startup building the most advanced Edge-based video analytics products. We are recognized for our cutting-edge R&D in deep learning, computer vision and AI and we are solving some of the most challenging problems faced by enterprises. Pixuate’s plug-and-play platform revolutionizes monitoring, compliance to safety, and efficiency improvement for Industries, Banks & Enterprises by providing actionable real-time insights leveraging CCTV cameras.

  We have enabled our customers such as Hindustan Unilever, Godrej, Secuira, L&T, Bigbasket, Microlabs, Karnataka Bank etc and rapidly expanding our business to cater to the needs of Manufacturing & Logistics, Oil and Gas sector.

  Rewards & Recognitions:

  • Winner of Elevate by Startup Karnataka (https://pixuate.ai/thermal-analytics/">https://pixuate.ai/thermal-analytics/).
  • Winner of Manufacturing Innovation Challenge in the 2nd edition of Fusion 4.0’s MIC2020 organized by the NASSCOM Centre of Excellence in IoT & AI in 2021
  • Winner of SASACT program organized by MEITY in 2021

  Why join us?

  You will get an opportunity to work with the founders and be part of 0 to 1 journey& get coached and guided. You will also get an opportunity to excel your skills by being innovative and contributing to the area of your personal interest. Our culture encourages innovation, freedom and rewards high performers with faster growth and recognition.   

  Where to find us?

  Website: http://pixuate.com/">http://pixuate.com/                            

  Linked in: https://www.linkedin.com/company/pixuate-ai     

   

  Place of Work:

  Work from Office – Bengaluru

Desired Candidate Profile

• A Bachelor’s degree in Business or related field or an MBA
• A minimum of 3 years’ experience in business analysis or a related field
• Exceptional analytical and conceptual thinking skills
• The ability to influence stakeholders and work closely with them to determine acceptable solutions
• Excellent documentation skills
• Fundamental analytical and conceptual thinking skills
• Experience creating detailed reports and giving presentations
• Competency in Microsoft applications including Word, Excel, PowerPoint and Outlook
• Excellent planning, organizational and time management skills

• Develop reusable, maintainable cross-platform HTML, CSS, and JavaScript for front-end web application components while adhering to web and team standards.
• Write unit tests to provide sufficient testing coverage for each developed component.
• Constantly review and improve frontend performance of the web application.
• Work with creative and business partners to understand, build and adjust web application functionality and visual presentation to support business goals.
• Work with server-side, infrastructure, and 3rd party technology partners to build, integrate and deploy web application functionality and visual presentation to support business goals.
• Work with project technical lead and/or FE architect to create technical designs and implementation plans.
• Ensure accuracy and attention to detail throughout the development process.
• Remain curious and current with new developments in the FE web development industry.

QUALIFICATIONS:

• Demonstrated 3-5 years of practical front-end web development experience.
• Expertise in writing and testing valid, web standards-based HTML, CSS, JS.
• Fluent in fundamentals of computer science such as:
• Object-Oriented Programming, Data Structures, Coding Patterns.
• Deep understanding and experience with the following standards and technologies is essential:
• DOM, JSON, AJAX, HTML5 Video, WCAG 2.0 AA, Git.
• Strong verbal and written communication skills are preferred.
• Bachelor’s Degree is preferred.
• Sample portfolio (code or public-facing web build) is a plus.
• Experience working for high-end brands or another environment with very high standards for the presentation layer is a plus; Ecommerce experience is a plus

Our currently digital strategy is very aggressive towards developing user centric websites in our industry to reach different cohorts. Apply if you believe you're a good fit for the task.

Your day-to-day responsibilities include:

1. Working on building the design on Webflow or WordPress using builders, like Elementor, Divi, Visual Composer, Beaver, Oxygen, Brizy, WPBakery, etc.

2. Working on designing the landing page and building it on WordPress or Webflow