Data Integration Engineer (SSIS)
About the role
Role : Sr. Data Integration Engineer
Location : Ottawa / Toronto (Hybrid) Skills: Strong focus on Snowflake, SQL, SSIS, Python, Data Warehouse, Databricks 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 that is 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 writing SQL queries and programming including stored procedures and reverse engineering existing process.
- 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 Data Integration Engineer jobs in Ottawa, Ontario, Canada
About E-Solutions
"Connecting Technology with Talent”
Founded in 2003, we are in our 22+ years of existence. We are a talent-driven talent acquisition company providing individual consultants, project teams, and strategic outsourcing services to clients in various industries.
E-Solutions is a certified minority-owned staffing firm spearheaded by industry experts. We offer award-winning solutions for the Global Talent Cloud. Our services include:
- Staffing & Recruitment Services
- Payroll Services
- HR & Compliance Service
- Rebadging & Vendor Management Office
- EOR & AOR Services
- Onboarding & Timesheets Service
- Workforce Solutions
- BOT/BOOT Services
- Cloud Sol
We leverage our recruiting expertise to deliver high-end consulting services for various engagements. E-Solutions, Inc. has developed a business structure with no boundaries, which means we work as one collective entity. Our MSP partners and end customers have recognized our commitment to a partnering supplier model enabling us to expand to our present feat:
- 30+ Countries: 150+ Operational Centers
- 6500+ Professionals on Projects
- Revenue ~$250+ Million
Our clients extend from Fortune 500s to IT Companies, and we're experts at finding the right combination of solutions & and solutions to fit any company's unique environment.
We partner with talent ranging from IT professionals to engineering to skilled trades and many more. Our vast experience has provided us with a depth of knowledge spanning industries and technologies.
The following are the industry verticals that we serve: -
- BFSI
- ITES
- Healthcare
- Energy & Utilities
- Light Engineering
- Warehouse & Logistics
- Administrative & Support Services
Disclaimer E-Solutions Inc. Provides Equal Employment Opportunities (EEO) To All Employees And Applicants For Employment Without Regard To Race, Color, Religion,
Similar Jobs
Data Integration Engineer (SSIS)
About the role
Role : Sr. Data Integration Engineer
Location : Ottawa / Toronto (Hybrid) Skills: Strong focus on Snowflake, SQL, SSIS, Python, Data Warehouse, Databricks 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 that is 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 writing SQL queries and programming including stored procedures and reverse engineering existing process.
- 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 Data Integration Engineer jobs in Ottawa, Ontario, Canada
About E-Solutions
"Connecting Technology with Talent”
Founded in 2003, we are in our 22+ years of existence. We are a talent-driven talent acquisition company providing individual consultants, project teams, and strategic outsourcing services to clients in various industries.
E-Solutions is a certified minority-owned staffing firm spearheaded by industry experts. We offer award-winning solutions for the Global Talent Cloud. Our services include:
- Staffing & Recruitment Services
- Payroll Services
- HR & Compliance Service
- Rebadging & Vendor Management Office
- EOR & AOR Services
- Onboarding & Timesheets Service
- Workforce Solutions
- BOT/BOOT Services
- Cloud Sol
We leverage our recruiting expertise to deliver high-end consulting services for various engagements. E-Solutions, Inc. has developed a business structure with no boundaries, which means we work as one collective entity. Our MSP partners and end customers have recognized our commitment to a partnering supplier model enabling us to expand to our present feat:
- 30+ Countries: 150+ Operational Centers
- 6500+ Professionals on Projects
- Revenue ~$250+ Million
Our clients extend from Fortune 500s to IT Companies, and we're experts at finding the right combination of solutions & and solutions to fit any company's unique environment.
We partner with talent ranging from IT professionals to engineering to skilled trades and many more. Our vast experience has provided us with a depth of knowledge spanning industries and technologies.
The following are the industry verticals that we serve: -
- BFSI
- ITES
- Healthcare
- Energy & Utilities
- Light Engineering
- Warehouse & Logistics
- Administrative & Support Services
Disclaimer E-Solutions Inc. Provides Equal Employment Opportunities (EEO) To All Employees And Applicants For Employment Without Regard To Race, Color, Religion,