Opteamix

Job Description: .NET / Java Developer (3–6 Years Experience)

Mode of Employment: Permanent

Work Mode: Work From Office (WFO)

Location: Bangalore

About the Role

We are looking for a skilled .NET / Java Developer with 3–6 years of hands-on experience to join our dynamic development team. The ideal candidate should have strong programming skills, experience in building scalable applications, and the willingness to learn and upskill in modern technologies including Python and AI/GenAI concepts.

Key Responsibilities

• Design, develop, test, and maintain high-quality applications using .NET or Java.
• Collaborate with cross-functional teams to define, design, and deliver new features.
• Write clean, scalable, and efficient code following best practices and coding standards.
• Participate in code reviews and contribute to continuous improvement.
• Troubleshoot, debug, and resolve technical issues.
• Work on API integrations, backend logic, and database management.
• Stay up to date with emerging technologies and be willing to upskill in AI/GenAI as required.

Required Skills

Technical Skills (Must Have):

• Strong development experience in .NET (C#, ASP.NET, .NET Core) or Java (Core Java, Spring/Spring Boot).
• Proficiency in RESTful API development.
• Experience with relational databases (SQL Server, MySQL, PostgreSQL, or similar).
• Good understanding of OOP concepts, data structures, and algorithms.
• Experience with version control systems such as Git.

Desired/Good to Have:

• Basic to intermediate knowledge of Python or willingness to learn.
• Exposure to cloud platforms (Azure/AWS/GCP).
• Understanding of microservices architecture.
• Familiarity with AI/GenAI concepts or interest in being upskilled.

Professional Requirements

• Bachelor’s degree in Computer Science, Engineering, or equivalent.
• 3–6 years of relevant software development experience.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to work in a fast-paced, team-oriented environment.
• Opportunity to work on cutting-edge technologies including AI/GenAI.
• Collaborative team culture.
• Stable and growth-focused work environment.
• Permanent role with full-time work-from-office engagement.

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.