6 Dwh Implementation Jobs

Mandatory skills: • Min 7+ years of hands-on experience in creating Pl/SQL functions, stored procedures, packages, views, triggers, collections, complex querying techniques, Query optimization/Performance tuning techniques, indexes( all are mandatory). Real life troubleshooting skills also must. • Min 3 years of experience in ETL (Extraction, Transformation and Loading) using Oracle custom scripts or an ETL tool • Min 1 year of experience in Unix commands and scripting • Flexibility to work in any RDBMS database tech like MSFT or Oracle. • Should be well versed in RDBMS constructs and CAP Theory. • Should be able to explain the redo and rollback functionalities in RDBMS • Should be able to explain performance by design constructs for different types of data stores like OLTP and OLAP • Should be aware of Bill Inmon Vs Ralph Kimball school of thoughts in data warehouse constructs and should be able to articulate the pros and cons of the design principles • Should be able to understand and articulate multiple data modelling design principles like Canonical data model, ER model , Start schema, Data lake, etc. Good to Have: • Agile Technique experience is highly desirable • Experience with NoSQL databases, such as HBase, Cassandra, MongoDB are highly desirable

Mandatory skills: • Min 7+ years of hands-on experience in creating Pl/SQL functions, stored procedures, packages, views, triggers, collections, complex querying techniques, Query optimization/Performance tuning techniques, indexes( all are mandatory). Real life troubleshooting skills also must. • Min 3 years of experience in ETL (Extraction, Transformation and Loading) using Oracle custom scripts or an ETL tool • Min 1 year of experience in Unix commands and scripting • Flexibility to work in any RDBMS database tech like MSFT or Oracle. • Should be well versed in RDBMS constructs and CAP Theory. • Should be able to explain the redo and rollback functionalities in RDBMS • Should be able to explain performance by design constructs for different types of data stores like OLTP and OLAP • Should be aware of Bill Inmon Vs Ralph Kimball school of thoughts in data warehouse constructs and should be able to articulate the pros and cons of the design principles • Should be able to understand and articulate multiple data modelling design principles like Canonical data model, ER model , Start schema, Data lake, etc. Good to Have: • Agile Technique experience is highly desirable • Experience with NoSQL databases, such as HBase, Cassandra, MongoDB are highly desirable

Mandatory skills: • Min 7+ years of hands-on experience in creating Pl/SQL functions, stored procedures, packages, views, triggers, collections, complex querying techniques, Query optimization/Performance tuning techniques, indexes( all are mandatory). Real life troubleshooting skills also must. • Min 3 years of experience in ETL (Extraction, Transformation and Loading) using Oracle custom scripts or an ETL tool • Min 1 year of experience in Unix commands and scripting • Flexibility to work in any RDBMS database tech like MSFT or Oracle. • Should be well versed in RDBMS constructs and CAP Theory. • Should be able to explain the redo and rollback functionalities in RDBMS • Should be able to explain performance by design constructs for different types of data stores like OLTP and OLAP • Should be aware of Bill Inmon Vs Ralph Kimball school of thoughts in data warehouse constructs and should be able to articulate the pros and cons of the design principles • Should be able to understand and articulate multiple data modelling design principles like Canonical data model, ER model , Start schema, Data lake, etc. Good to Have: • Agile Technique experience is highly desirable • Experience with NoSQL databases, such as HBase, Cassandra, MongoDB are highly desirable

Greetings!!! This is in regard to a Job opportunity for Technical Program Manager_Data Warehousing & BI with Datamatics Global Services Ltd. Position: PeopleSoft Solution Architect Website: https://www.datamatics.com/ Job Location: Dubai (Onsite)/ Mumbai / Bangalore Job Description: We are looking for Technical Program manager to lead Data Warehouse and BI projects Essential Duties and Responsibilities: Understand the business requirement and project in detail Define the project scope, estimation of resources and timelines, goals, deliverables & measures of success Ensure the team is thoroughly trained on application / technology Guide the team in creating a detailed project work plan & timeline Conduct and oversee project implementation and evaluate the progress regularly Ensures all project information is appropriately documented Track deliverables; Monitor and report on project(s) progress to client/stakeholders Ensure execution and quality of the work basis set benchmarks Manage team and client issues / escalations / impediments to effective closures. Implement and manage change when necessary to meet project outputs Contribute to continuous improvement in terms of productivity Ensure process / product quality parameters compliance Manage budget & allocate project resources Maintain project margins and profitability, ensuring zero revenue leakage People, Client and Stakeholder management Support in presales & create / review estimations Act as a mentor for technical solutions as and when required Provide Data Warehouse and Business Intelligence subject matter expertise and leadership Qualifications: 10 to 15 years of experience with 5 to 8 years of project / program management experience 5+ years hands on experience with managing and leading data warehouse projects preferably with Banking experience Ability to establish and maintain effective working relationships with clients, project team members, supervisors, and employees from other departments. Strong knowledge and hands on experience development data warehouse. Excellent conflict resolution skills is required. Strong interpersonal skills. Must be able to learn, understand, and apply new technologies. Ability to effectively prioritize and execute tasks in a high-pressure environment is crucial. Hands on experience with a Tier I BI tool is desired (experience with PowerBI/Business Objects is a plus) Bachelors degree in computer science, information system, computer engineering or equivalent PMI/PMP or Prince2 certification is required

US Client Facing Role - Required Strong Comm Skill - Internatioal work experience * Lead Role * Collaborate with DevOps team on CI/CD pipelines for SQL Azure databases. * Implement DWH solutions using Microsoft Azure, SQL Azure, AD Factor & Power BI. Annual bonus Health insurance Provident fund

position: Contract to Hire(C2H) Skill: Powerbi Developer Experience:8+ Location: Hyd/Bang Notice Period: Immediate to 15 Days Skill - Microsoft Power BI DWH or BI Implementation + SSIS or RDBMS + SQL + Scheduling tools ( Tivoli or Autosys or Simialr) + Data Modeling + Oracle or Teradata or SOL Server or DB2 + UAT Combination is mus Description: Experience in implementation of Data warehouse/Bl solutions - Expertise in SSIS, DW / Bl and SOL - Knowledge of Scheduling Tools (Tivoli , Autosys etc.), Data Modeling, Project Management - Well versed with knowledge of Data warehousing concepts including: SCDs, star schema, hierarchy, aggregation - Should have expertise in ETL tools like SSIS, RDBMS (at least one) like Oracle, Teradata, SOL Server, DB2 and considerable experience in Testing which activities like creating system I integration / performance test plan, performing system I integration / performance testing, defect tracking, root cause analysis of defects, support user acceptance testing {UAT} and facilitate UAT sign off, Deployments / Migrations across Environments. - Should be well versed with Performance Tuning Techniques in SSIS and RDBMS. 1. Microsoft SSAS (core tool) a. Tabular model b. Microsoft DAX coding 2. SSIS 3. PowerBI a. Report writing with DAX b. Light Admin work 4. Experience with SQL ( Oracle and SQL server) a. building views, tables and scripts b. tuning/light DBA tasks. 5. StarQuest software for data refreshes from Oracle database.