Database Python Engineer

Required Skills:

- Strong experience in SQL with expertise in Database like PostgreSQL (preferably cloud hosted in any one or more cloud offerings like AWS, Azure, GCP) or any cloud based Data Warehouse (like Snowflake, Azure

Strong programming experience in Python.

-Competence in data preparation and/or ETL tools like SnapLogic, Azure Data Factory, A WS Glue, SSIS, MATILLION (preferably strong working experience in one or more) to build and maintain data pipelines and flows.

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

-Deep knowledge of databases, stored procedures, optimizations of huge data.

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

-Experience with building the infrastructure required for data ingestion and analytics

-Ability to fine tune report generating queries

-Solid understanding of normalization and denormalization of data, database exception handling, transactions, profiling queries, performance counters, debugging, database & query optimization techniques 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

-Adhere to standards for all database e.., Data Models, Data Architecture and Naming Conventions Exposure to Source control like GIT, Azure DevOps Understanding of Agile methodologies (Scrum, Kanban)

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

-Experience with Cl/CD automation tools is desirable.

-strong hands on experience in Kafka and integration systems in addition to Data or DB engineering skills.