Add office photos
Engaged Employer
i
This company page is being actively managed by
Ernst & Young Team. If you also belong to the team, you
can get access from
here
Ernst & Young
Compare
All Filters
2186 Ernst & Young Jobs
SCT TMT-DB2 Database Consultants -Senior
Ernst & Young
posted 2mon ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
- A minimum of 5+ years of experience into BI/Data integration/ETL/DWH solutions in cloud and on-premises platforms such as Informatica/ PC/IICS/Alteryx/Talend/ Azure Data Factory (ADF)/SSIS/SSAS/SSRS and experience on any reporting tool like Power BI, Tableau, OBIEE etc.
- Performing Data Analysis and Data Manipulation as per client requirements.
- Expert in Data Modelling to simplify business concepts.
- Create extensive ER Diagrams to help business in decision making.
- Working experience with large, heterogeneous datasets in building and optimizing data pipelines, pipeline architectures and integrated datasets using data integration technologies
- Should be able to develop sophisticated workflows macros (Batch, Iterative, etc.) in Alteryx with enterprise data.
- Design and develop ETL workflows and datasets in Alteryx to be used by the BI Reporting tool
- Perform end-to-end Data validation to maintain accuracy of data sets.
- Support client needs by developing SSIS Packages in Visual Studio (version 2012 or higher) or Azure Data Factory (Extensive hands-on experience implementing data migration and data processing using Azure Data Factory).
- Support client needs by delivering Various Integrations with third party applications.
- Experience in pulling data from a variety of data source types using appropriate connection managers as per Client needs.
- Develop, Customize, Deploy, maintain SSIS packages as per client business requirements.
- Should have thorough knowledge in creating dynamic packages in Visual Studio with multiple concepts such as - reading multiple files, Error handling, Archiving, Configuration creation, Package Deployment etc.
- Experience working with clients throughout various parts of implementation lifecycle.
- Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements.
- Analysing and translating business needs into long-term solution data models.
- Evaluating existing Data Warehouses or Systems.
- Strong knowledge of database structure systems and data mining
Skills and attributes for success
- Deliver large/medium DWH programmes, demonstrate expert core consulting skills and advanced level of ODI, Informatica, SQL, PL/SQL, Alteryx , ADF, SSIS ,SSAS knowledge and industry expertise to support delivery to clients.
- Demonstrate management and an ability to lead projects or teams individually.
- Experience in team management, communication, and presentation.
To qualify for the role, you must have
- 5+ years ETL experience as Lead / Architect
- Expertise in the ETL Mappings, Data Warehouse concepts.
- Should be able to design a Data Warehouse and present solutions as per client needs
- Thorough knowledge in Structured Query Language (SQL) and experience working on SQL Server. Experience in SQL tuning and optimization using explain plan and SQL trace files.
- Should have experience in developing SSIS Batch Jobs - Deployment, Scheduling Jobs, etc
- Building Alteryx workflows for data integration, modelling, optimization, and data quality
- Knowledge of Azure components like ADF, Azure Data Lake, and Azure SQL DB
- Knowledge of data modelling and ETL design
- Design and develop complex mappings, Process Flows and ETL scripts
- In-depth experience in designing the database and data modelling.
Ideally, you ll also have
- Strong knowledge of ELT/ETL concepts, design and coding
- Expertise in data handling to resolve any data issues as per client needs
- Experience in designing and developing DB objects such as
- Tables, Views, Indexes, Materialized Views and Analytical functions
- Experience of creating complex SQL queries for retrieving, manipulating, checking and migrating complex datasets in DB
- Experience in SQL tuning and optimization using explain plan and SQL trace files
- Candidate ideally should have ideally good knowledge of ETL technologies/tools such as Alteryx, SSAS , SSRS Azure Analysis Services, Azure Power Apps.
- Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
- Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.
- Candidates having additional knowledge of BI tools such as PowerBi, Tableau, etc will be preferred.
- Experience with Cloud data bases and multiple ETL tools.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Database Consultant roles with real interview advice
What people at Ernst & Young are saying
Database Consultant salary at Ernst & Young
reported by
2
employees
with 3-7
years exp.
₹7
L/yr - ₹8.9
L/yr
54%
less
than the average Database Consultant Salary in India
View more details
What Ernst & Young employees are saying about work life
based on 10.4k employees
Flexible timing
Monday to Friday
No travel
Day Shift
Ernst & Young Benefits
View more benefits
Compare Ernst & Young with
Deloitte
Compare
PwC
Compare
EY Global Delivery Services ( EY GDS)
Compare
Accenture
Compare
Cognizant
Compare
TCS
Compare
Amazon
Compare
Wipro
Compare
Capgemini
Compare
IBM
Compare
Compare
Microsoft Corporation
Compare
Infosys
Compare
KPMG India
Compare
Bain & Company
Compare
McKinsey & Company
Compare
BCG
Compare
ZS
Compare
Mercer
Compare
Willis Towers Watson
Compare
Similar Jobs for you
Ernst & Young Noida Office Locations
Noida Office
Glycols Limited, Commercial Complex
4th & 5th Floor, Plot No 2B, Tower 2,
Sector 126
Noida (Glycols Ltd)
Noida
201-304
201-304
Noida Office
Glycols Limited, Commercial Complex,4th & 5th Floor,Plot No 2B, Tower 2,Sector 126,201-304 Noida (Glycols Ltd)
Noida
Uttar Pradesh 201313
Uttar Pradesh 201313
Tax Chat - Senior/Assistant Manager
4-9 Yrs
Hyderabad / Secunderabad, Bangalore / Bengaluru
Learning And Development Specialist
2-7 Yrs
Noida, Hyderabad / Secunderabad, Bangalore / Bengaluru
Associate-WFM/Workforce management-Banglore
1-4 Yrs
Kochi, Bangalore / Bengaluru, Thiruvananthapuram
Assistant Manager-Resource Management
6-10 Yrs
Kochi, Gurgaon / Gurugram, Bangalore / Bengaluru
Senior Associate-Resource Management/Bench management
4-8 Yrs
Kochi, Gurgaon / Gurugram, Bangalore / Bengaluru
Share an Interview