Data Migration SQL Developer
Michael Page Parramatta
About Our Client
- The Data MigrationSQL Developer role focusing on:
- Stakeholder collaboration for business needs and requirements analysis
- Development of migration framework, tools, and reports on migrated data
- Data cleansing activities including masking, extraction, transformation, loading, and reconciliation
- Interface development for business users to view migrated/archived data
- Analysing Data Migration requirements
- Building SQL ETLs (Scripts, Stored Procedures, Functions)
- Using ETL tools for data transformation and loading
- Data profiling and cleansing of legacy data
- Defining technical architecture and migration strategies
- Executing data migration runs and ensuring data quality
- Implementing Source Code Security tools (GitHub, etc)
- Creating Technical Detailed Design Documentation (JIRA, Confluence, etc)
- 10+ years experience in MS SQL, Oracle, and Informix databases
- Strong proficiency in MS SQL coding, SSIS, SSRS, and SQL Server ETL technologies
- Familiarity with GitHub, Visual Studio, Visual Code, and other Source Code Security technologies
- Expertise in Data Analysis, ETL, Data Cleansing, Data Profiling, and Data Migration techniques
- Experience with large datasets and scripting using PowerShell and T-SQL
- Excellent written, verbal, and interpersonal communication skills
- Experience with data migration to MS Dynamics
- Agile Methodologies and Atlassian Tools (JIRA, Confluence)
What's on Offer
Working Conditions:
- Flexible working environment
- Innovative technology ecosystem
- Australian Citizen or Permanent Resident
- Baseline National Security Clearance required
- Covid Vaccination Certificate mandatory
Robert WaltersSydney NSW, 20 km from Parramatta
Join this household name on a long-term contract. Experience w/ SQL + Sabre (or within the airline, travel or aviation field) is a must. Hybrid setup.
Skills/experience:
• 8+ years’ experience in testing
• Strong communication skills a must...
AmazonSydney NSW, 20 km from Parramatta
Experience with large data sets and insight generation using Excel, SQL, or other data analysis tools
• Experience driving direction and alignment across cross-functional internal teams
• Ability to work autonomously within a fast-moving and often ambiguous...
Zone IT SolutionsSydney NSW, 20 km from Parramatta
Good to have in any of these skills - API, Mobile (Perfecto, Appium, etc.) and Web (Cypress, Webdriver IO, Selenium Webdriver, etc.)
• Java experience, using BDD cucumber framework for automation with Selenium (data automation), and familiarity with SQL...