Business Development Executive / Manager

Job Summary:

Seeking a seasoned SQL + ETL Developer with 4+ years of experience in managing large-scale datasets and cloud-based data pipelines. The ideal candidate is hands-on with MySQL, PySpark, AWS Glue, and ETL workflows, with proven expertise in AWS migration and performance optimization.

Key Responsibilities:

• Develop and optimize complex SQL queries and stored procedures to handle large datasets (100+ million records).
• Build and maintain scalable ETL pipelines using AWS Glue and PySpark.
• Work on data migration tasks in AWS environments.
• Monitor and improve database performance; automate key performance indicators and reports.
• Collaborate with cross-functional teams to support data integration and delivery requirements.
• Write shell scripts for automation and manage ETL jobs efficiently.

Required Skills:

• Strong experience with MySQL, complex SQL queries, and stored procedures.
• Hands-on experience with AWS Glue, PySpark, and ETL processes.
• Good understanding of AWS ecosystem and migration strategies.
• Proficiency in shell scripting.
• Strong communication and collaboration skills.

Nice to Have:

• Working knowledge of Python.
• Experience with AWS RDS.

• Experience : 5-10 yrs
•  Past experience in working with any product start-up is a plus.
•  Proficiency in fundamental front end languages such as HTML, CSS, and JavaScript.
•  Familiarity with JavaScript frameworks such as Angular JS, React, and others.
•  Knowledge of Node.js and frameworks available for it such as Express (recommended).
•  Good understanding of asynchronous request handling, partial page updates, and AJAX
•  Understanding of REST Services.
•  Experience with Redis.
•  Familiarity with database technology such as MySQL, MongoDB and Elasticsearch.
•  Proficient understanding of serverless programming.
•  Proficient understanding of code versioning tools, such as Git.
•  Good problem-solving skills.
•  Attention to detail.

The Technical Project Manager is responsible for managing projects to make sure the proposed plan adheres to the timeline, budget, and scope. Their duties include planning projects in detail, setting schedules for all stakeholders, and executing each step of the project for our proprietary product, with some of the World’s biggest brands across the BFSI domain. The role is cross-functional and requires the individual to own and push through projects that touch upon business, operations, technology, marketing, and client experience. 

• 5-7 years of experience in technical project management.

• Professional Project Management Certification from accredited intuition is mandatory.

• Proven experience overseeing all elements of the project/product lifecycle.

• Working knowledge of Agile and Waterfall methodologies.

• Prior experience in Fintech, Blockchain, and/or BFSI domain will be an added advantage.

• Demonstrated understanding of Project Management processes, strategies, and methods.

• Strong sense of personal accountability regarding decision-making and supervising department team.

• Collaborate with cross-functional teams and stakeholders to define project requirements and scope.

Position: Site Reliability Engineer

Location: Pune (Currently WFH, post pandemic you need to relocate)

About the Organization:

A funded product development company, headquarter in Singapore and offices in Australia, United States, Germany, United Kingdom, and India. You will gain work experience in a global environment.

Job Description:

We are looking for an experienced DevOps / Site Reliability engineer to join our team and be instrumental in taking our products to the next level.

In this role, you will be working on bleeding edge hybrid cloud / on-premise infrastructure handing billions of events and terabytes of data a day.

You will be responsible for working closely with various engineering teams to design, build and maintain a globally distributed infrastructure footprint.

As part of role, you will be responsible for researching new technologies, managing a large fleet of active services and their underlying servers, automating the deployment, monitoring and scaling of components and optimizing the infrastructure for cost and performance.

Day-to-day responsibilities

• Ensure the operational integrity of the global infrastructure
• Design repeatable continuous integration and delivery systems
• Test and measure new methods, applications and frameworks
• Analyze and leverage various AWS-native functionality
• Support and build out an on-premise data center footprint
• Provide support and diagnose issues to other teams related to our infrastructure
• Participate in 24/7 on-call rotation (If Required)

• Expert-level administrator of Linux-based systems
• Experience managing distributed data platforms (Kafka, Spark, Cassandra, etc) Aerospike experience is a plus.
• Experience with production deployments of Kubernetes Cluster
• Experience in automating provisioning and managing Hybrid-Cloud infrastructure (AWS, GCP and On-Prem) at scale.
• Knowledge of monitoring platform (Prometheus, Grafana, Graphite).
• Experience in Distributed storage systems such as Ceph or GlusterFS.
• Experience in virtualisation with KVM, Ovirt and OpenStack.
• Hands-on experience with configuration management systems such as Terraform and Ansible
• Bash and Python Scripting Expertise
• Network troubleshooting experience (TCP, DNS, IPv6 and tcpdump)
• Experience with continuous delivery systems (Jenkins, Gitlab, BitBucket, Docker)
• Experience managing hundreds to thousands of servers globally
• Enjoy automating tasks, rather than repeating them
• Capable of estimating costs of various approaches, and finding simple and inexpensive solutions to complex problems
• Strong verbal and written communication skills
• Ability to adapt to a rapidly changing environment
• Comfortable collaborating and supporting a diverse team of engineers
• Ability to troubleshoot problems in complex systems
• Flexible working hours and ability to participate in 24/7 on call support with other team members whenever required.

Job description

Overall 3 - 7 years of development experience and a minimum of 3+ years experience as a UI Developer with angular building responsive web applications.

Deep knowledge and working experience on Angular 7/8 projects.
Experience in Data Structures & Spring Boot.

Hands on and implements complex Angular 8 applications, directives, controllers,

services Knowledge and understanding of complex AngularJS applications, directives,

controllers, services and ability to create custom components.

Knowledge and experience of REST API integration.

Skills in one or more chosen frameworks/libraries like JQuery or Bootstrap

AJAX (Asynchronous JavaScript and XML)

Creating configuration, build, and test scripts for Continuous Integration environments

Experience in JavaScript build tools like grunt or gulp Good communication and time-management skills

• Communicate information in a concise and professional manner whether in a verbal, written or visual context
• Writing tested, idiomatic, and documented JavaScript, HTML5 and CSS3

Hands on experience in Angular 7/8 is a must

Desired Key Skills:

4+ years of experience in building scalable web apps using Angular

(versions 4 and above)

Must have a good understanding of how component based web

development works.

Must Have:

Good understanding of Core Angular concepts.

Should be comfortable in writing HTML and CSS

Should be proficient in JavaScript.

Note: Immediate Joiners Only (Within 15 Days)

1. Data Steward :

Data Steward will collaborate and work closely within the group software engineering and business division. Data Steward has overall accountability for the group's / Divisions overall data and reporting posture by responsibly managing data assets, data lineage, and data access, supporting sound data analysis. This role requires focus on data strategy, execution, and support for projects, programs, application enhancements, and production data fixes. Makes well-thought-out decisions on complex or ambiguous data issues and establishes the data stewardship and information management strategy and direction for the group. Effectively communicates to individuals at various levels of the technical and business communities. This individual will become part of the corporate Data Quality and Data management/entity resolution team supporting various systems across the board.

Primary Responsibilities:

• Responsible for data quality and data accuracy across all group/division delivery initiatives.
• Responsible for data analysis, data profiling, data modeling, and data mapping capabilities.
• Responsible for reviewing and governing data queries and DML.
• Accountable for the assessment, delivery, quality, accuracy, and tracking of any production data fixes.
• Accountable for the performance, quality, and alignment to requirements for all data query design and development.
• Responsible for defining standards and best practices for data analysis, modeling, and queries.
• Responsible for understanding end-to-end data flows and identifying data dependencies in support of delivery, release, and change management.
• Responsible for the development and maintenance of an enterprise data dictionary that is aligned to data assets and the business glossary for the group responsible for the definition and maintenance of the group's data landscape including overlays with the technology landscape, end-to-end data flow/transformations, and data lineage.
• Responsible for rationalizing the group's reporting posture through the definition and maintenance of a reporting strategy and roadmap.
• Partners with the data governance team to ensure data solutions adhere to the organization’s data principles and guidelines.
• Owns group's data assets including reports, data warehouse, etc.
• Understand customer business use cases and be able to translate them to technical specifications and vision on how to implement a solution.
• Accountable for defining the performance tuning needs for all group data assets and managing the implementation of those requirements within the context of group initiatives as well as steady-state production.
• Partners with others in test data management and masking strategies and the creation of a reusable test data repository.
• Responsible for solving data-related issues and communicating resolutions with other solution domains.
• Actively and consistently support all efforts to simplify and enhance the Clinical Trial Predication use cases.
• Apply knowledge in analytic and statistical algorithms to help customers explore methods to improve their business.
• Contribute toward analytical research projects through all stages including concept formulation, determination of appropriate statistical methodology, data manipulation, research evaluation, and final research report.
• Visualize and report data findings creatively in a variety of visual formats that appropriately provide insight to the stakeholders.
• Achieve defined project goals within customer deadlines; proactively communicate status and escalate issues as needed.

Additional Responsibilities:

• Strong understanding of the Software Development Life Cycle (SDLC) with Agile Methodologies
• Knowledge and understanding of industry-standard/best practices requirements gathering methodologies.
• Knowledge and understanding of Information Technology systems and software development.
• Experience with data modeling and test data management tools.
• Experience in the data integration project • Good problem solving & decision-making skills.
• Good communication skills within the team, site, and with the customer

Knowledge, Skills and Abilities

• Technical expertise in data architecture principles and design aspects of various DBMS and reporting concepts.
• Solid understanding of key DBMS platforms like SQL Server, Azure SQL
• Results-oriented, diligent, and works with a sense of urgency. Assertive, responsible for his/her own work (self-directed), have a strong affinity for defining work in deliverables, and be willing to commit to deadlines.
• Experience in MDM tools like MS DQ, SAS DM Studio, Tamr, Profisee, Reltio etc.
• Experience in Report and Dashboard development
• Statistical and Machine Learning models
• Python (sklearn, numpy, pandas, genism)
• Nice to Have:
• 1yr of ETL experience
• Natural Language Processing
• Neural networks and Deep learning
• xperience in keras,tensorflow,spacy, nltk, LightGBM python library

Interaction :  Frequently interacts with subordinate supervisors.

Education : Bachelor’s degree, preferably in Computer Science, B.E or other quantitative field related to the area of assignment. Professional certification related to the area of assignment may be required

Experience :  7 years of Pharmaceutical /Biotech/life sciences experience, 5 years of Clinical Trials experience and knowledge, Excellent Documentation, Communication, and Presentation Skills including PowerPoint

• Bachelor’s degree in Computer Science, Information Technology, or a similar field.
• Previous experience working as a React.js Developer.(2-8 years)
• In-depth knowledge of JavaScript, CSS, HTML, and front-end languages.
• Knowledge of REACT tools including React.js, Webpack, Enzyme, Redux, and Flux.
• Experience with user interface design.
• Knowledge of performance testing frameworks including Mocha and Jest.
• Experience with browser-based debugging and performance testing software.
• should have hands-on experience in backend software development using Java.
• should have proven expertise in Spring Boot REST/Microservices.
• should have working experience with relational and NoSQL databases.

Skills:

• Ability to understand complex business goals, product & technical content, and Interaction Design in order to create engaging & effective experiences for our customers
• Thorough understanding of User Experience Design
• Collaboratively evolve the functionality of digital products along with Business & Technology teams
• Develop and manage user mapping as well as, User experience guidelines and acceptance criteria
• Ability to research, create and present product user journey maps, user task flows, interaction models, storyboards
• Can develop new approaches to complex design problems and convey these designs in the form of presentations, prototypes, and design specifications
• Excellent time-management, multi-tasking, and communication skills; and the ability to quickly prioritize tasks
• Must communicate clearly and effectively; strong analytical and oral communication skills; excellent interpersonal skills.

Responsibilities:

• Lead the project to on-time and quality delivery as agreed by the client
• Be the part-time project manager
• Raise and negotiate issues and risks with senior management of the client
• Manage profitability of the project
• As the lead designer, he/she needs to guide team members well and facilitate their learning in the organization
• Stay up-to-date with latest achievements, best practices and trends in design
• Candidate should be willing to travel for on-site project executions for short/long durations in India and abroad
• Candidate should be open to temporary/permanent relocation within Think Designs studios in India

Deliverables:

• Due to his/her role as a Project Manager, a Lead UX Designer will be responsible for ensuring on-time and quality delivery of all deliverables for the project even though he/she may not actually work on all of them. Depending on client requirements, as a Lead designer, he/she will be responsible for delivering all or some of the following:
• Design Strategy based on User Mapping, User Stories, Business Needs, Technology inputs
• Wireframes
• Navigation Structures
• Story Boards
• Interactive Guidelines
• Visual Designs
• Prototypes
• PSD Files
• Specification Documentation

What Think Design is offering:

• The diversity & impact of our services and client engagements; and the unique way we’re structured as an organization along with a highly innovative work environment—will add immense value to your experience.
• Be part of an organization that is a unique blend of a highly collaborative teams working closely in studio environment, who’re are part of a Global Group (Havas Global).
• Opportunity to help make & gain experience on meaningful & measurable impact on a fast growing organization.