Job Description
Hi Team,
Arthur Grand Technologies is currently seeking a highly motivated and skilled Software Developer - ETL - Seniorfor one of our clients
Position:Software Developer - ETL - Senior
Location:, Toronto ,ON
Duration: Long Term Contract
MANDATORY REQUIREMENTS:
- 5+ years of proven working experience with SQL Server, Oracle, Azure SQL Databases
- Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
- Experience with SQL Server Management Studio, Azure data management tools, data modeling tools (preferably, ERWIN), DevOps
- Experience with at least one programming language (Python, Java, C#, etc.)
- Experience with Azure Data Factory (ADF)
SKILLS AND KNOWLEDGE:
- 5+ years of proven working experience with SQL Server, Oracle, Azure SQL Databases
- Expert knowledge and experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
- Experience with SQL Server Management Studio, Azure data management tools, data modeling tools (preferably, ERWIN), DevOps, Synapse Studio
- Experience with at least one programming language (C#, Python, Java, etc.)
- Experience with Azure Data Factory (ADF) and Synapse Link for SQL
- Experience with data warehousing technologies such as snowflake
- Familiarity with Azure cloud platform
- Excellent problem-solving and analytical skills
- Strong communication and teamwork skills
Criteria 1 - Data Migration, ETL
- Demonstrated experience with SQL Server (2012+), Oracle (11+), Azure SQL Databases
- Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning
- Demonstrated experience with SQL Server Management Studio, data modeling tools (preferably, ERWIN), DevOps
- Demonstrated experience with at least one programming language (Python, C#, Java, etc.)
- Experience with software development lifecycle
- Experience with data modeling, physical database design, data flow diagrams
Criteria 2 - Data Warehouse and Reporting
- Experience with data warehousing technologies such as snowflake
- Experience with data marts development
- Experience with report development and tools, preferably Power BI
- Experience with supporting a data warehouse in a production environment
Criteria 3 - Azure Platform
- Experience with Azure Data Factory (ADF) and Synapse Link for SQL
- Demonstrated experience Azure data management tools, DevOps, Synapse Studio
- Familiar with Azure cloud platform
Criteria 4 - Interpersonal and Communication Skills
- Excellent problem-solving and analytical skills
- Excellent communication and teamwork skills
- Demonstrated ability to perform independently and in a team
About Arthur Grand Technologies:
Arthur Grand Technologies is a leading provider of staffing and technology consulting services. Our company is managed by a team of professionals who have worked for big 5 consulting firms for 20+ years. We are a minority-owned staff augmentation and technology consulting company.
At Arthur Grand Technologies, we value our employees & contractors and strive to provide them with challenging, interesting work, market-relevant benefits, and opportunities for professional growth. If you have the necessary qualifications, and are excited to join a dynamic team, please send your resume to afrah.faiza@arthurgrand.comfor immediate consideration.
Thank you for considering Arthur Grand Technologies. We look forward to hearing from you soon
Job Type: Fixed term contract
Contract length: 12 months
Salary: From $65.00 per hour
Schedule:
Ability to commute/relocate:
- Toronto, ON: reliably commute or plan to relocate before starting work (required)
Experience:
- Oracle Siebel CRM: 3 years (preferred)
- Data Migration: 4 years (preferred)
- SQL: 4 years (preferred)
- ETL: 9 years (preferred)
- Data warehouse: 5 years (preferred)
- Azure: 5 years (preferred)