About the role
Skills: Strong focus on ETL, SQL, SSIS, Tidal, Airflow
JD: This position is for an Integration engineer with a background in SSIS, Python, SQL and data warehousing for enterprise level systems. The position calls for someone comfortable working with business users along with business analyst expertise.
Major Responsibilities
- Provide Level 2/3 support of existing ETL processes.
- Monitor and troubleshoot Scheduled ETL jobs, identify and resolve issues or bottlenecks.
- Proficient in developing ETL processes in SSIS, Python and SQL (SQL Server / Oracle) Proficient in writing SQL queries and programming including stored procedures and reverse engineering existing processes.
- Build and optimize data pipelines for efficient data ingestion, transformation and loading from various sources while ensuring data quality and integrity.
- Working with structured, semi structured and unstructured data.
- Implement best practices for data management, security, and governance.
- Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.
Required Skills
- 5+ years SSIS development experience
- 5+ years Python coding experience.
- 5+ years SQL Server based development of large datasets Additional Skills:
- Experience in Financial Services industry
- Experience with Enterprise Schedulers / Orchestration platforms such as Tidal, Airflow.
- Experience in any cloud data warehouse like Snowflake.
- Experience in Data warehousing - OLTP, Dimensions, Facts, and Data modeling.
- Experience with Cloud based data architectures, messaging, and analytics.
- Experience with developing and deploying ETL pipelines using Databricks Pyspark.
Education
- Minimally a BA/BS degree within an engineering and/or computer science discipline
- Master’s degree preferred
Not the right fit? Search for ETL Developer jobs in Toronto, Ontario, Canada
About Rivago infotech
Rivago Infotech Inc has been a leader in IT staffing and Software development for over 5 years and is one of the largest diversity and development firms in the industry. We are known for our high-touch, customer-eccentric approach, offering our clients unmatched quality, responsiveness and flexibility . We are appreciated by our clients for our streamlined execution, highly efficient service and exceptional talent management that go above and beyond traditional staffing services.
Similar Jobs
About the role
Skills: Strong focus on ETL, SQL, SSIS, Tidal, Airflow
JD: This position is for an Integration engineer with a background in SSIS, Python, SQL and data warehousing for enterprise level systems. The position calls for someone comfortable working with business users along with business analyst expertise.
Major Responsibilities
- Provide Level 2/3 support of existing ETL processes.
- Monitor and troubleshoot Scheduled ETL jobs, identify and resolve issues or bottlenecks.
- Proficient in developing ETL processes in SSIS, Python and SQL (SQL Server / Oracle) Proficient in writing SQL queries and programming including stored procedures and reverse engineering existing processes.
- Build and optimize data pipelines for efficient data ingestion, transformation and loading from various sources while ensuring data quality and integrity.
- Working with structured, semi structured and unstructured data.
- Implement best practices for data management, security, and governance.
- Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.
Required Skills
- 5+ years SSIS development experience
- 5+ years Python coding experience.
- 5+ years SQL Server based development of large datasets Additional Skills:
- Experience in Financial Services industry
- Experience with Enterprise Schedulers / Orchestration platforms such as Tidal, Airflow.
- Experience in any cloud data warehouse like Snowflake.
- Experience in Data warehousing - OLTP, Dimensions, Facts, and Data modeling.
- Experience with Cloud based data architectures, messaging, and analytics.
- Experience with developing and deploying ETL pipelines using Databricks Pyspark.
Education
- Minimally a BA/BS degree within an engineering and/or computer science discipline
- Master’s degree preferred
Not the right fit? Search for ETL Developer jobs in Toronto, Ontario, Canada
About Rivago infotech
Rivago Infotech Inc has been a leader in IT staffing and Software development for over 5 years and is one of the largest diversity and development firms in the industry. We are known for our high-touch, customer-eccentric approach, offering our clients unmatched quality, responsiveness and flexibility . We are appreciated by our clients for our streamlined execution, highly efficient service and exceptional talent management that go above and beyond traditional staffing services.