Administrador de Dados / Modelador de Dados (PowerDesigner)
J
JobgetherSecurity & IT
BrazilFull-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- SQLAgileETLNosqlData modeling
Requirements
- Proven professional experience in conceptual, logical, and physical data modeling, including relational and multidimensional modeling.
- Strong practical expertise with SAP PowerDesigner.
- Advanced knowledge of SQL and related data languages and technologies, including DDL, DML, DCL, Transaction SQL, and SQL Plus.
- Experience administering and/or modeling data in relational and NoSQL database management systems.
- Familiarity with database technologies such as Oracle, DB2, Sybase, PostgreSQL, SQL Server, MongoDB, InfluxDB, and Apache Hawq/Impala.
- Experience with the Informatica suite, particularly PowerCenter, PowerExchange, Data Quality, and Metadata Management.
- Knowledge of data integration architectures, including ETL specifications, database links, and database-based services.
- Experience working with Very Large Databases (VLDBs), including database performance analysis and table-partitioning techniques.
- Understanding of data governance, metadata management, data quality, and enterprise data architecture principles.
- Knowledge of Agile methodologies such as Scrum, Kanban, XP, and the Agile Manifesto.
Responsibilities
- Create, propose, maintain, and update conceptual, logical, and physical data models using SAP PowerDesigner.
- Develop relational and multidimensional data models aligned with business and technical requirements.
- Ensure data structures are properly normalized, reducing redundancy and maintaining logical consistency.
- Manage and maintain metadata quality in accordance with established data management and governance methodologies.
- Design data-service architectures across relational, analytical, and NoSQL ecosystems to support BI and Big Data applications.
- Collaborate with DBAs on physical database implementation, including table partitioning and performance optimization.
- Specify data integration mechanisms, including ETL processes, database links, and database services.
- Provide consulting, technical support, and mentoring to business and technology teams.
View Full Description & ApplyYou'll be redirected to the employer's site
