ETL Developer

CloudVitalNorth York, ON, Canada

4 days ago

Job type

Full-time

Job description

We are currently seeking an ETL developer to design, develop, and maintain ETL processes for data integration and transformation.

Job Role : ETL Developer

Job Type : Full -Time / Contract

Location : Toronto, Canada

This is a Hybrid role with 3 days onsite and 2 days remote!

Responsibilities :

Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.
Analyze requirements / specifications, architectural / system design documents
Implement solution using Azure Data Factory (ADF) pipeline and stored procedure, and Informatica Power Centre to populate enterprise data warehouse
Develop Azure CI / CD pipeline to automate ADF release
Implement complex data conversion, e.g., binary to character, EBCDIC to UTF
Implement complex data transformation(s) for derived and calculated values
Integrate data sets from diverse source systems
Implement ADF for initial data load and incremental load
Promote ADF and Informatica ETL / ELT including : Development, Integration Testing, QA, UAT, Production
Debug ADF pipeline and stored procedure and Informatica workflow to investigate and fix defects
Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow

Skills Required :

SQL competence (query performance tuning, index management, etc.) and a grasp of database structure are required.

Understanding of data modelling concepts.

Extensive experience with ETL tools Informatica Power Centre and Microsoft SSIS

Extensive experience with Azure Data Factory

High attention to detail

Passionate about complex data structures and problem solving

If you are a skilled ETL Developer looking for an exciting opportunity to work with cutting-edge technologies in a collaborative environment, we would love to hear from you.

Create a job alert for this search

Developer Etl • North York, ON, Canada