Integration Engineer Jobs

Position:IntegrationEngineer(Financial/ETL/SSIS)

Location: Montreal, QC

Need local candidate.

Client looking for skill sets in ETL and SSIS. The long term goal of the client however is to move from SSIS to python, so If you have candidates that have some python knowledge they can be our priority profiles.

Responsibilities:

• Responsible for extracting and copying business data and loading it into a data warehousing environment that they have designed.
• Must have experience creating highly efficient and customized warehouse environments that perfectly suits the data storage needs of the company.
• Must have extensive knowledge of coding languages, especially python and warehouse architecture and be able to clearly communicate your ideas to the company.
• Need to have both design and programming skills as they are also responsible for testing the performance of the system and troubleshooting any problems before it goes live

Essential Responsibilities/Duties:

• Consulting with data management teams to get a big-picture idea of the company’s data storage needs.
• Conducting preliminary testing of the warehousing environment before data is extracted.
• Presenting the company with warehousing options based on their storage needs.
• Testing the new storage system once all the data has been transferred.
• Designing and coding the data warehousing system to desired company specifications.
• Develop/Maintain data mapping confluence pages based on data hosted by company warehouse
• Leads the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
• Translates data access, transformation, and movement requirements into functional requirements and mapping designs.
• Providing maintenance support.
• Extracting company data and transferring it into the new warehousing environment.
• Troubleshooting any issues that may arise.
• Develops logical and physical data flow models for ETL applications.
• Develop/Maintain confluence pages to track all data warehouse implementations and specifications

Skills:

• 5+ years - SQL Server based development of large datasets
• 3+ years’ experience in Finance / Banking industry – some understanding of Securities and Banking products and their data footprints
• 4+ years with Data Warehouse Architecture, Snowflake experience preferred
• 5+ years Python coding experience
• PL/SQL Server development experience
• 7+ years - Enterprise Data Management
• Experience with Azure Data Factory and Azure Databricks

Thanks & Regards

Shikha Bajpai

US IT Recruiter

3B Staffing LLC

485B US Highway 1 S, STE 300, Iselin,

New Jersey 08830, United States

Contact no:(973) 587-6914 EXT-(537)

Email id:[email protected]

Website:www.3bstaffing.com