
Position: Lead Software Engineer
Job Overview:
Lead ETL Engineer with SSIS (SQL Server Integration Services) knowledge is primarily responsible for designing, developing, and maintaining ETL (Extract, Transform, Load) workflows and data integration processes to support enterprise data solutions.
Key Responsibilities and Duties
Lead the software development team:
- Lead a team of software engineers in designing, developing, and maintaining ETL Framework.
- Set and communicate clear expectations for the clients regarding project timelines, quality standards, and deliverables.
- Experience with Microsoft SQL Server Database,
- Hands-on experience in writing, optimizing and maintaining complex SQL queries, stored procedures and functions.
- Design and develop robust, scalable, and efficient database structures based on the organization's requirements.
SSIS:
- Design, develop, test, deploy, and maintain SSIS packages for data migration, ETL processes, reporting and to integrate data between various systems.
- Develop complex SQL queries to extract data from various sources such as Oracle or SQL databases.
- Troubleshoot issues related to package execution failures and optimize performance of existing packages.
- Collaborate with stakeholders to understand business requirements and design solutions using SQL Server Integration Services (SSIS).
- Work closely with the team to ensure timely delivery of projects.
- Optimize existing integrations for improved performance and scalability.
- Design and implement complex SSIS packages for extracting, transforming, and loading data from various sources such as relational databases (SQL Server, Oracle, DB2), flat files, and XML files.
- Develop ETL best practices, including error handling, logging, checkpoints, and data quality assurance.
- Write efficient SQL queries, stored procedures, functions, and triggers to support ETL processes.
- Optimize SSIS packages and SQL queries for maximum performance using techniques such as parallelization, lookup caching, and bulk loading.
- Create and maintain design documentation such as data models, mapping documents, data flow diagrams, and architecture diagrams.
- Collaborate with business analysts, BI teams, and other stakeholders to understand requirements and deliver data solutions for reporting and analytics.
- Schedule and monitor SSIS workflows using SQL Server Agent or other scheduling tools, ensuring timely and error-free data loads.
- Troubleshoot, debug, and test SSIS packages and backend database processes to ensure data accuracy and system reliability.
- Participate in resource planning, task estimation, and code review processes.
Collaborate with cross-functional teams:
- Work with other teams such as product management, quality assurance, and user experience to ensure that software applications meet business requirements and user needs.
- Communicate effectively with team members and stakeholders.
Stay up to date with emerging trends and technologies:
- Keep up to date with emerging trends and technologies in the software development industry.
- Make recommendations for improvements to existing software applications and processes.
Mandatory skills
SSIS, understanding of ETL Framework, able to design and implement SSIS
Qualifications
- Bachelor’s degree in computer science or related field.
- 6-9 years of experience in software development.
- Proven leadership experience in leading ETL teams.
- Knowledge of software development methodologies such as Agile or Scrum.
- Ability to mentor and train junior team members.

Similar jobs
Who We Are
At Sonatype, we help organizations build better, more secure software by enabling them to understand and control their software supply chains. Our products are trusted by thousands of engineering teams globally, providing critical insights into dependency health, license risk, and software security. We’re passionate about empowering developers—and we back it with data.
The Opportunity
We’re looking for a Data Engineer with full stack expertise to join our growing Data Platform team. This role blends data engineering, microservices, and full-stack development to deliver end-to-end services that power analytics, machine learning, and advanced search across Sonatype.
You will design and build data-driven microservices and workflows using Java, Python, and Spring Batch, implement frontends for data workflows, and deploy everything through CI/CD pipelines into AWS ECS/Fargate. You’ll also ensure services are monitorable, debuggable, and reliable at scale, while clearly documenting designs with Mermaid-based sequence and dataflow diagrams.
This is a hands-on engineering role for someone who thrives at the intersection of data systems, fullstack development, ML, and cloud-native platforms.
What You’ll Do
- Design, build, and maintain data pipelines, ETL/ELT workflows, and scalable microservices.
- Development of complex web scraping (Playwright) and realtime pipelines (Kafka/Queues/Flink).
- Develop end-to-end microservices with backend (Java 5+, Python 5+, Spring Batch 2+) and frontend (React or any).
- Deploy, publish, and operate services in AWS ECS/Fargate using CI/CD pipelines (Jenkins, GitOps).
- Architect and optimize data storage models in SQL (MySQL, PostgreSQL) and NoSQL stores.
- Implement web scraping and external data ingestion pipelines.
- Enable Databricks and PySpark-based workflows for large-scale analytics.
- Build advanced data search capabilities (fuzzy matching, vector similarity search, semantic retrieval).
- Apply ML techniques (scikit-learn, classification algorithms, predictive modeling) to data-driven solutions.
- Implement observability, debugging, monitoring, and alerting for deployed services.
- Create Mermaid sequence diagrams, flowcharts, and dataflow diagrams to document system architecture and workflows.
- Drive best practices in fullstack data service development, including architecture, testing, and documentation.
What We’re Looking For
- 5+ years of experience as a Data Engineer or a Software Backend engineering role.
- Strong programming skills in Python, Scala, or JavaHands-on experience with HBase or similar NoSQL columnar stores.
- Hands-on experience with distributed data systems like Spark, Kafka, or Flink.
- Proficient in writing complex SQL and optimizing queries for performance.
- Experience building and maintaining robust ETL/ELT pipelines in production.
- Familiarity with workflow orchestration tools (Airflow, Dagster, or similar).
- Understanding of data modeling techniques (star schema, dimensional modeling, etc.).
- Familiarity with CI/CD pipelines (Jenkins or similar).
- Ability to visualize and communicate architectures using Mermaid diagrams.
Bonus Points
- Experience working with Databricks, dbt, Terraform, or Kubernetes
- Familiarity with streaming data pipelines or real-time processing
- Exposure to data governance frameworks and tools
- Experience supporting data products or ML pipelines in production
- Strong understanding of data privacy, security, and compliance best practices
Why You’ll Love Working Here
- Data with purpose: Work on problems that directly impact how the world builds secure software
- Modern tooling: Leverage the best of open-source and cloud-native technologies
- Collaborative culture: Join a passionate team that values learning, autonomy, and impact
RequiredSkills:
• Minimum of 4-6 years of experience in data modeling (including conceptual, logical and physical data models. • 2-3 years of experience inExtraction, Transformation and Loading ETLwork using data migration tools like Talend, Informatica, Datastage, etc. • 4-6 years of experience as a database developerinOracle, MS SQLor another enterprise database with a focus on building data integration process • Candidate should haveanyNoSqltechnology exposure preferably MongoDB. • Experience in processing large data volumes indicated by experience with BigDataplatforms (Teradata, Netezza, Vertica or Cloudera, Hortonworks, SAP HANA, Cassandra, etc.). • Understanding of data warehousing concepts and decision support systems.
• Ability to deal with sensitive and confidential material and adhere to worldwide data security and • Experience writing documentation for design and feature requirements. • Experience developing data-intensive applications on cloud-based architectures and infrastructures such as AWS, Azure etc. • Excellent communication and collaboration skills.
Skill for BI Backend developer -
-SQL development (Snowflake preferred but any other version of SQL would work)
- ETL
- Stored Procedures
- Creating jobs and work flows in SQL
- some business knowledge
Company Overview
CareStack is a complete cloud-based dental software solution for scheduling, clinical, billing, patient engagement, and reporting needs of dental offices of any size - whether it's a single location or a large multi-site DSO with hundreds of locations.
The company was founded in 2015 and the commercial launch was done in early 2018. Since then, more than 1000 offices have chosen CareStack as their single source of truth. This is the fastest growth till date in the dental practice management software market, dominated by 100 year old distribution companies.
More about CareStack
● Rated by independent B2B software reviews and research analysts as the most modern, innovative and customer experience focussed company in the space with the fastest growth in the segment.
● Important strategic go to market partnerships with dental industry leaders like Delta Dental, Darby Dental and several others.
● Venture backed with over $60M raised from leading financial and strategic investors.
● HQ'd in Orlando, FL with offices in Minnesota, Bangalore, Trivandrum and Cochin.
Role Overview
CareStack seeks to hire Software Development Engineer - 1 to build its next generation healthcare platform. You will be reporting to a Staff SDE in your business unit , to develop and release services and solutions for our platform, aligning with your business unit’s goals and objectives.
Key responsibilities
● Technical Design
You can be a specialist in technology areas, but capable of creating complete designs to solve a specific problem that accomplishes a definitive product feature or enables a technical advancement.You should work with your lead to review your design and embrace the feedback
● Process Definition/Adherence
You should deliver estimations, review test scenarios/cases created by QAs in your team, participate in sprint grooming and planning meetings. You must learn, practice and evangelize standard techniques for grooming, defining complexity of stories and estimation.
● Code Quality
At Carestack we believe that your code reflects your character. Code for scale, produce maintainable reusable code. You must commit to clean coding, continuous refactoring to ensure a high level of code quality. Continuously learn, practice and evangelize coding patterns/best practices within and outside your team. You should ensure testability of team functional areas, facilitate integration testing, resolve deep rooted technical issues and proactively collaborate with team members in solving complex problems.
● Team Player
You should proactively communicate to resolve dependencies within and outside the team. Understand organizations culture code and streamline conversations and activities that will further instill this code. Mentor and coach new additions to your team.
● Value/Mission Alignment
Be a champion for CareStack within the Engineering team. Help drive workplace and cultural norms within your business unit that align with CareStack company values.
This role may be for you if you…
● Have an insatiable itch to join and the courage to scale an early-stage technology company.
● Have 2-4 years of experience in building modern day web platforms, using Microsoft technologies on the backend.
● Can be a generalist or specialist with deep understanding of building software components that meet defined requirements, with good understanding of .NET Core/ASP.NET.
● Are proficient in data structures and algorithms, and object oriented analysis and design of software systems.
● Are a backend specialist with good understanding of event driven programming, distributed systems, caching/in-memory computing systems, data modeling for transactional systems.
● Solid understanding of relational and non relational databases including warehouses.Preferably MySQL, MSSQL, Vertica and CosmosDB
● Solid understanding of CI/CD patterns and IaC.
● Expertise in building ETLs in both batch and streaming model.
● Expertise in building and testing APIs and micro services
This role may not be for you if you…
● Don’t have the itch to design solutions and write code and you don’t grab every other opportunity to review and write code.
● Don’t have the fire in you to fight for your design suggestions and debate with logical data points
● Don’t have the trait to be transactional in code reviews/design discussions, accept your mistakes and appreciate better ideas from your peers.
● Haven’t developed the habit of doing objective conversations that are data driven.
• Exposure to latest Technology
• Opportunity working in different platforms
• Rapid Career Growth
• Friendly Knowledge sharing Environment
Criteria:
• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 30days
• Candidates will be selected based on logical / technical and scenario-based testing
Note: Candidates who have attended the interview process with TnS in the last 6 months will not be
eligible.
Job Description:
Technical Skills Desired:
- Experience in either of these Relational DB’s MS SQL Server / PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch DB.
- Design database tables, views, indexes
- Write functions and procedures for Middle Tier Development Team
- Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
- Query Optimization for performance improvement
- Design & develop SSIS Packages or any other Transformation tools for ETL
Functional Skills Desired:
- Banking / Insurance / Retail domain would be a plus.
- Interaction with a client a plus
Good to Have Skills:
- Knowledge in a Cloud Platform (AWS / Azure)
- Knowledge on version control system (SVN / Git)
- Exposure to Quality and Process Management
- Knowledge in Agile Methodology
Soft skills: (additional)
- Team building (attitude to train, work along, mentor juniors)
- Communication skills (all kinds)
- Quality consciousness
- Analytical acumen to all business requirement
- Think out-of-box for business solution
About Us
Welthungerhilfe (WHH) is an international aid agency headquartered in Germany with its vision for “Zero Hunger by 2030”, the second sustainable development goal set by the UN. It has thousands of programs fighting hunger in more than 30 countries. (https://www.welthungerhilfe.org/">https://www.welthungerhilfe.org) (https://www.childgrowthmonitor.org/">https://www.childgrowthmonitor.org).
Child Growth Monitor (CGM) is Welthungerhilfe’s digital innovation project leveraging AI to fight child malnutrition. Around 200 million children around the world are suffering from malnutrition. Malnutrition contributes to one-third of deaths of children under the age of five. In the fight against malnutrition, detection is the first important step, but this is not an easy task: Measuring children with traditional methods is still a complex, slow, and expensive task, frequently resulting in poor data and wrong assessments of the child’s health. Early detection of malnutrition becomes the key to initiating treatment, minimizing the risk of complications,
and saving lives by reducing the chances of death to a great extent.
Our solution to measure children replaces hardware (bulky measuring boards and physical scales) with off-the-shelf cell phones and AI. CGM uses augmented reality-enabled smartphones to record 3D scans of children. Artificial Intelligence is used to predict their height, weight, and middle upper-arm circumference needed to know the nutritional status of the children.
What you would do to help us save millions of children's lives
We are looking for you as an experienced Sr Software Engineer who works collaboratively with the dedicated team of tech specialists (AI, ML & Data Scientists) distributed globally have a shared responsibility for ensuring high quality and
Scalable health care product in an agile approach.
This posting concerns a full-time assignment working for Welthungerhilfe’s CGM in a freelance capacity but Full-time employment (payroll) is scheduled for the end of 2022 latest. We are in the process of setting up CGM as a registered social business from mostly January 2023 and moving all the consultants on CGM payrolls.
Responsibilities
- Designing, developing features, refinement/improving and implementing the CGM product in a secure, well-tested, and performant way.
- De-bugging of the current issues
- Collaborate with Product Management and other stakeholders within Engineering (Frontend, UX, etc.) to maintain a high bar for quality in a fast-paced, iterative environment.
- Advocate for improvements to product quality, security, and performance.
- Solve technical problems of moderate scope and complexity.
- Craft code that meets our internal standards for style, maintainability, and best practices for a high-scale Mobile app environment. Maintain and advocate for these standards through code review.
- Provide mentorship for Junior and Intermediate Engineers on your team to help them grow in their technical responsibilities and remove blockers to their autonomy.
Requirements and skills
- Comfort working in a highly agile, intensely iterative software development process.
- Demonstrated capacity to clearly and concisely communicate about complex technical, architectural, and/or organizational problems and propose thorough iterative solutions.
- Experience with performance and optimization problems and a demonstrated ability to both diagnose and prevent these problems.
- Extensive experience in core Python (3-7yrs)
- Should have worked on Azure or any Cloud and Azure data factory or any similar data platforms
- Experience using Flask/Flutter framework
- Experience working on mobile applications/Web applications (writing flask framework)
- Knowledge of DevOps Pipeline
- Good experience in SQL database
- Working knowledge in Data engineering (ETL pipelines Result Generation Module)
- Basic understanding of front-end technologies such as Vue JS
- Working knowledge in creating predictive models for AI and ML-based features
- Tech /BE in Computer Science with a total of 7 years of software development/Programming experience.
Desired skills
- Good to have an experience in Kubernetes (opensource system)
- Good to have experience working on healthcare mobile apps (predictive analytics and image diagnostics)
- Experience owning a project from concept to production, including proposal, discussion, and execution.
- Proficient understanding of code versioning tools
Soft/Human Skills
- Positive and solution-oriented mindset.
- Excellent communication & interpersonal skills
- Self-motivated and self-managing, with excellent organizational skills.
- Ability to thrive in a fully remote organization
About SteelEye
SteelEye is a fast growing FinTech company based in London and has offices in Bangalore and Paris, that offers a data platform to help financial institutions such as Investment Banks, Hedge Funds, Brokerage Firms, Asset Management Firms to comply with financial regulations in the European Union. Our clients can aggregate, search, surveillance and report on trade, communications and market data. SteelEye also enables customers to gain powerful insights from their data, helping them to trade with greater efficiency and profitability. The company has a highly experienced management team and a strong board, who have decades of technology and management experience and worked in senior positions at many leading international financial businesses. We are looking to hire a seasoned SRE to join us as we start on our next phase of growth. We have a culture of openness, collaboration, and the passion to get things done whilst appreciating the importance of a good work life balance.
Being part of a start-up can be equally exciting as it is challenging. You will be part of the SteelEye team not just because of your talent but also because of your entrepreneurial flare which we thrive on at SteelEye. This means we want you to be curious, contribute, ask questions and share ideas. We encourage you to get involved in helping shape our business.
What you’ll do
- Deliver plugins for our Python-based ETL pipelines.
- Deliver Python microservices for provisioning and managing cloud infrastructure.
- Implement algorithms to analyse large data sets.
- Draft design documents that translate requirements into code.
- Deal with challenges associated with handling large volumes of data.
- Assume responsibilities from technical design through technical client support.
- Manage expectations with internal stakeholders and context-switch in a fast paced environment.
- Thrive in an environment that uses AWS and Elasticsearch extensively.
- Keep abreast of technology and contribute to the engineering strategy.
- Champion best development practices and provide mentorship.
What we’re looking for
- Experience in o Python 3.
- o Python libraries used for data (such as pandas, numpy).
- o AWS.
- o Elasticsearch.
- o Performance tuning.
- o Object Oriented Design and Modelling.
- o Delivering complex software, ideally in a FinTech setting.
- o CI/CD tools.
- Knowledge of design patterns.
- Sharp analytical and problem-solving skills.
- Strong sense of ownership.
- Demonstrable desire to learn and grow.
- Excellent written and oral communication skills.
- Mature collaboration and mentoring abilities.
About SteelEye Culture
- Work from home until you are vaccinated against COVID-19
- Top of the line health insurance • Order discounted meals every day from a dedicated portal
- Fair and simple salary structure
- 30+ holidays in a year
- Fresh fruits every day
- Centrally located. 5 mins to the nearest metro station (MG Road)
- Measured on output and not input
As a Software Engineer at Quince, you'll be responsible for designing and building scalable infrastructure and build applications to solve some very interesting problems in the logistics and finance tech space.
Responsibilities:
- Design and architect solutions on the cloud for various business problems with workflow efficiency and scale in mind.
- Be on the forefront with the business team to learn, understand, identify and translate function requirements into technical opportunities.
- End-to-end ownership - from scoping the requirements to the final delivery of the solution with keen eye to details and quality.
- Build and improve logistics components for this innovative M2C supply-chain model.
- Build and maintain scalable ETL data pipelines.
Requirements:
- Bachelors/Masters/PhD in Computer Science or closely related subject.
- 1-5 years of experience in building software solutions.
- Good at data structures and their practical applications.
- Proficiency in Kotlin, Java, Python.
- Experience in deploying and maintaining applications on cloud platforms (Ex: AWS, Google cloud).
- Proficiency with SQL and databases - relational and/or nosql (Snowflakes, AWS RedShift, etc).
- Experience with messaging middleware such as Kafka is good to have.











