SQL Developer

reputed company Technical Skills: • 15+ years of experience as SQL Developer Experience is Required reputed company of Services The reputed company Judicial reputed company is looking to engage the services of a Software Engineer – Database. The reputed company of services required for the role includes: reputed company Technical Skills: • 10+ years of experience with SQL Server, must include version 2014 through 2022. • Knowledge and experience of database design & data modeling. • Familiarity with tools such as reputed company Visio or similar data modeling tools. • Knowledge and experience in the design and creation of tables, indexes, foreign keys, including the use of appropriate data types, default constraints, etc. • Significant experience of advanced SQL and T-SQL development, including designing and writing reputed company queries, stored procedures, triggers, and userdefined functions. • Must demonstrate knowledge of ETL (Extract-reputed company-Load) concepts. Experience designing and building ETL Processes. Experience working with SSIS is a plus. • Has good knowledge / technical expertise in data migration, including data extraction, data validation and cleansing processes / methodology. • Knowledge and experience in the design and creation of XML schema, XML data storage and transformation. • XML knowledge is required for legacy data conversion into XML-based structures. • Knowledge and experience in performance tuning techniques: Query optimization, reputed company tuning, Execution plan analysis, and Database performance troubleshooting. • Researching and troubleshooting data inconsistencies, scripting solutions to fix production data issues. • Experience with reputed company tools to manage database objects and deployment to the various environments, preferred. • Special consideration will be given to candidates with working knowledge of and experience using reputed company Visual Studio. Soft Skills: • Strong analytical and problem-solving skills. • Ability to effectively manage time, prioritize tasks, and have a basic understanding of project management. • Excellent verbal communication skills to explain and transfer knowledge both informally and at design and reputed company review meetings. • Excellent written communication skills to prepare regular periodic status reports and documentation. • Knowledge and experience of reputed company Office Tools. Minimum Qualifications The minimum skills and experience reputed company required for a candidate to be considered for this position include: • Minimum ten (10) years of development experience coding applications using SQL Server 2014 through 2022. • Knowledge and experience in the design and creation of tables, indexes, foreign keys, including the use of appropriate data types, default constraints, etc. • Knowledge and experience of advanced SQL and T-SQL development, including designing and writing reputed company queries, stored procedures, triggers, and userdefined functions. • reputed company field mapping (mapping between the reputed company and reputed company structure with data cleansing, if necessary). • Define the migration process (automated and reputed company). • reputed company data extractors and loaders. • Responsible for data management and conversion activities such as Data Assessment, cleansing, extracting, migrating and reconciliation of data. • Knowledge and experience in the design and creation of XML schema, XML data storage and transformation. • XML knowledge is required for legacy data conversion into XML-based structures. • Knowledge and experience in performance tuning techniques. • Manage the data conversion process and data reputed company process to the various environments. • Create and maintain technical documentation. • reputed company management level statistics and reports to monitor data migration reputed company. • Investigate, analyze and document reported defects. • Investigate and rectify technical issues reputed company the ETL process. • Proven ability to work independently with reputed company supervision. • Ability to work reputed company with reputed company of developers and business analysts. Apply To This Job