Impact Analytics - Database Engineer - Design & Maintenance

About the job : What this role entails : - Analyze database design and architecture requirements for the distributed applications - Develop, construct, test and maintain existing and new data-driven architectures - Align architecture with business requirements and provide solutions which fits best to solve the business problems - Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources on the Cloud (AWS / GCP). - Using well defined ETL tools like PySpark, Data Flow - Data acquisition and clean up from multiple sources across the organization - Design custom tools to collate the data - Identify ways to improve data reliability, efficiency, and quality - Develop automated tasks for data operations -Deliver updates to stakeholders based on analytics - Set up practices on data reporting and continuous monitoring using Prometheus, ELK or similar tool. What lands you in this role : - Seven or more years as a hands-on technologist with a good mix of application development and database development. - Expert Level Sql, Postgresql, including stored procedures, functions, triggers, and views. - Strong understanding in database design and modelling. - Ability to efficiently write database code without compromising data quality, privacy or security. - Knowledge of database design principles, query optimization, index management, integrity checks, statistics, partitioning and isolation levels - Good understanding of Postgresql replication, high availability and clustering across availability zones and regions - Good understanding of Database backup and restore to align with data laws - Participate in an agile software development life cycle including providing testing guidelines for database related changes. - Good understanding of Programming language, preferably Python for custom scripts - Understanding No Sql and In memory databases is a value add (ref:hirist.tech)

Location: bangalore, IN

Posted Date: 1/15/2025