SQL Developer

KEY RESPONSIBILITIES

• Building a website based on the given requirements and ensure it’s successfully deployed
• Responsible for designing, planning, and testing new web pages and site features
• A propensity for brainstorming and coming up with solutions to open-ended problems
• Work closely with other teams, and project managers, to understand all stakeholders’ requirements and ensure that all specifications and requirements are met in final development
• Troubleshoot and solve problems related to website functionality
• Takes ownership of initiatives and drives them to completion.
• Desire to learn and dive deep into new technologies on the job, especially around modern data storage and streaming open source systems
• Responsible for creating, optimizing, and managing REST APIs
• Create website content and enhance website usability and visibility
• Ensure cross-browser compatibility and testing for mobile responsiveness
• Ability to integrate payment processing and search functionality software solutions
• Stay up-to-date with technological advancements and the latest coding practices
• Collaborate with the team of designers, content managers, and developers to determine site goals, functionality, and layout
• Monitor website traffic and overall system’s health with Google analytics to ensure high GTmetrix score
• Build the front-end of applications through appealing visual design
• Design client-side and server-side architecture
• Develop server-side logic and APIs that integrate with front-end applications.
• Architect and design complex database structures and data models.
• Develop and implement backend systems to support scalable and high-performance web applications.
• Create automated tests to ensure system stability and performance.
• Ensure security and data privacy measures are maintained throughout the development process.
• Maintain an up-to-date changelog for all new, updated, and fixed changes.
• Ability to document and manage all the software design, requirements, reusable & transferable code, and other technical aspects of the project.
• Create and convert storyboards and wireframes into high-quality full-stack code
• Write, execute, and maintain clean, reusable, and scalable code
• Design and implement low-latency, high-availability, and performant applications
• Implement security and data protection
• Ensure code that is platform and device-agnostic

EDUCATION & SKILLS REQUIREMENT

• B.Tech. / BE / MS degree in Computer Science or Information Technology
• Expertise in MERN stack (MongoDB, Express.js, React.js, Node.js)
• Should have prior working experience of at least 3 years as web developer or full stack developer
• Should have done projects in e-commerce or have preferably worked with companies operating in e-commerce
• Should have expert-level knowledge in implementing frontend technologies
• Should have worked in creating backend and have deep understanding of frameworks
• Experience in the complete product development life cycle
• Hands-on experience with JavaScript, HTML, CSS, JQuery, JSON, PHP, XML
• Proficiency in databases, including analytical (e.g., mySQL, MongoDB, PostgreSQL, DynamoDB, Redis, Hive, Elastic etc.)
• Knowledge of architecting or implementing search APIs
• Great understanding of data modeling and RESTful APIs
• Strong knowledge of CS fundamentals, data structures, algorithms, and design patterns
• Strong analytical, consultative, and communication skills
• Excellent understanding of Microsoft office tools : excel, word, powerpoint etc.
• Excellent organizational and time management skills
• Experience with responsive and adaptive design (Web, Mobile & App)
• Should be a self starter and have ability to work without being supervised
• Excellent debugging and optimization skills
• Experience building high throughput/low latency systems.
• Knowledge of big data systems such as Cassandra, Elastic, Kafka, Kubernetes, and Docker
• Should be willing to be a part of a small team and working in fast-paced environment
• Should be highly passionate about building products that create a significant impact.
• Should have experience in user experience design, website optimization techniques and different PIM tools

Experience - 2 to 6 Years

Work Location - Pune

Datametica is looking for talented SQL engineers who would get training & the opportunity to work on Cloud and Big Data Analytics.

Mandatory Skills:

• Strong in SQL development
• Hands-on at least one scripting language - preferably shell scripting
• Development experience in Data warehouse projects

Opportunities:

• Selected candidates will be provided learning opportunities on one or more of the following: Google Cloud, AWS, DevOps Tools, Big Data technologies like Hadoop, Pig, Hive, Spark, Sqoop, Flume, and KafkaWould get a chance to be part of the enterprise-grade implementation of Cloud and Big Data systems
• Will play an active role in setting up the Modern data platform based on Cloud and Big Data
• Would be part of teams with rich experience in various aspects of distributed systems and computing

• Bachelor’s degree in Computer / Information Science (BE / BTech) or Master’s in Computer Applications (MCA) Experience:
• Two to five years general software engineering experience
• Experience in web development using the Ruby on Rails web application framework
• At least two years of Ruby on Rails programming experience
• Thorough understanding of the philosophy and design of Ruby on Rails
• Desktop publishing skills: HTML5, xHTML, CSS

Knowledge of:

• JavaScript and JavaScript libraries: jQuery, Plugins etc.
• Unix and Linux systems
• Relational databases: SQL, etc.
• Frameworks: Active record, etc.
• Servers: Nginx, Mongrel, Webrick
• Performance management using New Relic, Web Page Test tools
• SEO rules, minification, rails asset pipelines
• REST APIs and their usage

Highly preferred experience:

• Ability to work with the Amazon EC2, S3, and EBS services
• NoSQL databases: MongoDB, Memcached, CouchDB
• Git, SVN
• Proactive and resourceful person who achieves tasks with minimal oversight
• Team player with the ability and desire to become an integral part of a fast-paced team
• Ability to handle multiple tasks in parallel