Database Engineer - SQL/PostgreSQL (10-15 yrs)

Required Skills:

- Strong experience in SQL with expertise in relational database(PostgreSQL preferrable cloud hosted in AWS/Azure/GCP) or any cloud based Data Warehouse (like Snowflake, Azure Synapse).

- Competence in data preparation and/or ETL/ELT tools like SnapLogic, StreamSets, DBT, etc. (preferably strong working experience in one or more) to build and maintain complex data pipelines and flows to handle large volume of data.

- Understanding of data modelling techniques and working knowledge with OLAP systems

- Deep knowledge of databases, data marts, data warehouse enterprise systems and handling of large datasets.

- In-depth knowledge of ingestion techniques, data cleaning, de-dupe, etc.

- Ability to fine tune report generating queries.

- Understanding of index design and performance-tuning techniques

- Familiarity with SQL security techniques such as data encryption at the column level, Transparent Data Encryption (TDE), signed stored procedures, and assignment of user permissions

- Experience in understanding the source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting(desirable).

- Adhere to standards for all database e.g., Data Models, Data Architecture and Naming Conventions

- Exposure to Source control like GIT, Azure DevOps

- Understanding of Agile methodologies (Scrum, Itanban)

- experience with NoSQL database to migrate data into other type of databases with real time replication (desirable).

- Experience with CI/CD automation tools (desirable)

- Programming language experience in Golang, Python, any programming language, Visualization tools (Power BI/Tableau) (desirable).