54 Dw Jobs - Page 3

Abinitio: Ab Initio Skills: Graph Development, Ab Initio standard environment parameters, GD(PDL,MFS Concepts)E, EME basics, SDLC, Data Analysis Database: SQL Proficient, DB Load / Unload Utilities expert, relevant experience in Oracle, DB2, Teradata (Preferred) UNIX: Shell Scripting (must), Unix utilities like sed, awk, perl, python Informatica IICS: Good Exp in designing and developing ETL mappings using IICS. Should be familiar with bulk loading concepts, Change Data Capture (CDC),Data Profiling and Data validation concepts . Should have prior experience working with different types of data sources/targets. Understanding configuration, migration and deployment of ETL mappings. Teradata: Assist in the design, development, and testing of Teradata databases and ETL processes to support data integration and reporting Collaborate with data analysts and other team members to understand data requirements and provide solutions DataStage: Overall experience of 5 years in DW/ BI technologies and minimum 5 years development experience in ETL DataStage 8.x/ 9.x tool. Worked extensively in parallel jobs, sequences and preferably in routines. Good conceptual knowledge on data- warehouse and various methodologies.

Job Title: ======= Senior MS BI Developer Onsite Location: ============= Dubai, UAE Doha , Qatar Riyadh, Saudi Onsite Monthly Salary: ============== 10k AED - 15k AED - Full tax free salary , Depending on Experience Gulf work permit will be sponsored by our client Project duration: ============= 2 Years, Extendable Desired Experience Level Needed: =========================== 5 - 10 Years Qualification: ========== B.Tech / M.Tech / MCA / M.Sc or equivalent Experience Needed: =============== Over all: 5 or more Years of total IT experience Solid 3+ Years experience or MS - BI Developer with Microsoft Stack / MS - DWH Engineer Job Responsibilities: ================ - Design and develop DWH data flows - Able to build SCD -1 / SCD - 2 / SCD -3 dimensions - Build Cubes - Maintain SSAS / DWH data - Design Microsoft DWH & its ETL packages - Able to code T-SQL - Able to create Orchestrations - Able to design batch jobs / Orchestrations runs - Familiarity with data models - Able to develop MDM (Master Data Management) Experience: ================ - Experience as DWH developer with Microsoft DWH data flows and cubes - Exposure and experience with Azure services including Azure Data Factory - Sound knowledge of BI practices and visualization tools such as PowerBI / SSRS/ QlikView - Collecting / gathering data from various multiple source systems - Creating automated data pipelines - Configuring Azure resources and services Skills: ================ - Microsoft SSIS / SSAS / SSRS - Informatica - Azure Data Factory - Spark - SQL Nice to have: ========== - Any on site experience is added advantage, but not mandatory - Microsoft certifications are added advantage Business Vertical: ============== - Banking / Investment Banking - Capital Markets - Securities / Stock Market Trading - Bonds / Forex Trading - Credit Risk - Payments Cards Industry (VISA/ Master Card/ Amex) Job Code: ====== MSBI_DEVP_0525 No.of positions: ============ 05 Email: ===== spectrumconsulting1977@gmail.com if you are interested, please email your CV as ATTACHMENT with job ref. code [ MSBI_DEVP_0525 ] as subject

Position Summary Delivery Director - Big Data & Cloud Data Management This position is part of the Senior leadership in data warehousing and Business Intelligence areas. Someone who can work on multiple project streams and clients for better business decision making especially in the area of Lifesciences/ Pharmaceutical domain. Functional Domain Life Sciences focusing on Pharma Commercial aspect Technology Domain Big DataCloud Data Management ( EDW/ Data Lake/ Big Data) Location Noida/Gurgaon Qualification B.Tech. or equivalent degree is a minimum criterion Job Responsibilities Lead the delivery of major engagements on a day-to-day basis, providing hands on technical leadership to the delivery team.Global program planning and execution for Data Management programs across Enterprise DWH, Data Lake, Big Data, Business Intelligence & Reporting, Master Data Management solutions. This includes setting up project plans, scopes, budgets, staffing resources, leading client workshops, creating and coordinatingfinal deliverables, providing high quality and insightful advice to our clients in terms of Cloud Data Management strategy, architecture, operating model etc.Drive data management business requirements across pharma commercial data sets in a workshop setting with client business teams and onshore counterparts.Be able to guide the team to deliver the logical and physical data models for Pharma Commercial Data Lakes and Warehouse Maintain responsibility for risk management, quality and profitability on engagements and liaise with the client lead and onshore delivery partners .Drive Clear and Timely communication across program stakeholders to ensure everyone is on the same page on the weekly progress.Must maintain high standards of quality and thoroughness. Should be able to set-up adequate controls within team to perform code reviews and monitor the quality Represent the Business Information Management (BIM) practice as a SME in cloud data management space.Coach, mentor and develop middle and junior level staff. Performance management of all the team members rolling up to the role.Develop the manager layers to be leaders of the future.Be known as a Thought Leader in a specific aspect of Information Management technology spectrum or Pharma domain.Direct the training & skill enhancement of the team, in line with pipeline opportunities Understand wider Product and service offerings of Axtria to co-ordinate these to ensure our clients get the best level of advice and support.Should be able to work on large Cloud data management deals within Life Sciences domain.Work with Vertical/Onshore teams to drive Business Development and growth for the practice Education BE/B.Tech Master of Computer Application Work Experience Candidate should have 14+ years of prior experience in delivering customer focused Cloud Data Management solution(s)Enterprise Data Warehouse, Enterprise Data Lake, Master Data Management System, Business Intelligence & Reporting solutions, IT Architecture Consulting, Cloud Platforms ( AWS/AZURE), SaaS/PaaS based solutions in the Life Science industry.Minimum of 5 years of relevant experience in Pharma domain. (Must)Should have successfully program managed/solutioned 2-3 end to end DW Cloud implementations on AWS/Redshift/Cloud in Pharma or Life Sciences Business domains (Must)Candidate must have prior hands-on working experience on big data and ETL technologies.Tech stack exposure (hands on/project mgmt. on few of these)from amongst AWS, ETL, Data modelling, Python, Qlik/Tableau/MicroStrategy, Dataiku, Databricks, Airflow, Graph DB, Full stack.Good to have working knowledge of toolsAt least 2 of the following QlikView, Qlik Sense, Tableau, MicroStrategy, Spotfire, MS PBI. Must have a very good understanding of end-to-end pharma commercial landscape covering both enterprise and syndicated data sets.Decent exposure to Business processes like alignment, market definition, segmentation, sales crediting, activity metrics calculation and Exposure on advanced analytics such as next best action implementation.Ability to handle large teams of IT professionals.Ability to lead large RFP responses.Ability to handle P&L.Ability to handle different stakeholders customers, vendors, internal teams.Strong project/program management capabilities.Strong written and verbal communication skills Behavioural Competencies Project Management Communication Attention to P&L Impact Teamwork & Leadership Motivation to Learn and Grow Lifescience Knowledge Ownership Cultural Fit Scale of resources managed Scale of revenues managed / delivered Problem solving Talent Management Capability Building / Thought Leadership Account management Technical Competencies Delivery Management- BIM/ Cloud Info Management AWS EMR Amazon Redshift Business Intelligence(BI)

Very good experience on Continuous Flow Graph tool used for point based development. Design, develop, and maintain ETL processes using Ab Initio tools. Write, test, and deploy Ab Initio graphs, scripts, and other necessary components. Troubleshoot and resolve data processing issues and improve performance Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise Over all 8 Years and Relevant 5+ years Extract, transform, and load data from various sources into data warehouses, operational data stores, or other target systems. Work with different data formats, including structured, semi-structured, and unstructured data Preferred technical and professional experience Effective communication and presentation skills. Industry expertise / specialization