Oracle DBA + ETL - Diverse Linx
Jersey City, NJ
About the Job
Key Responsibilities
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
- Data Warehouse Design:
- Creating data warehouse architecture, including dimensional models and data structures to optimize queries and analysis.
- Defining data relationships and designing data marts for specific business needs.
- ETL Development:
- Developing and maintaining ETL processes to extract data from various sources, transform it into a usable format, and load it into the data warehouse.
- Writing complex SQL queries and stored procedures to manage data cleansing and transformation logic.
- Performance Tuning:
- Monitoring data warehouse performance, identifying bottlenecks, and optimizing queries for efficient data retrieval.
- Implementing indexing strategies and materialized views to improve query response time.
- Data Quality Management:
- Implementing data quality checks and validation procedures to maintain data accuracy within the data warehouse.
- Strong Oracle Database Skills: Expertise in Oracle SQL, PL/SQL, and database administration concepts
- Data Warehousing Knowledge: Understanding of dimensional modeling, data mart design, and ETL processes
- Programming Skills: Familiarity with scripting languages like Python or Shell for automation tasks
- Analytical Skills: Ability to analyze data and identify trends to inform business decisions
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Source : Diverse Linx