Semi-Senior SQL Analyst Programmer

Description

Job Summary: IDM Technology is seeking a Semi-Senior SQL Analyst Programmer to manage and develop information integration processes, optimize queries, and provide technical support. Key Responsibilities: 1. Manage business information extraction processes 2. Develop and maintain information integration processes 3. Perform activities on SQL Server databases Job Description: IDM Technology, specialists in IT solutions, is looking for a Semi-Senior SQL Analyst Programmer to join a major company in the region. **Responsibilities:** * Manage business information extraction processes related to Life Collections. * Analyze and map functional requirements for data integration within the Life Peripherals domain. * Develop and maintain information integration processes, ensuring data quality and consistency. * Execute technical and functional tests associated with implemented developments. * Perform activities primarily on SQL Server databases, optimizing queries and processes. * Provide technical support for information management and resolution of incidents related to data processes. **Requirements:** * Proficiency in relational databases (MSSQL 2016 or later, Oracle 11g or later). * Programming in Transact SQL and PL/SQL. * Knowledge of SSIS package development and deployment. * Development in Visual (VB) .NET and C#. * SQL certification. * Git Flow proficiency. * Application of Agile SCRUM methodology. * Object-oriented programming (SOAP/REST service development, .NET Core 6.0 or later). * Understanding of APIs and consumption of REST services. * Java development experience. Salary: Up to S/.6,000.00 per month Application Questions: * Do you have 3 or more years of experience working with relational databases (MSSQL 2016 or later, Oracle 11g or later)? * Do you have 3 or more years of experience in Transact SQL and PL/SQL programming? * Do you have knowledge of SSIS package development and deployment? * Which SQL certifications do you hold? * Do you have 3 years of experience in Visual (VB) .NET and C# development? Work Location: Hybrid in San Isidro, Lima