Overview: Wipro Ltd, with 75 years of expertise, delivers Global Information Technology, Consulting and Business Process Services in Cognitive Computing, Hyper-automation, Robotics, Cloud, Analytics, and Emerging Technologies for international leading organizations across the world in diverse domains such as Aerospace and Defense, Capital Markets, Banking, Retail, Utilities, Platform and Software Products, Healthcare, Insurance, Oil and Gas, and many others.
Alongside large international partners, we strive to empower our clients' success.
With over 200,000 dedicated employees serving clients across six continents, our values are: be passionate about client success, treat every person with respect, be global and responsible, and maintain unyielding integrity in everything we do.
We are actively looking for a Senior Database Engineer (H/F) based in Madrid.
Qualifications: Education: Bachelor's degree (BA/BS) in a related field such as information systems, mathematics, or computer science, or equivalent work experience.
Required Skills: 2 to 5 years of relevant work experience.
Requires technical knowledge in multiple disciplines/processes.
Expert knowledge in databases like PostgreSQL (preferably cloud-hosted) and 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 strong working experience in one or more) to build and maintain data pipelines and flows.
Programming language experience in Golang, Python, shell scripts (bash/zsh, grep/sed/awk, etc.).
Deep knowledge of databases, stored procedures, and optimizations of large datasets.
In-depth knowledge of ingestion techniques, data cleaning, de-duplication, and partitioning.
Experience with building 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, and 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 source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting.
Adhere to standards for all databases, 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 databases to migrate data into other types of databases with real-time replication.
Understanding of data modeling techniques and working knowledge with OLTP and OLAP systems.
Experience with automated testing and coverage tools.
Experience with CI/CD automation tools (desirable).
Roles & Responsibilities: Create and maintain optimal data pipeline architecture.
Assemble large, complex data sets that meet functional/non-functional business requirements.
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and cloud database technologies.
Work with stakeholders including the Executive, Product, Data, and Design teams to assist with data-related technical issues and support their data infrastructure needs.
Keep our data separated and secure across national boundaries through multiple data centers and regions.
Work with data and analytics experts to strive for greater functionality in our data systems.
Test databases and perform bug fixes.
Develop best practices for database design and development activities.
Ability to quickly analyze existing SQL code and make improvements to enhance performance, take advantage of new SQL features, close security gaps, and increase robustness and maintainability of the code.
Take on technical leadership responsibilities of database projects across various scrum teams.
Manage exploratory data analysis to support database and dashboard development.
#J-18808-Ljbffr