Software Developer - ETL - Senior

LanceSoft Inc

Toronto, OH

JOB DETAILS
JOB TYPE
Full-time
SKILLS
Cloud Computing, Data Management, Data Migration, Data Modeling, Data Quality, Database Administration, Database Extract Transform and Load (ETL), DevOps, Microsoft Dynamics, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Performance Analysis, Performance Tuning/Optimization, Query Analysis, SQL (Structured Query Language), SQL Databases, Software Development, Software Testing, Test Automation, Test Data, Testing
LOCATION
Toronto, OH
POSTED
30+ days ago
Role: Software Developer - ETL - Senior Location: Toronto, ON, (Hybrid) Duration: 08 Months Contract With 12 Month possible extension. Job Description: Requires a Senior Software Developer ETL to validate the data migration from the existing OPGT legacy applications to the new Dynamics 365 OPGT solution. Resumes Evaluation/Criteria: Criteria 1: Data Migration - ETL - 30 Points Demonstrated experience with data migration from legacy applications to Dynamics 365 Client as ETL developer. Demonstrated experience with ETL development, data pipelines, workflow orchestration and data ingestion, transformation, and movement. Demonstrated experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services. Demonstrated experience working with Azure Synapse workspaces, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring. Criteria 2: Data Migration - Testing - 30 Points Deep knowledge of data manipulation languages (T-SQL), data modelling, query performance analysis & tuning. Demonstrated experience with SQL Server, Azure SQL Databases and Dataverse. Demonstrated experience with designing, implementing, and supporting solutions to automate data migration testing to Dynamics 365 Criteria 3: Dynamics 365 Client - 30 Points Strong understanding of the Dynamics 365 data model, entities, and relationships. Experience conducting application data migration testing or data quality testing for model-driven apps in Dynamics 365. Familiarity with Dataverse and Power Platform application development. Criteria 4: DevOps and Test Plans - 10 Points Demonstrated experience with Azure DevOps, test plans. Must haves: 5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes. Strong SQL skills and experience working with Azure SQL Databases and Dataverse. Knowledge of Microsoft Dynamics 365 Customer Engagement (Client). Nice to have: Azure cloud certifications (e.g. Azure fundamentals, Azure Data Engineer associate, Azure Database Administrator associate)

About the Company

L

LanceSoft Inc

We are a $125 Million, NMSDC-certified Minority & Woman owned Workforce Solutions Company headquartered in the DC metro area with presence across US with global presence - Canada, Mexico, India, UK, Malaysia, Indonasia, Hongkong, Singapore, UAE. We are specialized in providing Workforce Solutions, SOW project delivery, Engineering Solutions, Creative Services. We currently support 100+ Fortune companies globally and across multiple industry segments. We are currently supporting several massive programs across industry segment nationally/globally (Intel, Ally, AMD, QUALCOMM, Morgan Stanley, Kraft/ Mondelez, MNP, Amdocs, Dell, SanDisk, Medtronic, Becton Dickinson, GE, Lockheed Martin, UTC, L-3 Communications, Caterpillar, BMW, Mercedes Benz, National Grid, Dominion, Energy Future Holdings, PSEG, 3M, Fidelity, Aetna, Humana, Johnson & Johnson, Pfizer, Merck etc). 

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, identity, national origin, disability, or protected veteran status.

COMPANY SIZE
2,000 to 2,499 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
2000
WEBSITE
http://www.lancesoft.com/