Software Developer

Position Summary Software Developer will possess knowledge of SQL Server, SSIS, SSRS, PowerBI, T-SQL and some data modelling experience. This role will provide outstanding analytical and problem solving expertise with a good grasp of technical side of Business Intelligence. PRINCIPLE JOB RESPONSIBILITIES: Maintaining data integrity and security, managing users, privileges, roles, profiles and database resources Involved in Logical & Physical design of the Database, Creation of tables, views, procedures, packages, triggers and other database objects Generating scripts of database objects, writing and debug complex queries Good Exposure in SSRS, SSIS, SSAS and SQL, XML Queries Creation of reports and dashboards using PowerBI Performance Monitoring and tuning of Database and SQL Queries Back-up and recovery procedures Product development knowledge, having familiarity with issues related to database design, schema changes Involved in Scheduling jobs & Monitoring Experience with data migrations and data quality techniques, integration and design methodologies Added advantage Builds strong relationship within the teams, stakeholders and other teams to achieve objectives on delivery time Knowledge of Linked servers, CDC, Service Broker, Resource Governor, Replication, High Availability Experience with tuning database and server for proper memory sizing, I/O distribution, physical space usage, load balancing and system resource allocation. Knowledge of Python Possess good communication skills 1-3 years of SQL Server experience in Product Based IT/Software organization Education BE, B tech, MCA, M Tech, MSC computer science graduate with good spoken English and communication skills Skills BC - Dependability and Reliability BC - Initiative BC - Time Management TC - Python Programming TC - Java TC - Code Review PC - Jiva Product Knowledge FC - Oral Communication FC - Written Communication Competencies BC - Collaboration & Interpersonal Skills FC - Analytical Skills FC - Communication Skills FC - Quality TC - Application Integration design: Web Services and protocols such as SOAP, JSON, REST, WSDL, WSO2 TC - Object Relational mapper ( SQL Alchemy, hibernate etc) (model) TC - Programming languages and Object oriented programming – Python,Java,.Net etc ( Model) TC - Test Driven Development TC - Web Framework - Angular JS ( Front end)