
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.

About Opteamix
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.
Similar jobs
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.
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
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
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
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)
- 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






