Data Warehouse Specialist
Published date: 2024/01/10
- Location: Jaipur, Rajasthan, India
Functional Role: Senior Technical Analyst - Data Warehouse
Functional Competencies:-
• Hands on experience in ODI, should have worked on packages, scenarios, mappings, variables Should be well versed with Data Warehousing concepts like SCD, CDC, FACTS, DIMENSIONS, STAR SCHEMA, SNOWFLAKE SCHEMA etc.
• Experience with Oracle database SQL queries, stored procedure, functions etc.
• Should be well versed in Logical data model and Physical data model
• Should have experience on of source code management tools like git or svn.
• Should have good knowledge of SQL/PL-SQL and Shell scripting.
Roles & Responsibilities:-
• Responsible for developing data warehouse by understanding various systems architecture
• Responsible for design, development, integration, performance tuning, rollout, support and optimization during implementation of data warehouse Debug complex SQL queries.
• Should have detailed understanding of SDLC and implementation during the project
Qualification BTech/BE/BCA/MCA
Relevant Experience:- Minimum 5 years exp in ODI tool
Functional Competencies:-
• Hands on experience in ODI, should have worked on packages, scenarios, mappings, variables Should be well versed with Data Warehousing concepts like SCD, CDC, FACTS, DIMENSIONS, STAR SCHEMA, SNOWFLAKE SCHEMA etc.
• Experience with Oracle database SQL queries, stored procedure, functions etc.
• Should be well versed in Logical data model and Physical data model
• Should have experience on of source code management tools like git or svn.
• Should have good knowledge of SQL/PL-SQL and Shell scripting.
Roles & Responsibilities:-
• Responsible for developing data warehouse by understanding various systems architecture
• Responsible for design, development, integration, performance tuning, rollout, support and optimization during implementation of data warehouse Debug complex SQL queries.
• Should have detailed understanding of SDLC and implementation during the project
Qualification BTech/BE/BCA/MCA
Relevant Experience:- Minimum 5 years exp in ODI tool
0 page views
Related listings
-
MS SQL Database AdministratorDatabase Administratorï'· Create and manage multiple databases and assist in capacity planning. ï'· Monitor, maintain database systems and troubleshoot problems that may arise. ï'· Maintain data integrity and security (manage roles and permissions of database users). ï'· ...2026/11/07
-
Database Developer JaipurDatabase AdministratorMust have strong command in Shell scripting. • Must have good experience in hosting using web servers like apache2/Nginx/IIS. • Good understanding of Linux and Windows Server fundamentals & Troubleshooting. • Basic Network troubleshooting (DNS, T...2026/11/07
-
Database DeveloperDatabase AdministratorMust have strong command in Shell scripting. • Must have good experience in hosting using web servers like apache2/Nginx/IIS. • Good understanding of Linux and Windows Server fundamentals & Troubleshooting. • Basic Network troubleshooting (DNS, T...2026/11/07