Ave Promagne is Looking for Data engineer SSIS/ Azure / SQL / Data Engineering Full Time

Job Summary:

Duties and responsibilities:
• Develop underlying data models and databases for successful database applications
• Develop, manage and maintain data dictionary and or metadata
• Translate business requirements into effective database objects and models
• Perform SQL development – to write, execute and troubleshoot SQL code and design (stored procedures, functions, views, triggers)
• Be aware of potential blocking, deadlocking and write code to avoid those situations

Job Description
• Resolve and troubleshoot complex SQL issues
• Optimize database objects and server settings for better performance
• Fine tune the Complex queries/stored procedures to get fast responses
• Normalizing the databases to avoid anomalies without affecting business requirements
• participate in discussions involving the application creation and understand the requirements and

provide the back-end functionality for the applications.
• Provide data management support to users
• Maintain and manage all versions of data models for production, testing and developing databases
• Perform Database maintenance activities periodically
• Ensure compliance of standards and conventions in developing programs
• Prepare Database maintenance plan and Database Backup and Restore
• Create cubes in SSAS
• Design, Develop and Deploy SSIS Packages
• Validate data in the database, testing and debugging ETL processes built in SSIS
• Provide ongoing maintenance and support of assigned ETL applications
• Migrate databases from old versions to new version
• Design and implement a plan for all types of data movement or modifications defined in project scope
• Write documentation in compliance with Client standards

Locations :

Kerala, Tamil Nadu, Uttar Pradesh , Madhya Pradesh , Andhra Pradesh, Jammu and Kashmir, Utrakhand, Rajasthan, Gujrat, Maharashtra, Orissa, Assam, Manipur, WB, HP, Delhi,Mumbai,Bangalore