Social Media Specialist

Responsibilities:  

∙ Database Administration (PostgreSQL): 

∙ Oversee the installation, configuration, and maintenance of PostgreSQL database systems. 

∙ Monitor database performance, conduct performance tuning, and optimize SQL queries for efficiency. 

∙ Implement and maintain database security measures, including user access controls, data encryption, and 

backup and recovery strategies. 

∙ Troubleshoot database issues, diagnose and resolve database-related problems, and ensure system 

reliability and uptime. 

∙ Plan and execute database upgrades, patches, and migrations, ensuring minimal downtime and data 

integrity. 

∙ Implement database replication, clustering, and high availability solutions for disaster recovery and 

failover. 

∙ Database Development: 

∙ Develop and maintain database scripts, stored procedures, functions, triggers, and other database objects 

to support application development and data processing requirements. 

∙ Design and implement data models, database schemas, and indexing strategies to optimize database 

performance and support application functionality. 

∙ Perform data conversion and migration tasks, including data cleansing, transformation, and loading 

(ETL) processes, ensuring data integrity and consistency. 

∙ Collaborate with software developers, architects, and business stakeholders to understand database 

requirements and provide database solutions that meet business needs. 

∙ Conduct code reviews, performance analysis, and database optimization to ensure adherence to best 

practices and standards. 

∙ Document database designs, processes, and procedures, and provide training and knowledge transfer to 

junior team members. 

∙ SQL Query Optimization: 

∙ Write and optimize complex SQL queries, stored procedures, and database views to retrieve and 

manipulate data efficiently. 

∙ Analyze query execution plans, identify performance bottlenecks, and implement optimizations to 

improve query performance. 

∙ Utilize database performance monitoring tools and profiling techniques to identify and resolve 

performance issues. 

Company Profile 

App Innovation Technologies is leader in Mobile and Web based solutions development. With our extensive knowledge of this industry, our customers receive the edge needed to make their projects a true success. Our team of developers, analysts, designers, testers and project managers will complete projects on time to the agreed specifications with Mobile, Social, Cloud and Analytics’ expertise. 

We also provide a caravan of web-based products and Software services. AIT is a reputed web/Software development company with its headquarters based at Coimbatore, India. We have a creative team of skilled professionals who have in depth knowledge in various technologies including open source technologies and Microsoft technologies to service our valuable clients. Please visit our website https://www.aitechindia.com for more details.

Job Description

We are looking for an iOS developer responsible for the development and maintenance of applications aimed at a range of iOS devices including mobile phones and tablet computers. Your primary focus will be development of iOS applications and their integration with back-end services. You will be working alongside other engineers and developers working on different layers of the infrastructure. Therefore, a commitment to collaborative problem solving, sophisticated design, and the creation of quality products is essential.

Responsibilities:

• Design and build applications for the iOS platform

• Ensure the performance, quality, and responsiveness of applications

• Collaborate with a team to define, design, and ship new features

• Identify and correct bottlenecks and fix bugs

• Help maintain code quality, organization, and automatization

Skills 

• Proficient with Objective-C or Swift.

• Familiarity with RESTful APIs to connect iOS applications to back-end services

• Knowledge of other web technologies and UI/UX standards

• Understanding of Apple’s design principles and interface guidelines

• Knowledge of low-level C-based libraries is preferred

• Familiarity with cloud message APIs and push notifications

• Knack for benchmarking and optimization

• Proficient understanding of code versioning tools (such as Git, Mercurial or SVN)

• Familiarity with continuous integration

Education Qualification:

• Undergraduate in Engineering related to Computer Science and Information Technologies and Postgraduate in Computer Science 

• Shouldn’t have Backlog or Arrear.

• Must have completed at least 3 month course. 

• Should be an Analytical thinker and Self Motivator 

⚡ About DrinkPrime

We're DrinkPrime, a startup based in Bengaluru that's all about making clean, safe, and healthy drinking water accessible to everyone. We provide cutting-edge IoT-enabled customized water purifiers on a subscription basis, and we currently serve more than one lakh users across Bengaluru, Delhi NCR, and Hyderabad. We're not just another boring water purifier manufacturing company - we're a forward-thinking drinking water solution provider that speaks directly to our target audience, and this has earned us the support of some big VCs like Sequoia in the industry. We're looking for awesome tech professionals who want to join us in creating history and making a real difference. So why not come and be a part of our journey towards a better future?

💼 Role & Responsibilities

At DrinkPrime, we have a vision of disrupting the water industry. We believe that technology has a key role to play by providing a highly scalable platform that can seamlessly connect and control millions of devices. We are looking for people who are technically excellent and, at the same time, enjoy the excitement and unpredictability of working in a startup environment. You will have a great opportunity to be part of the core technology team.

We are a well-funded high-growth startup currently operating in Bangalore and have a great open environment. We're currently in hybrid mode and would prefer our employees to be located in Bangalore after joining.

• Collaborate with the development team to design and develop high-quality iOS applications.
• Assist in the entire application lifecycle, including concept, design, build, deploy, test, and release.
• Write clean and maintainable code following best practices and coding standards.
• Contribute ideas and solutions to improve the overall quality and user experience of iOS applications.
• Troubleshoot and resolve application defects and issues reported by users or internal stakeholders.

Our ideal candidate would be someone who has at least 2-4 years of hands-on knowledge of iOS app development. Experience in working with IOT devices and handling native connectivity functionality like bluetooth and Wifi is plus.

·        Prepare and manage project plans (project, release, sprint) with clear achievable milestones

·        Identify risks and dependencies for the projects he manages.

·        Ensure the project is implemented on time within contractual obligations.

·        Responsible for scope management and change management.

·        Follow-up with customers to resolve any dependencies and help manage issues/bottlenecks in implementation.

·        Conduct regular project review meetings.

·        Be an escalation point for implementation team to coordinate with various partners to eliminate any bottlenecks or mitigate any risks.

·        Communicate status to senior management and customers regularly.

·        Should have the ability to manage multiple projects in parallel for various customers.

·        Able to identify impact on project plan due to new changes coming up during the project execution.

·        Interface with customers and understand functional requirements and objectives

·        Working closely with customer’s / business analysts / technical architects for ensuring that right design and architecture is agreed up on for the projects.

·        Escalate issues to senior management or customer if required appropriately

·        Able to influence and implement the best practices of Agile across project teams

·        Ensure compliance with development standards, development process and the documentation requirements.

·        Continuous learning to keep abreast with developments in technology.

·        Provide guidance on functional and technical matters to all the members in the team, if required take support from external team members.

·        Participate in presentations and demonstrations of the software to customers.

·        Identify training needs for the project team to improve productivity and quality of delivery

·        Build a strong team to manage and execute the projects

·        Work with team continuously to resolve conflicts or roadblocks they have to accomplish their tasks

·        Have a periodic 1 x 1 discussion with the team members provide support where required and nominate team/peer for their achievements

·        Understand employee grievances and take initiatives to address and resolve them

·        Participate in any proposal activities as part of pre-sales activities

·        Develops excellent customer relationship and delivers great customer satisfaction

·        Displays good subject matter and technical expertise

·        Displays good people management skills

·        Retention of the key team members with high motivation

·        Demonstrates ability to follow the existing processes and strives to improve and adapt to new processes

·        Show great productivity and excellent quality deliverables.

·        Provides excellent managerial and technical leadership to the team

College: IIT, NIT, BITs other Tier 1 colleges  

   Priority skills:  Kotlin, MVP, MVVM, especially Viper, Unit & UI Test, Firebase, Google maps, design patterns, GIT

Responsibilities ( Experience 8-10 years)

    Design and development of apps for Android in Kotlin and JAVA
    Follow Google user interface guidelines and principles of material design
    Ensure performance and maintainability of the apps
    Code review and guidance to other team members to make sure code quality is as desired.
    Researching new frameworks and adapting the best of them in app development.

Skills Required

    Expert knowledge of Kotlin and JAVA
    Expert knowledge of Architectural patterns like MVC, MVVM and Clean Architecture.
    Expert understanding of Android run time model
    Experience with offline caching, threading and task management.
    Experience with object oriented design patterns.
    Experience with push notifications and Firebase or other similar PaaS systems.
    An Eye for design details, following pixel perfect designs.
    Experience with 3rd party libraries like okhttp, volley , Soket.io, Realm, Firebase, Facebook, Twitter, Instagram, RX Kotlin/JAVA.
    Team management skills.

The 10BedICU team within eGovernments Foundation works as a small distributed start-up in the NGO space. We are a technology oriented team on the journey to make critical healthcare more accessible across the country. 

As a banckend dev in the team, you will be working on some of the most interesting challenges and collaborating with telented and highly skilled individuals across the industry. 

Introduction

We are looking to empanel a Public Relations (PR) Specialist to lead and execute public relations strategy and campaigns for our clients. We work with exciting brands and organizations that we have fallen hopelessly in love with. To these partnerships, we bring truckloads of passion and oodles of weirdness. To top it all off, we ensure everything we do is meaningful.

We are looking for teammates who are:

• As 'weird' as possible - someone who is itching to change the status quo, to take risks, to build a story that everyone talks about, and to make everyone sit up and take notice
• Always keeping an eye out for never compromising on 'meaningfulness' - every campaign, every strategy, every creative idea should never be superficial beyond a degree and should work towards genuinely and meaningfully connecting with audiences

“Weird + Meaningful” is our core belief, and we are craving to find people who really get it. You can know more about this in this https://www.youtube.com/watch?v=OcIGKxsDVpY">Ted talk by our founder

Responsibilities

• Responding to requests for information release or press conference from the media or designating a spokesperson or source of information
• Establishing and maintaining relationships with media - print and digital, mainstream and new-age
• Identify and build a relevant network in the media on a rolling basis (from newspapers to podcasts to Instagram news handles etc.)
• Coordinating and reviewing press releases, authored articles, guest articles, interviews, industry stories, and other media communications to promote clients
• Strategizing and advising on potential pitches and stories to maintain favorable public and stakeholder views of the organization's agenda and accomplishments

Coaching client representatives in effective communication with the public and employees

• Studying the organization's objectives, promotional policies, and needs to build public relations strategies that influence public opinion and promote products, ideas, and services
• Identify trends and interests and provide advice on communication strategies

Knowledge & Skills

• Proven relevant work experience of at least 2-3 years
• Bachelor’s degree in journalism, PR, marketing, or related field.
• Experience handling a press conference.
• Excellent written and verbal communication skills.
• Ability to pitch to the media.
• Knowledge of consumer marketing.
• An ability to work on big strategic plans as well as day-to-day tasks.
• Ability to think both creatively and strategically.
• Ability to run PR campaigns that deliver measurable results and meet objectives.
• Curious, deadline-oriented, with excellent follow-up and reporting skills.
• Creativity in securing coverage and buzz with traditional and new-age outlets.
• Project and budget management skills.
• Responds well under pressure with a strict time limit.
• Quick and enthusiastic learner.

• Key responsibility is to design and develop a data pipeline including the architecture, prototyping, and development of data extraction, transformation/processing, cleansing/standardizing, and loading in Data Warehouse at real-time/near the real-time frequency. Source data can be structured, semi-structured, and/or unstructured format.
• Provide technical expertise to design efficient data ingestion solutions to consolidate data from RDBMS, APIs, Messaging queues, weblogs, images, audios, documents, etc of  Enterprise Applications, SAAS applications, external 3rd party sites or APIs, etc through ETL/ELT, API integrations, Change Data Capture, Robotic Process Automation, Custom Python/Java Coding, etc
• Development of complex data transformation using Talend (BigData edition), Python/Java transformation in Talend, SQL/Python/Java UDXs, AWS S3, etc to load in OLAP Data Warehouse in Structured/Semi-structured form
• Development of data model and creating transformation logic to populate models for faster data consumption with simple SQL.
• Implementing automated Audit & Quality assurance checks in Data Pipeline
• Document & maintain data lineage to enable data governance
• Coordination with BIU, IT, and other stakeholders to provide best-in-class data pipeline solutions, exposing data via APIs, loading in down streams, No-SQL Databases, etc

Requirements

• Programming experience using Python / Java, to create functions / UDX
• Extensive technical experience with SQL on RDBMS (Oracle/MySQL/Postgresql etc) including code optimization techniques
• Strong ETL/ELT skillset using Talend BigData Edition. Experience in Talend CDC & MDM functionality will be an advantage.
• Experience & expertise in implementing complex data pipelines, including semi-structured & unstructured data processing
• Expertise to design efficient data ingestion solutions to consolidate data from RDBMS, APIs, Messaging queues, weblogs, images, audios, documents, etc of  Enterprise Applications, SAAS applications, external 3rd party sites or APIs, etc through ETL/ELT, API integrations, Change Data Capture, Robotic Process Automation, Custom Python/Java Coding, etc
• Good understanding & working experience in OLAP Data Warehousing solutions (Redshift, Synapse, Snowflake, Teradata, Vertica, etc) and cloud-native Data Lake (S3, ADLS, BigQuery, etc) solutions
• Familiarity with AWS tool stack for Storage & Processing. Able to recommend the right tools/solutions available to address a technical problem
• Good knowledge of database performance and tuning, troubleshooting, query optimization, and tuning
• Good analytical skills with the ability to synthesize data to design and deliver meaningful information
• Good knowledge of Design, Development & Performance tuning of 3NF/Flat/Hybrid Data Model
• Know-how on any No-SQL DB (DynamoDB, MongoDB, CosmosDB, etc) will be an advantage.
• Ability to understand business functionality, processes, and flows
• Good combination of technical and interpersonal skills with strong written and verbal communication; detail-oriented with the ability to work independently

Functional knowledge

• Data Governance & Quality Assurance
• Distributed computing
• Linux
• Data structures and algorithm
• Unstructured Data Processing