Cutshort logo
Opteamix logo
Lead Software Engineer
Lead Software Engineer
Opteamix's logo

Lead Software Engineer

Praveen KumarBK's profile picture
Posted by Praveen KumarBK
6 - 9 yrs
₹18L - ₹20L / yr
Bengaluru (Bangalore)
Skills
SQL Server Integration Services (SSIS)
ETL

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. 

 

Read more
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos

About Opteamix

Founded :
2012
Type :
Services
Size :
100-1000
Stage :
Profitable

About

Opteamix is a digital automation technology consulting firm with deep expertise in Application Development, Robotic Process Automation, AI, DevOps, Enterprise Mobility, ITOps, and Test Automation Services. We are headquartered in Denver, Colorado with a wholly-owned delivery center in Bangalore, India.


We ensure that our clients are always ahead of the curve by leveraging futuristic technologies to co-create a better tomorrow, today. Since the founding of the company in 2012, we have focused on solving our client’s business problems using digital technology.


Keeping a close eye on current market trends and emerging technologies is how we understand and further strengthen our technical know-how. We combine deep business knowledge and cutting-edge technology solutions to deliver innovative business solutions leveraging global technology delivery practices.


We deliver a wide spectrum of technology solutions - from legacy technologies to the next generation Robotic Process Automation, AI, and Machine Learning solutions.

Read more

Company social profiles

bloginstagramlinkedintwitterfacebook

Similar jobs

Bangalore based company
Bangalore based company
Agency job
via On Time Solutions by Yogitha M
Bengaluru (Bangalore)
5 - 9 yrs
₹10L - ₹16L / yr
Microsoft SSIS
SSIS
SQL Server Integration Services (SSIS)
5+ Yrs in SSIS, SQL
Bangalore
Immediate
  • Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
  • Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
  • Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
  • Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
  • Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
  • Create and execute test plans,document issues and track progress at resolving issues.
Read more
3K Technologies Pvt Ltd
Agency job
via 3K Technologies Pvt Ltd by Zinal Kothadia
Bengaluru (Bangalore)
3 - 7 yrs
₹5L - ₹20L / yr
skill iconGo Programming (Golang)
skill iconRuby on Rails (ROR)
skill iconRuby
skill iconPython
skill iconJava
+3 more

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

Read more
Remote only
5 - 8 yrs
₹12L - ₹25L / yr
skill iconPython
skill iconFlask
skill iconFlutter
Microsoft Windows Azure
ETL
+2 more

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

 

Read more
Brainbean Technolabs Pvt Ltd
Hiral Upadhyay
Posted by Hiral Upadhyay
Remote, Anand
1 - 5 yrs
₹2L - ₹6L / yr
skill iconLaravel
skill iconPHP
MySQL
SQL server
SQL Server Integration Services (SSIS)
+3 more
1) designing and implementing applications
2) developing and testing software and resolving technical issues that arise
3) Prepare and maintain all applications utilizing standard development tools
4) Utilize backend data services and contribute to increasing existing data services API
5) Lead the entire development life cycle right from concept stage to delivery and post-launch support
6) Convey effectively with all task progress, evaluations, suggestions, schedules along with technical and process issues
7) Document the development process, architecture, and standard components
8) Coordinate with co-developers and keeps project manager well informed of the status of development effort and serves as a liaison between development staff and project manager
9) Keep abreast of new trends and best practices in web development
10) Fixing bugs
Read more
Winjit Technologies
at Winjit Technologies
10 recruiters
Kshitij Wairagade
Posted by Kshitij Wairagade
Nashik, Pune, Bengaluru (Bangalore), Mumbai
2 - 6 yrs
₹3L - ₹10L / yr
MS SQLServer
SQL
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
Microsoft Business Intelligence (MSBI)
+2 more
Job Description:

Candidate need to handle the ticket raised by the team, where they asked to perform the operations on database. Once ticket get’s solved they need to update team for the same.

What would be the key responsibilities expected out of this role

1) Help write and optimize in-application SQL statements

2) Ensure performance, security, and availability of databases

3) Prepare documentations and specifications

4) Handle common database procedures such as upgrade, backup, recovery, migration, etc.

5) Good in DML and DDL

Must Have Skills:

MS-SQL 

Good To Have Skills: 

SSIS & SSRS Or MSBI

Notice Period: 

15 Days - 30 Days (Immediate Joiners Preferred)
Read more
ArisGlobal
at ArisGlobal
1 recruiter
Agency job
via OXYTITA Consulting by Suraj Muthanna
Remote, Bengaluru (Bangalore), Mysore
7 - 10 yrs
₹10L - ₹20L / yr
Oracle
database
PL/SQL
Database migration
Argus
+3 more
  • 7 years of hands-on experience on database development
  • Very strong and hands-on in Oracle Database and PL/SQL development
  • Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
  • Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
  • Working experience in development of ETL process, DB Design and Data Structures
  • Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
    Excellent written and verbal communication skills
Read more
Bengaluru (Bangalore)
7 - 8 yrs
₹12L - ₹14L / yr
Data modeling
Stored Procedures
SQL server
Reporting
SQL Server Integration Services (SSIS)
+1 more
About Increasingly:Increasingly is an award-winning, fast-growing retail technology company focused specifically on the automation of cross-selling for online retailers. Our clients include large global corporations like Samsung & Canon to several small to medium size retailers across the globe. Our AI-based algorithms help a customer buying a TV on Samsung to find the matching soundbar & purchase both together. Increasingly is headquartered in London with offices in Lisbon & Bangalore. We work with clients in over 30 countries & 20 languages.We are looking to rapidly expand our technology & product development operations in India. And we need smart, ambitious people like you who enjoy a fun yet challenging work environment. We believe strongly that diversity & inclusion are the foundations for a lasting, incredible culture. We also believe that it's important to get the balance right between work & life.The job and its impact:- Be solely responsible for designing databases and ensuring their stability, reliability, and performance. Ensure that the database system is efficient and error-free. - Optimize your queries when a website is too slow due to database performance, write queries for heavy traffic databases, and design tables and indexes for the best database architecture and performance.- Lead a team of developers and successfully solve issues and make improvements to databases, while ensuring all work meets the necessary requirements.- Learn new technology. There's a ton of stuff in there that falls outside the classical SQL model, and learning how to use it will improve your craft.- Find a problem to solve and don- t be afraid to fail. Learn by making mistakes.- Be fluent in the current technology and able to learn how to correctly utilize new technology, often on the fly. As a result, you are must be the most versatile member of any team.- Everything changes so fast the fundamentals you learned five or 5 years ago may no longer be applicable. Architect skills. Developers must be architects these days. Understand the big picture of mapping. Try to find the next set of standards.What essential skills you need:- Schema design, data modeling, data upgrades, develop distributed and highly scalable applications with a focus on scalability performance availability reliability security and maintainability of the applications or technologies.- Code review, SQL query tuning, SQL patches, ownership, attention to detail ad-hoc queries & automation in support of internal and external customers data exchange and integration needs.- Research, troubleshoot, and resolve data issues impacting extract delivery, application design enhancements, development, debugging, and optimization with respect to data concerns and new product features.- Cloud-managed database engines such as Amazon RDS. NoSQL solutions such as Redis, Cassandra, MongoDB, make regular recommendations for system improvements.- Extensive experience with backups monitoring performance tuning and troubleshooting tools & techniques. Ability to identify bad SQL statements & optimize them.- Support QA & development team in project queries, test plans and test cases to improve the database with an ability to communicate effectively within a team.- Self-starter collects data, analyzes the collected information, designs algorithms, draws flowcharts and then implements code for the logic developed through algorithms and flowcharts.What are the benefits:- You'll get to work in one of the hottest & fastest growing retail technologies in Europe right now. - You'll get paid a competitive salary & be working directly with a super experienced team of people. - You'll get a great place to come to work every day. Varied, complex, challenging & with a great culture that you can shape & change.
Read more
Kaleyra
at Kaleyra
1 video
3 recruiters
Gunjan Agarwal
Posted by Gunjan Agarwal
Bengaluru (Bangalore)
4 - 7 yrs
₹6L - ₹14L / yr
skill iconPHP
skill iconCodeIgniter
skill iconCakePHP
skill iconLaravel
SQL Server Integration Services (SSIS)
+6 more
We are looking for a Senior Software Engineer to implement functional software solutions. The goal will be to develop high-quality software/s that is aligned with user needs and business goals.Roles & Responsibilities :- Will own a complete platform from initial architecture, design of components, quality and deployment planning- Will act as an evangelist for the product platform. Identify right technologies for the business use cases. Will be involved in creation of user manuals, internal documents and customer API documentations.- Will understand requirements by studying information needs, discussing with the stakeholders, understanding workflow processes, data flows. Create design and architecture documents to explain, justify and evaluate design approaches.- Should be strong in design principles and have implemented them in existing projects.- Involved in troubleshooting existing applications in production. Identify and build tools for troubleshooting.- Will be involved in creating flowcharts and data flow diagrams. Will be involved in code review for peers. Should be able to identify and implement best practises.- Should be an advocate of automating daily tasks. Should have a high inclination towards building self managed systems.- Should be aware of the latest technology trends. Should participate in professional publications, conferences and events.- Will be involved in mentoring junior team members and aligning them towards company goals.- Identify and implement metrics for measuring platform stability and end user feedback.Requirements :- BS/MS degree in Computer Science/Information Science, Engineering or related field from reputed institute.- Experience of 4-7 Yrs- He/She has built distributed systems. Has the capacity to identify a problem and provide a solution- Has experience with scalable applications. Should identify probable bottlenecks and come up with approaches to mitigate them.- Has experience in working in cloud infrastructure. Should have exhibited capability in identifying and working with IaaS and PaaS providers.- Has a good understanding of OOPs and Functional programming concepts.- Has hands on working experience in one or more of the technologies like PHP (laravel, YII, Code Ignitor ), NodeJs (hapi.js express.js, socket.io), Golang, Java.- Have a working knowledge of web technologies like HTML, CSS and Javascript.- Has experience in identifying database solutions for a given problem. Should have experience working with one of RDBMS and NoSQL databases.- Has a good knowledge about API fundamentals.- Should have worked with third party APIs integrations.- Good written and verbal communication skills.- Should be a highly motivated and a quick learner.
Read more
NCR (Delhi | Gurgaon | Noida)
3 - 6 yrs
₹4L - ₹6L / yr
skill icon.NET
ASP.NET MVC
SQL Server Integration Services (SSIS)
MS SQLServer
skill iconJavascript
Job Description: • Should have hands on experience in ASP.Net MVC • Experienced in JavaScript , J son , WCS • Micro services experience is good to have. 1. Expert in ASP.NET MVC applications, .Net framework 2. Expert in C#.NET 3. Expert in developing Mobile application programming 4. Proficient in JavaScript 5. Expert in Web API RESTFUL Services. 6. Proficient in Writing and working on SQL Server Queries
Read more
Eazo Logistics Technology Pvt Ltd
Nikhil Gangurde
Posted by Nikhil Gangurde
Navi Mumbai
2 - 6 yrs
₹4L - ₹6L / yr
Web Service Definition Language (WSDL)
AWS CloudFormation
Database Design
Object Oriented Programming (OOPs)
Relational Database (RDBMS)
+2 more
Who we are? A smart tech company that places more focus on lateral thinking and uses common sense to create innovative models and create an impression at the world stage. From being an absolute no paper usage to being the most desired organisation to work with and create the perfect partners for business and perfect workplace for any professional. We intend to change the way business will be conducted and managed henceforth What is Eazo? An integrated app for logistics - Supply chain needs to evolve. There are many pieces that needs to be brought together to drive an effective model which now Eazo has designed using it’s ecosystem while tapping in to the largest workforce imagined.
Read more
Why apply to jobs via Cutshort
people_solving_puzzle
Personalized job matches
Stop wasting time. Get matched with jobs that meet your skills, aspirations and preferences.
people_verifying_people
Verified hiring teams
See actual hiring teams, find common social connections or connect with them directly.
ai_chip
Move faster with AI
We use AI to get you faster responses, recommendations and unmatched user experience.
Did not find a job you were looking for?
icon
Search for relevant jobs from 10000+ companies such as Google, Amazon & Uber actively hiring on Cutshort.
companies logo
companies logo
companies logo
companies logo
companies logo
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos