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

Cornertree
at Cornertree
1 recruiter
Deepesh Shrimal
Posted by Deepesh Shrimal
Pune, Mumbai
3 - 10 yrs
₹5L - ₹45L / yr
Duck Creek
data insight
SQL Server Reporting Services (SSRS)
SQL
ETL
  • Bachelor's degree required, or higher education level, or foreign equivalent, preferably in area wit
  • At least 5 years experience in Duck Creek Data Insights as Technical Architect/Senior Developer.
  • Strong Technical knowledge on SQL databases, MSBI.
  • Should have strong hands-on knowledge on Duck Creek Insight product, SQL Server/DB level configuration, T-SQL, XSL/XSLT, MSBI etc
  • Well versed with Duck Creek Extract Mapper Architecture
  • Strong understanding of Data Modelling, Data Warehousing, Data Marts, Business Intelligence with ability to solve business problems
  • Strong understanding of ETL and EDW toolsets on the Duck Creek Data Insights
  • Strong knowledge on Duck Creek Insight product overall architecture flow, Data hub, Extract mapper etc
  • Understanding of data related to business application areas policy, billing, and claims business solutions
  • Minimum 4 to 7 year working experience on Duck Creek Insights product
  • Strong Technical knowledge on SQL databases, MSBI
  • Preferable having experience in Insurance domain
  • Preferable experience in Duck Creek Data Insights
  • Experience specific to Duck Creek would be an added advantage
  • Strong knowledge of database structure systems and data mining
  • Excellent organisational and analytical abilities
  • Outstanding problem solver


Read more
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
Think n Solutions
at Think n Solutions
2 recruiters
TnS HR
Posted by TnS HR
Bengaluru (Bangalore)
3 - 11 yrs
Best in industry
MySQL
SQL
skill iconJava
J2EE
skill iconSpring Boot
+10 more
Why Think n Solutions Software?
• 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
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
Navtech
at Navtech
6 recruiters
Srivatsav C
Posted by Srivatsav C
Hyderabad, Pune
4 - 9 yrs
₹10L - ₹18L / yr
SQL
MS SQLServer
MySQL
SQL server
Microsoft SQL Server
+7 more

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

  1. Design conceptual and logical data models and flowcharts.
  2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
  3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
  4. Help write and optimize in-application SQL statements.
  5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
  6. Ensure performance, security, and availability of databases.
  7. Use high-speed transaction recovery techniques and backup data.
  8. Provide proactive and reactive data management support and training to users.
  9. Determine, enforce and document database policies, procedures, and standards.
  10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
  11. Monitor database performance, implement changes, and apply new patches and versions when required.
Who Are We Looking For Exactly? 
  1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
  2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
  3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
  4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
  5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
  6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
  7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
  8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
  9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
  10. Experience in Postgres, No-SQL databases (a plus).
  11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
  12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

  • Working with industry giants while following your passion for technology.
  • Competitive pay package with additional bonus and benefits.
  • Performance review and Appraisal Twice a year.
  • Family Health Insurance cover for self and family.
  • Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
  • Work with a culturally diverse team from different geographies
Read more
MNC
MNC
Agency job
via Fragma Data Systems by Priyanka U
Bengaluru (Bangalore)
5 - 9 yrs
₹15L - ₹25L / yr
Data Warehouse (DWH)
dwh
warehousing
Datawarehousing
SQL
+1 more
Work Days: Sunday through Thursday
Week off: Friday & Saurday
Day Shift.


Key responsibilities:

  • Creating, designing and developing data models
  • Prepare plans for all ETL (Extract/Transformation/Load) procedures and architectures
  • Validating results and creating business reports
  • Monitoring and tuning data loads and queries
  • Develop and prepare a schedule for a new data warehouse
  • Analyze large databases and recommend appropriate optimization for the same
  • Administer all requirements and design various functional specifications for data
  • Provide support to the Software Development Life cycle
  • Prepare various code designs and ensure efficient implementation of the same
  • Evaluate all codes and ensure the quality of all project deliverables
  • Monitor data warehouse work and provide subject matter expertise
  • Hands-on BI practices, data structures, data modeling, SQL skills


Hard Skills for a Data Warehouse Developer:

  • Hands-on experience with ETL tools e.g., DataStage, Informatica, Pentaho, Talend
  • Sound knowledge of https://www.freelancermap.com/it-projects/sql-1084" target="_blank">SQL
  • Experience with SQL databases such as Oracle, DB2, and SQL
  • Experience using Data Warehouse platforms e.g., SAP, Birst
  • Experience designing, developing, and implementing Data Warehouse solutions
  • Project management and system development methodology
  • Ability to proactively research solutions and best practices

Soft Skills for Data Warehouse Developers:

  • Excellent Analytical skills
  • Excellent verbal and written communications
  • Strong organization skills
  • Ability to work on a team, as well as independently
Read more
Solutionec Private Limited
Ajith Gopi
Posted by Ajith Gopi
Bengaluru (Bangalore), Paris
6 - 10 yrs
₹16L - ₹22L / yr
Cloud Computing
Big Data
Microsoft Business Intelligence (MSBI)
skill iconAmazon Web Services (AWS)
SQL Server Integration Services (SSIS)
+6 more
Exciting opportunity for any contractor to work with a start-up firm which is into product cum service based industry. We are looking for someone who has got rich experience in below mentioned skills to join us immediately.

This role is for 1 month where the person will be working from Client site in Paris to understand the system architecture and documenting them. Contract extension for this role will be purely on the performance of individual. 

Since the requirement is immediate and critical, we need someone who can join us soon and travel to Paris in December

- Hands on experience handling multiple data sources/datasets
- experience in data/BI architect role
- Expert on SSIS, SSRS, SSAS
- Should have knowledge writing MDX queries
- Technical document preparation
- Should have excellent communication
- Process oriented
- Strong project management
- Should be able to think Out of the Box and provide ideas to have better solutions
- Outstanding team player with positive attitude
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