ETL Developer

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.