About this Position:
Job Title: ETL Developer
Deliverables:
Design develop and maintain ETL/ELT pipelines using both on-premises and cloud-based tools including IBM InfoSphere DataStage Microsoft SSIS and Azure Data Factory (ADF) based on the project plan.
Build and manage scalable data pipelines and storage solutions using Azure Synapse Analytics and Azure Data Lake Storage ensuring efficient data ingestion transformation and retrieval based on the project plan.
Develop and optimize data solutions using Python R T-SQL and PL/SQL to support analytics reporting and downstream applications.
Work with traditional on-premises relational databases such as Oracle SQL Server and DB2 including performance tuning and data integration.
Design and implement data models data warehouses and architectural frameworks that support enterprise reporting and analytics needs.
Create and maintain Power BI datasets data models and reports ensuring optimized performance and accurate business insights.
Minimum Qualifications:
Consultant Must Meet All Minimum Qualifications.
Expert level/Minimum three (3) years experience in:.
ETL development using on-premises and cloud tools.
Python R T-SQL and/or PL/SQL.
Azure Synapse Analytics and Azure Data Lake Storage.
Design and implement data pipelines following Medallion Architecture (Bronze Silver Gold layers).
Advance level/Minimum one (1) year experience in:.
On-premises databases (Oracle SQL Server DB2).
Power BI and Power BI data modeling.
Minimum one (1) year experience in:.
Data modeling and data warehouse design and architecture for on-premises and cloud environments.
Data governance validation monitoring and lineage management.
Preferred/Special Skills:
Experience supporting predictive analytics or advanced analytics workloads.
Familiarity with cloud-based data governance and monitoring frameworks.
Demonstrates professional organization documentation communication and interpersonal skills.
Strong communication and collaboration skills.