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.
Shubham Vishwakarma
Full Stack Developer - Averlon
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.
Company social profiles
Similar jobs
- 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
Python
Django
FlaskKey skills : Python, Numpy, Panda, SQL, ETL
Roles and Responsibilities:
- The work will involve the development of workflows triggered by events from other systems
- Design, develop, test, and deliver software solutions in the FX Derivatives group
- Analyse requirements for the solutions they deliver, to ensure that they provide the right solution
- Develop easy to use documentation for the frameworks and tools developed for adaption by other teams
Familiarity with event-driven programming in Python
- Must have unit testing and debugging skills
- Good problem solving and analytical skills
- Python packages such as NumPy, Scikit learn
- Testing and debugging applications.
- Developing back-end components.
.NET
C#
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.
Java
Spring Boot• 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
Laravel
PHP2) 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)
Python
Amazon Web Services (AWS)
Elastic SearchAbout 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
Review all job requirements and specifications required for deploying the solution into the production environment.
Perform various unit/tests as per the checklist on deployment steps with help of test cases and maintain documents for the same.
Work with Lead to resolve all issues within the required timeframe and inform for any delays.
Collaborate with the development team to review new programs for implementation activities and manage communication (if required) with different functions to resolve issues and assist implementation leads to manage production deployments.
Document all issues during the deployment phase and document all findings from logs/during actual deployment and share the analysis.
Review and maintain all technical and business documents. Conduct and monitor software implementation lifecycle and assist/make appropriate customization to all software for clients as per the deployment/implementation guide
Train new members on product deployment, issues and identify all issues in processes and provide solutions for the same.
Ensure project tasks as appropriately updated in JIRA / ticket tool for in-progress/done and raise the issues.
Should take self-initiative to learn/understand the technologies i.e. Vertica SQL, Internal Data integration tool (Athena), Pulse Framework, Tableau.
Flexible to work during non-business hours in some exceptional cases (for a few days) required to meet the client time zones.
Experience on Tools and Technologies preferred:
ETL Tools: Talend or Informatica ,Abinitio,Datastage
BI Tools: Tableau or Jaspersoft or Pentaho or Qlikview experience
Database: Experience in Oracle or SS
Methodology: Experience in SDLC and/or Agile Methodology
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon