BI Backend Developer

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. 

• 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

Position Overview

Oracle Apex Engineer with good experience building reports using the latest versions of Oracle Apex

and experience in Apex Upgrade. Should have a good working knowledge of Oracle

Applications(R12).

Skills

1-2 end to end implementation/development project

Strong detail, quality, and solution orientation

5+ years of experience designing and implementing technical solutions that are aligned with

business strategy

5 years of applications development experience with Oracle APEX, Oracle SQL, PL/SQL

5+ years of Oracle APEX experience

5+ years experience in Oracle Databases

5+ years experience using PL/SQL

5+ years of JavaScript, HTML, CSS, and REST services

Oracle APEX 4.2 experience is a must and ability to Upgrade to higher versions

Ability to work on SQL performance issues

Ability to think critically and solve complex issues

Ability to work independently, while engaging the customer and providing information to the team

Strong ability to communicate both verbally and in writing with internal and external teams

Ability to prioritize across multiple projects and meet deadlines

Experience adapting in a dynamic work environment

Experience working in a customer-focused environment

Ability to troubleshooting issue

Proficiency in analysis, design, development, testing, implementation, and maintenance of

applications in Oracle Application Express (APEX).

Excellent conceptual knowledge of Oracle 11g.

Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions,

packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor,

Dynamic SQL.

Good knowledge of using PL/SQL Wrappers to protect the PL/SQL procedures and packages.

.NET C# developer provides custom web application development using the .NET Framework, C#, http://VB.NET">VB.NET, http://ASP.NET">ASP.NET, SQL Server and other advanced components of Microsoft technology and provide training to programmer analysts who support the web services manager' responsibilities.

Responsibilities:

 The tool development also involves working with SQL queries and web front end

Designing, developing, and testing web applications with .Net HTML, CSS and other technologies

Design and development of software applications (primarily web based) used in various areas of the bank (such as Loans processing, Treasury, Middle Office )

Manages the architecture, design, and coding of software for TFI from concept to finished product, in order to answer the needs of the Strategies, Sales, and Trading departments

Consults with end users within the Strategies, Sales, and Trading departments to identify where technology can automate current processes to enhance revenues and cut cost

Maintains currency in technical skills and all relevant fixed income industry sector factors

May lead the work of others and provide ideas which help to enhance TFI software applications

Software design & development principles such as SOLID, Domain-Driven-Design and Object-Oriented Development

ORM frameworks, particularly the Entity Framework

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

We are urgently looking Azure Data Factory Engineers with 3 to 7 years of overall experience, having good experience on Azure Data Factory and SSIS.

Requirements:

• Qualification: Engineering Graduate.
• Years of Experience: 2+ yrs of relevant experience on Azure Data Factory & SSIS.
• Strong understanding of ETL/ELT concepts.
• Hands on experience on Azure Data Factory.
• Exposure of Cloud technologies, standards, and platforms.
• Sound knowledge of ADF pipeline, configuration, parameters, variables, Integration services runtime (part of Data Factory).
• Strong Experience on SSIS.
• Sound knowledge of implementing slowly changing dimensions and transactional, fact less, snapshot fact tables.
• Azure Data Warehouse.
• Knowledge on Azure components especially file storage and Azure Sql, Blob storage and Data Lake Gen2 storage (just used as a file system on the blob).
• Azure Data Migration tool.
• Well versed with RDBMS systems like Sql server, DDL, DML scripts.
• Sound knowledge of T-SQL and stored procedures.
• Strong Query writing skills, Scheduling tools.
• Ensure quality deliverable and ability to extend work hours if required.
• Azure Certification: Preferred.
• Ability to understand Customer requirements and convert the requirements into technical specifications.
• Ability to understand the overall solution and design components to fit the overall solution.
• Ability to take technical decisions and support the decisions with justifications.
• Ability to work in Agile manner.
• Ability to work independently without much guidance.
• Self-Motivated, team player, results oriented, strong Time Management skills.
• Excellent written and verbal communication skills.
• Willing to travel to outside India (Short term as well as long term)