SQL Developer

Job Description – Blueprism Developer

• Design technical specifications for RPA (Blue Prism) that meets the requirements and handled all the non functional requirements of concurrency, scalability, security requirements, restart and recovery.
• Develops and configures automation processes as per the technical design document to meet the defined requirements. Works on the coding the more complicated automations or reusable components, and delegates and mentors junior developers for the less complex components.
• Develops new processes/tasks/objects using core workflow principles that are efficient, well structured, maintainable and easy to understand.
• Complies with and helps to enforce design and coding standards, policies and procedures.
• Ensures documentation is well maintained.
• Ensures quality of coded components by performing thorough unit testing.
• Works collaboratively with test teams during the Product test and UAT phases to fix assigned bugs with quality.
• Reports status, issues and risks to tech leads on a regular basis
• Improves skills in automation products by completing automation certification.
• Mentors junior developers and performs code reviews for quality control.

Qualifications

Bachelor degree in Engineering / Computer Science

Additional Information

•  5- 8 years of IT experience and having good understanding of programming concepts.  Should be from a programming background on any coding language (.Net, Java).
• Working experience in RPA for a minimum of 2 years and having project experience of a minimum 3 RPA implementations.
• Understands development methodology and lifecycle
• Should be trained on RPA tools (Blue Prism).
• Self-motivated, team player, action and results oriented.
• Well organized, good communication and reporting skills.

Responsibilities:

• Work with product managers to find solutions to critical problems, face internal customers, and create requirements.
• Triage and fix critical issues that arise in the field that affect our core product.
• Manage git repositories, pull requests, and review code.
• Communicate properly & promptly with all stakeholders.
• Build a proof-of-concept for new products from scratch.
• Optimize, clean up, and comment on the existing codebase.

Requirements:

• Must have 5-8 years of hands-on engineering experience.
• Must be an expert in JavaScript/Typescript with ES6+ features, Node.js, ReactJS, and Redux
• Must be an expert in HTML5 CSS3 SASS, and Webpack.
• You are proficient with RESTful API design and implementation using Node.js.0
• Proficiency in relational (MySQL, Cloud Spanner etc. ) and non-relational (MongoDB, Google Cloud Firestore etc. ) databases.
• Must be an expert in data structure and creating highly optimized algorithms.
• Should have a working knowledge of GCP services like App Engine, CloudSQL, Compute Engine etc.
• Should have a working understanding of microservices patterns, serverless design, and event-based architecture.
• Willingness to learn new programming languages, frameworks, and paradigms.

Job Description:

·      Database Design & Development:

• Design, develop, and optimize database structures, tables, views, stored procedures, and functions in MS SQL Server.
• Ensure data integrity, performance tuning, and security of database systems.
• Collaborate with development teams to design and implement database schemas based on application needs.

·      .NET Web API Development:

• Develop and maintain RESTful Web APIs using .NET Core MVC.
• Ensure APIs are secure, scalable, and optimized for performance.
• Collaborate with front-end developers and other stakeholders to integrate APIs with applications.

·      Data Management & Maintenance:

• Perform data migrations, backups, and recovery strategies.
• Monitor and troubleshoot database performance issues, query optimization, and implement best practices for indexing and partitioning.

·      Collaboration & Communication:

• Work closely with business analysts, project managers, and QA teams to understand requirements and deliver solutions.
• Participate in code reviews, provide constructive feedback, and adhere to development standards and best practices.

·      Documentation:

• Create and maintain technical documentation for database structures and APIs.
• 
  

Required Skills and Qualifications:

·      2-3 years of experience in MS SQL Server (2016 or later), including database design, writing complex queries, stored procedures, and performance tuning.

·      Strong experience in developing .NET Web APIs (using .NET Core MVC).

·      Proficiency in C# and understanding of RESTful API principles.

·      Strong experience in Entity Framework for data access.

·      Familiarity with SQL Profiler and other database performance monitoring tools.

·      Basic understanding of front-end technologies (HTML, JavaScript, etc.) is a plus.

·      Strong problem-solving skills, attention to detail, and ability to work independently and in a team environment.

·      

Preferred Qualifications:

·      Experience with Azure SQL Database or other cloud-based database solutions.

·      Understanding of Agile development methodologies.

About Airblack

Airblack is India’s largest online skilling academy, helping people become micro-entrepreneurs or get flexible opportunities through innovative “do-it-together” (DIT) courses.

In three years, Airblack's beauty academy has trained over 35,000 students in 200+ cities as Makeup Artists, helping them start their businesses as freelancers, studio owners, or earning influencers. We have also forayed into hospitality and culinary and helped over 500 bakers launch a baking business with our Certified Professional Baking Course

Airblack is backed by marquee investors such as Info Edge Ventures, Elevation Capital, Michael & Susan Dell Foundation, Blume Founders Fund, Better Capital and Mars Shot Ventures. We have also been recognized by the Beauty & Wellness Sector Skill Council & Skill India as a government-certified beauty skilling partner. Airblack has also been recognized by Forbes as a “Select 200” company with global business potential.

Who are we looking for?

At Airblack, we're entering a path of exponential growth, aiming to grow our revenue tenfold within the next two years while bolstering our profitability. In this pivotal phase, we seek a dynamic Performance Marketer responsible for planning, implementing, and optimizing high-performing advertising campaigns across various online channels, including Google Ads and Meta Ads, to increase company sales and brand awareness. This role requires a combination of analytical, creative, and strategic thinking to develop scalable and efficient campaign structures.

The ideal candidate would be driven by a blend of creative problem-solving and analytical prowess and thrive in a high-ownership environment. If this sounds like you, we would love to meet you.

What would you be doing?

• Performance Marketing: Develop, execute and manage lead acquisition for the Airblack inside-sales team by efficiently planning, executing and scaling up performance marketing campaigns on Facebook, Google and other digital media platforms
• Perform daily account management, check campaign performance, and adjust bids to enhance campaign efficiency.
• Optimize performance across ad channels by testing and tuning ads, keywords, and bid strategies.
• Analytics & Instrumentation: Contribute to the analytics muscle of the Growth function with in-depth data analyses and set-up tech instrumentation to scale operations
• Experimentation & User Insights: Deliver continuous user insights, solutions discovery and experimentations across both 0-to-1 and scale-up revenue initiatives
• Go-To-Market Operations: Execute end-to-end operations on GTM, leads CRM and revenue optimization initiatives.
• Creative Strategy: Be a creative powerhouse in acquisition advertising by ideating and producing best-in-class video and static ad properties, user communications and landing pages
• Cross-Team Collaboration: Work with the Growth, Design, Brand, Tech, Product and Inside-sales functions to advance cross-function revenue and profitability goals.
• Key Ownership: Own key metrics like ROAS, CAC, Lead Conversion % and Revenue

What makes you a suitable candidate?

We would love to hear from you if you meet the qualifications below:

• Experience: 1+ years in digital performance marketing with a high-growth startup preferably in the education / ed-tech space
• Understanding of custom audiences and lookalike audiences.
• Ability to generate and install the Facebook pixel, and Google Analytics.
• Strong understanding of bidding techniques (AutoBid, CPC, CPM, oCPM)
• Expertise in creating ads and ad copies.
• Education: A bachelor's degree in any discipline is required from a tier 1 college
• You have managed upwards of 20 Lakhs in ad spending
• You are a marketing geek and can come up with creative ideas at scale
• You are thoroughly data-driven in decision-making; with good Excel skills. Experience in SQL is a bonus!
• You have a proven track record of taking high ownership and willingness to execute hands-on when needed
• You have a knack for driving 0-to-1 rapid experimentation initiatives and 1-100 standardized operational initiatives

Why should you join Airblack?

• Empowering Entrepreneurs: We cultivate a culture of entrepreneurship where individuals are employees and owners of their work.
• Experimentation & Build: Our Growth team fosters a culture of rapid experimentation, freedom to fail & iterate, and owning scale-up through process building.
• Unrestricted Autonomy: When confronted with a challenge, you have the authority to take charge, exhibiting determination and resilience to overcome obstacles and ultimately succeed.
• Drive for Success: Embrace challenges head-on, applying your skills and expertise to accomplish tasks precisely and excellently.
• Thriving Market Opportunity: Join us on an exhilarating journey as we pioneer India's inaugural platform for passion skills, offering a unique and vibrant market to shape and build upon.
• Work with a stellar team: Great missions require great people - and we are fortunate to have some of the smartest and nicest people support us in our journey. Our team comprises ex-entrepreneurs, VCs, and operators from places such as Goldman Sachs, Paytm, Oyo, Bain & Co., BCG, Urban Company, top IITs and universities such as DU and NIFT.

• Bachelor’s or Master’s degree in Computer Science or Engineering, 
• 4-8 years of hands-on Experience in React native js  
• Develop Hybrid Apps using React Native and integrate them with back-end services.
• Navigation model in Mobile apps.
• Minimum 3yrs of exp in building React native apps for android and iOS Solid understanding of iOS and Android ecosystems.
• Must have worked on hardware integration with the apps.
• Understanding of various navigation models in mobile apps Good at debugging, testing, performance optimization.
• Interpersonal skills: good team player, ready to take challenges ability to deliver in a fast-paced environment
• Able to build and maintain awesome react native applications with good code quality
• Implement pixel-perfect UI's that match designs.
• Work with native modules when required.
• Have developed at least 1 iOS/Android app which has been deployed in both Appstore and Google Play
• Excellent understanding of solid coding skills in React Native)
• Have a good understanding of REST APIs
• Good Communication

• Hands on  of developer or tester role on  guidewire suite
• Working through backlog with minimal supervision
• Develop/test on guidewire components, integration components , guidewire batches, policy enter, claim enter, API plug-ins, messaging and workflows
• Experience working in agile teams
• Able to contribute towards better quality outcomes
• Java experience desirable
• Database experience
• Excellent communication skills