Senior Software Engineer

SeniorSoftwareDeveloper Pune, Hybrid We are the most trusted provider of data collection and management, marketing program management, and analytical solutions for our Crop and Animal Health industry clients. With data services at the core—surrounded by an extensible array of streamlined software solutions— our unified platform represents over three decades of innovation and expertise in the agriculture, crop protection, specialty chemical and animal health industries. Backed by an entrepreneurial, creative and energetic work force, teammates at AGDATA are pushing the boundaries of technology to enhance our relationships with our clients. We are a growing team, focused on adding creative, knowledgeable individuals who are ready to jump right in and make an immediate impact. 30+ years of experience in the Crop and Animal Health industry More than 20billionUSDsales processedannually Over 2,15,000 payments issued via marketing programs yearly Visit us on  What’sthe role? AGDATA is looking for an experienced Senior Software Engineer (SQL & SSIS) to lead in the development of SQL databases for a wide variety of applications and business uses. You should bring experience with data architecture and management to develop and scale SQL databases based on organization’s needs. Moreover, you’ll need to write SQL queries and stored procedures, strong in ETL using SSIS. You should be a quick thinker, highly organized and able to troubleshoot any number of issues that can come up during the day-to-day operations. Ouridealcandidatewillhave… 5+ years direct experience as a SQL Developer. 3+ years’ experience in ETL tools (SSIS) Proven Microsoft T-SQL skills. Experience or exposure in C#, .Net is preferred. 3+ years of Data Analysis in a financial institution is preferred. Demonstrated knowledge of large, relational databases and data structures. Strong understanding of ETL concepts. Proficient in standard business and database software including MS Office, MS Access, and SSMS. Excellent communication and presentation skills with demonstrated ability to converse with all levels of staff and management. Strong quantitative skills, attention to detail, and a high aptitude for problem solving. Able to work as a team player with Application Developers, Database administrators and operational personnel. Experience with Agile using JIRA software, Confluence or combination of both. Experience using Azure DevOps Understanding of EDI Processes (Business to Business) Inthis role, you will have the opportunity to… Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.). Independently analyze and correct issues in real time, providing end-to-end problem resolution. Refine and automate regular processes, track issues and document changes. Evaluate business data and recommend appropriate analytic approaches/strategies to achieve stated objectives. Perform analyses to drive business decisions and optimize expense/efforts for database enhancements and support. Provide statistical analysis to develop, test, and optimize databases to their full potential. Assist in testing efforts for database use. Create regular reporting summarizing key metrics and trends to key team members and Management. Establish best practices for a growing team of SQL Developers. Effectively prioritize and manage concurrent projects, demonstrate initiative, and work independently with minimal supervision. Drive results and leverage past experiences to improve the environment and related processes. Coordinate with other agency departments to update and integrate processes as necessary. Apply data modeling techniques to ensure integration and performance expectations are met as well as allow for future flexibility to meet changing business needs How AGDATA will support you: Supportingyourhealth&well-being: Comprehensive medical coverage – up to INR 7.5 lakh for employee and dependents, including parents. OPD benefit – coverage of up to INR 15 thousand covering expenses across specialties. Paternity leaves up to 14 working days with the option to split leave. Emphasizingworklifebalance:Flexiblehybridworkpolicy Experiencingaworkculturethatpromotesfromwithin:In2023,13%of ourassociateswere promoted internally.