IN-Senior Associate- ETL Developer OracleDAAdvisoryGurgaon
IN-Senior Associate- ETL Developer OracleDAAdvisoryGurgaon
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Line of Service
AdvisoryIndustry/Sector
FS XSectorSpecialism
Data Analytics & AIManagement Level
Senior AssociateJob Description & Summary
At PwC our people in data and analytics focus on leveraging data to drive insights and make informed business decisions. They utilise advanced analytics techniques to help clients optimise their operations and achieve their strategic goals.In business intelligence at PwC you will focus on leveraging data and analytics to provide strategic insights and drive informed decisionmaking for clients. You will develop and implement innovative solutions to optimise business performance and enhance competitive advantage.
*Why PWC
At PwC we believe in providing equal employment opportunities without any discrimination on the grounds of gender ethnic background age disability marital status sexual orientation pregnancy gender identity or expression religion or other beliefs perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firms growth. To enable this we have zero tolerance for any discrimination and harassment based on the above considerations.
Job Description & Summary Senior Associate ETL Developer (Oracle)
Responsibilities:
The Datawarehouse Developer is responsible for designing developing and optimizing database components within the data warehouse. This role involves ensuring efficient data storage retrieval and management to support the organizations analytics and business intelligence needs.
Key Responsibilities:
SQL Development: Write optimize and maintain complex SQL queries and stored procedures for data manipulation and reporting.
ETL Processes: Collaborate on the development and optimization of ETL processes to ensure efficient data integration and transformation.
Data Integration: Develop procedures for seamless integration of data from various sources into the data warehouse.
Performance Tuning: Monitor database performance identify bottlenecks and implement optimization strategies to enhance query performance and data retrieval.
Database Maintenance: Ensure regular maintenance and updates to database components including backups indexing and partitioning.
Data Quality: Implement validation and cleansing processes to ensure data integrity and accuracy within the database.
Technical Skills:
Proficiency in SQL and database management systems such as Oracle SQL Server PostgreSQL or MySQL.
Experience with ETL tools like Informatica Talend or Oracle Data Integrator.
Strong understanding of data warehousing concepts including star schema and snowflake schema design.
Familiarity with database performance tuning and optimization techniques.
Analytical Skills: Excellent problemsolving skills with attention to detail.
Communication Skills: Strong verbal and written communication skills for effective collaboration.
Adaptability: Ability to work independently and as part of a team in a fastpaced environment.
Preferred Skills: Knowledge of scripting languages such as Python or Shell scripting for automation tasks
Mandatory skill sets:
ETL/Oracle/Sql
Preferred skill sets:
ETL/Oracle/Sql
Years of experience required:
25 years
Education qualification:
BE/BTech/MBA/MCA
Education (if blank degree and/or field of study not specified)
Degrees/Field of Study required: Bachelor of Engineering Master of Business AdministrationDegrees/Field of Study preferred:Certifications (if blank certifications not specified)
Required Skills
ETL ToolsOptional Skills
Accepting Feedback Accepting Feedback Active Listening Analytical Thinking Business Case Development Business Data Analytics Business Intelligence and Reporting Tools (BIRT) Business Intelligence Development Studio Communication Competitive Advantage Continuous Process Improvement Creativity Data Analysis and Interpretation Data Architecture Database Management System (DBMS) Data Collection Data Pipeline Data Quality Data Science Data Visualization Embracing Change Emotional Regulation Empathy Inclusion Industry Trend Analysis 12 moreDesired Languages (If blank desired languages not specified)
Travel Requirements
Not SpecifiedAvailable for Work Visa Sponsorship
NoGovernment Clearance Required
NoJob Posting End Date
Required Experience:
Senior IC
Employment Type
Full-Time
