Job Description:
Job Description
Skill: PostgreSQL developer
1877246
PostgreSQL Developer1 (DB Engineer)
Strong experience with PostgreSQL design and Development.
Strong experience on Python scripting (Shell Scripting as added advantage)
Knowledge on SQL Server and SSIS is must.
Strong Programming skills (pgsql, t-sql)
Knowledge on NoSQL and JSONs is a Plus.
Good Communication skills.DB Sr Engineers Postgres
4 - 8 Years
Required Skills:
? Good knowledge in Database like PostgreSQL (preferably cloud hosted), any cloud based Data Warehouse (like Snowflake , Azure Synapse) with strong programming experience in SQL.
? Competence in data preparation and/or ETL tools like snapLogic, MATILLION, Azure Data Factory, AWS Glue, SSIS (preferably good exposure in one or more) to build and maintain data pipelines and flows.
? Programming language experience in Golang, Python, shells scripts (bash/zsh, grep/sed/awk etc..).
? Good 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.g., 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.
? Understanding of data modelling techniques and working knowledge with OLTP and OLAP systems
? Experience with automated testing and coverage tools
? Experience with CI/CD automation tools (desirable)
Purview is a leading Digital Cloud & Data Engineering company headquartered in Edinburgh, United Kingdom having a presence in 14 countries India (Hyderabad, Bangalore, Chennai and Pune), Poland, Germany, Finland, Netherlands, Ireland, USA, UAE, Oman, Singapore, Hong Kong, Malaysia and Australia.
We have a strong presence in UK, Europe and APEC, providing services to Captive Clients (HSBC, NatWest, Northern Trust, IDFC First Bank, Nordia Bank etc) in fully managed solutions and co-managed capacity models. Also, we support various top IT tier 1 organisations (Capgemini, Deloitte, Wipro, Virtusa, L&T, CoForge, TechM and more) to deliver solutions and workforce/resources.
Company Info:
3rd Floor, Sonthalia Mind Space
Near Westin Hotel, Gafoor Nagar
Hitechcity, Hyderabad
Phone: +91 40 48549120 / +91 8790177967
Gyleview House, 3 Redheughs Rigg,
South Gyle, Edinburgh, EH12 9DQ.
Phone: +44 7590230910