RQ10127 ETL Software Developer

Job Title : Software Developer ETL (Senior)

Work Arrangement

Onsite (5 days per week)

Role Summary

The Senior ETL Software Developer is responsible for designing developing and maintaining scalable data pipelines and analytics solutions across cloud-based and enterprise data platforms. The role focuses on ETL development data integration data modeling and performance optimization to support data warehouse data lake and business intelligence solutions.

Key Responsibilities

Design develop and maintain ETL pipelines for structured and semi-structured data sources

Perform data extraction transformation and loading for both initial and incremental loads

Translate technical and business requirements into working tested ETL solutions

Develop detailed programming specifications and write high-quality reusable code

Build and maintain scheduling and dependency logic for ETL workflows

Conduct unit testing debugging and performance tuning of ETL processes

Investigate data issues identify root causes and propose corrective solutions

Ensure data architecture is scalable maintainable and aligned with best practices

Create and maintain technical documentation (ETL mappings data models architecture diagrams)

Collaborate with business and technical stakeholders throughout the SDLC

Provide post-implementation support including troubleshooting and enhancements

Mandatory Technical Skills

Strong experience with Microsoft Azure data technologies including :

Azure Data Factory

Azure SQL Database

Azure Data Lake

Power BI

Hands-on experience with the Databricks platform

Experience with AWS data services including :

Amazon Aurora

Amazon Relational Database Service

AWS Glue

OpenSearch

Strong experience developing ETL solutions across multiple data repositories

Expertise in data integration data cleansing and data analytics

Strong knowledge of data modeling and design principles for data marts and data warehouses

Experience designing modern analytics architectures (data warehouses data lakes lakehouses)

Advanced SQL skills including complex queries and performance tuning

Experience with database management and administration

Experience using Git and source control strategies

Strong understanding of the full Software Development Life Cycle (SDLC)

General Development & Analysis Skills

Experience in application design coding testing debugging and documentation

Familiarity with structured development methodologies

Ability to elicit document and validate business requirements

Experience collaborating with cross-functional IT and business teams

Strong analytical problem-solving and decision-making skills

Proven ability to meet deadlines and work independently or as part of a team

Nice-to-Have Skills

Experience designing dashboards and reports (scheduled and ad-hoc) highlighting KPIs and trends

Programming experience with C# APIs or cloud-based functions

Scripting experience using PowerShell or other scripting languages

Experience with middleware gateways or integration platforms

Knowledge of AODA and accessibility standards

Experience conducting design walkthroughs and providing user / system documentation

Required Experience :

IC

Key Skills

SQL,Pentaho,PL / SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1