However, you have to run reverse engineering (RE) processes manually and limit them to your work day. Strong experience in database sql tuning and performance improvementĮxperience with multiple relational databases platforms like oracle, exadata, ms sql serverĮxposure to data integration tools like oracle data integrator (odi), informatica etc.Įxposure to business intelligence/ reporting platforms like obiee, microstrategy, business objects etc.Įxposure to data visualization/ dashboarding tools like tableau, qlik etc.One of the major features of erwin Data Modeler (DM) is its capability to reverse engineer from databases. Strong knowledge and experience in sql and sql procedures for data analysis, extraction and manipulation
Strong data modeling skills utilizing one of the industry leading tools like er/studio, erwin data modeler, oracle sql developer etc. Strong analytical skills and troubleshooting skills Strong skills in analyzing data warehouse performance issues and resolutions using various methods/ techniques Strong skills in sql, sql procedure builds Well versed in data modeling tools like er/studio, erwin data modeler, toad data modeler etc., Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks. Work with business and solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization. Validate business data objects for accuracy and completeness.Īnalyze data-related system integration challenges and propose appropriate solutions. Perform reverse engineering of physical data models from databases and sql scripts.Įvaluate data models and physical databases for variances and discrepancies. Understand and translate business needs into data models supporting long-term solutions.Ĭreate logical and physical data models using best practices to ensure high data quality and reduced redundancy.ĭevelop best practices for standard naming conventions and coding practices to ensure consistency of data models. Implement business and it data requirements through new data strategies and designs across all data platforms (relational, dimensional, and nosql) and data tools (reporting, visualization). Responsible for adherence to operational policies and achievement of portfolio performance to support business plansResponsible for solution and pricing of proposals and supporting the sales processIs accountable for managing a profitable revenue streamTypically manages a relatively small number of individual contributing project managersProvides oversight to projects within the portfolio to ensure high customer satisfaction in a profitable manner.ĭemonstrated ability to follow solid project management principles and successfully manage projects of increasing complexit圜omfortable working in a matrix management environmentStrong influencing and negotiation skills to deal with internal stakeholders, customers, and vendorsProduct, technology or industry expertise relevant to the portfolio focusSelling skills preferredAbility to travel as needed.ġ0+ years of experience in data modeling and responsible for the development of the conceptual, logical, and physical data models, the implementation of rdbms, operational data store (ods), data marts, and data lakes on target platforms (sql/nosql). This manager-level position is responsible for a segment within a given project portfolio which can be defined by industry, service line, technology center, specialty area or regionMain responsibilities include people management, project oversight, and sales enablementAccountable for operational/financial metrics and maintaining project/portfolio profitability while ensuring quality of project delivery and maintaining customer referenceability.