Job Title

Location: Parramatta, Sydney (hybrid working model 3 days in office)Rate on offer upto $880 per day (Incl super)Opportunity to get Baseline Clearance sponsored by clientCandidate must hold Australian Permanent Residency Visa or CitizenshipKey AccountabilitiesAnalyse the Data Migration requirementsBuild SQL ETLs (SQL Scripts, Stored Procedures, Functions and other SQL Coding)Build SSIS PackagesTransformation of data and use of Data loading tools (ETL tools)Data Profiling and Cleansing of legacy dataDefine technical architecture, design, and strategies for migration processDevelopment, deployment, and execution of data migration runsWorking with Business and Data Analysts to define business rules for data quality management and migration.Implement and use of Source Code Security tools (GitHub, etc)Complete Technical Detailed Design Documentation (JIRA, Confluence, etc)Role & Responsibilities10 years+ experience in MS SQL, Oracle, and Informix databases.Extensive hands-on experience in MS SQL Coding and writing SQL ETLs (Stored Procedures, Functions, and other SQL Scripting).Extensive experience in ETL Tools on SQL Server technologiesStrong experience in GitHub, Visual Studio, Visual Code, and other Source Code Security technologies.Strong experience in Data Analysis, ETL, Data Cleansing, Data Profiling and Data Migration techniques.Strong experience in working with large datasets.Experience in Scripting and Automation using PowerShell and T-SQL.Excellent written, verbal, and interpersonal communication skills.Experience with data migration to MS Dynamics.Experience in Agile MethodologiesExperience in Atlassian Tools (JIRA, Confluence, etc) #J-18808-Ljbffr