Current jobs related to ETL/Database Developer - sacramento - eStaffLLC

  • SQL Database Administrator

    2 months ago

    Sacramento, California, United States Mindlance Full time

    Job DescriptionMindlance is seeking a highly skilled SQL Database Administrator to join our team. As a key member of our Business Intelligence team, you will be responsible for designing, implementing, and maintaining high-performance databases that support our business operations.Key ResponsibilitiesDesign and implement database architectures that meet...

  • ETL Developer

    2 weeks ago

    Sacramento, United States Perfict Global, Inc. Full time

    About Us:Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in...

  • SQL Database Administrator

    4 weeks ago

    Sacramento, California, United States United Software Group Full time

    Job Title: SQL Database AdministratorWe are seeking a highly skilled SQL Database Administrator to join our team at United Software Group. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our Microsoft SQL Server databases.Key Responsibilities:Design and implement database solutions to meet business...

  • SQL Database Administrator

    2 weeks ago

    Sacramento, California, United States United Software Group Full time

    Job Title: SQL Database AdministratorJob Summary:United Software Group is seeking a skilled SQL Database Administrator to join our team. As a key member of our database team, you will be responsible for maintaining and optimizing our Microsoft SQL Server databases. Your expertise in performance tuning, indexing, and database administration will be crucial in...

  • Database Developer

    4 weeks ago

    Sacramento, California, United States State of California Full time

    Job Title: Database DeveloperJob Summary:The Database Developer will be responsible for designing, developing, and implementing database systems to support the California State Lottery's enterprise business applications and system environment. The incumbent will work closely with users, administrators, and developers to identify business and technical...

  • SQL Database Administrator

    2 months ago

    Sacramento, California, United States Mindlance Full time

    Job DescriptionMindlance is seeking a highly skilled SQL Database Administrator to join our team. As a key member of our Business Analysis and Applications Development Teams, you will be responsible for maintaining data collection and sharing processes, developing SSRS reports and Power BI Dashboards, optimizing database processes, and building stored...

  • Senior Database Developer

    2 weeks ago

    Sacramento, California, United States VDart Inc Full time

    Job Title: Senior Database DeveloperJob DescriptionJob OverviewAs a Senior Database Developer at VDart Inc, you will be responsible for designing, developing, and maintaining high-performance database systems. With a strong focus on SQL Server expertise, you will work on complex database projects, ensuring efficient data management and optimal system...

  • Senior Oracle Developer

    2 weeks ago

    Sacramento, California, United States Perfict Global, Inc. Full time

    About Perfict Global, Inc.We are a leading IT consulting services provider focused on delivering innovative business workforce solutions to Fortune 500 companies.Our team of experienced professionals strives to bring together the best technologies available to manage clients' complex business and technology needs, participate in implementation activities,...

  • Oracle/Python Developer

    4 days ago

    Sacramento, United States Perfict Global, Inc. Full time

    About Us: Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in...

  • Senior Business Intelligence Developer

    2 weeks ago

    Sacramento, California, United States West Advanced Technologies Full time

    Job Title: Senior Business Intelligence DeveloperJob Summary:We are seeking a highly skilled Senior Business Intelligence Developer to join our team at West Advanced Technologies. As a Senior Business Intelligence Developer, you will be responsible for designing, developing, and implementing complex business intelligence solutions using Oracle Database 11g...

  • Snowflake developer

    2 weeks ago

    Sacramento, United States IPEM SOLUTIONS INC Full time

    Job DescriptionJob DescriptionResponsibilities and Duties:·         Candidate must be able to design, develop and implement efficient and scalable data storage solutions using Snowflake.·         Must be able to Write, optimize, and troubleshoot SQL queries within the Snowflake and SQL Server environments. ·         Integrate Snowflake...

  • Database Architect

    2 months ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectWe are seeking a highly skilled Database Architect to join our team at Real HR Hero - Thompson HR Consulting. As a key member of our technology team, you will be responsible for designing, developing, and administering a healthcare-related common data model.Key Responsibilities:Design and implement physical database structures to...

  • Database Architect

    3 weeks ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectWe are seeking a highly skilled Database Architect to join our team at Real HR Hero - Thompson HR Consulting. As a Database Architect, you will be responsible for designing, developing, and administering a healthcare-related common data model.Key Responsibilities:Design and implement physical database structures to support...

  • Database Architect

    1 month ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectWe are seeking a highly skilled Database Architect to join our team at Real HR Hero - Thompson HR Consulting. As a Database Architect, you will be responsible for designing, developing, and administering a healthcare-related common data model.Key Responsibilities:Design and implement physical database structures to support...

  • Database Architect

    1 month ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectJob Summary:The Database Architect is responsible for designing, developing, and administering a healthcare-related common data model. This role involves defining, creating, and maintaining enterprise databases and database structures within the organization. The successful candidate will analyze, test, and implement physical...

  • Database Administrator

    3 weeks ago

    Sacramento, California, United States State of California Full time

    Job Title: Database AdministratorUnder the direction of an IT Supervisor II, the incumbent serves as a Database Administrator supporting database operations in the Sacramento District Office/HQ and surrounding area.Key Responsibilities:Provide administrative and technical support for database infrastructure environments.Collaborate with management and staff...

  • Senior Business Intelligence Developer

    3 weeks ago

    Sacramento, California, United States West Advanced Technologies Full time

    Business Intelligence ConsultantWest Advanced Technologies is seeking a highly skilled Business Intelligence Consultant to join our team. As a Business Intelligence Consultant, you will be responsible for analyzing operational methods and developing computer programs to meet desired results.Key Responsibilities:Analyzing operational methods and developing...

  • Database Administrator

    2 weeks ago

    Sacramento, California, United States State of California Full time

    Job SummaryWe are seeking a highly skilled Database Administrator to join our team at the State of California. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database systems to ensure efficient and secure data management.Key ResponsibilitiesDesign and implement database systems to meet business...

  • Database Architect

    2 weeks ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectWe are seeking a highly skilled Database Architect to join our team at Real HR Hero - Thompson HR Consulting. As a Database Architect, you will be responsible for designing, developing, and administering a healthcare-related common data model.Key Responsibilities:Design and implement physical database structures to support...

  • Database Architect

    2 weeks ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectWe are seeking a highly skilled Database Architect to join our team at Real HR Hero - Thompson HR Consulting. As a Database Architect, you will be responsible for designing, developing, and administering a healthcare-related common data model.Key Responsibilities:Design and implement physical database structures to support...

ETL/Database Developer

2 months ago

sacramento, United States eStaffLLC Full time

We are seeking a senior, hands-on ETL/Database Developer with strong communication skills for a long term hybrid assignment with our Sacramento, California based client. This position requires that you be able to work on-site in Sacramento, California for at least 2 days/wk as determined by the client.



Key Duties/Responsibilities:

Performs ETL and database development activities for the Enterprise Data Warehouse in the Oracle Cloud Infrastructure, Oracle Autonomous Data Warehouse Environment
Reviews existing architecture and provides solution recommendations where applicable
Develops, tests, and implements scripts/jobs for data Extract Transform and Load (ETL) from data source(s) to target(s) in the data warehouse using ODI
Design, develop, and optimize ETL processes using Oracle tools and technologies
Create and maintain data pipelines to extract data from various sources, transform it according to business rules, and load it into Oracle data warehouses
Collaborate with data analysts and business stakeholders to understand data requirements and implement appropriate solutions
Troubleshoot and resolve data quality issues and performance bottlenecks
Document ETL processes, data mappings, and data lineage
Implement data quality checks and validation procedures
Participate in code reviews and adhere to best practices in ETL development
Hands-on experience working with and managing Oracle's Autonomous Data Warehouse (ADW) service
Develops physical data model and/or works with data modeler to develop physical data model
Develops Testing Approach, Plan, Scripts and Documentation of Results
Participates in developing Requirements Specifications
Participates in developing Design Specifications
Monitors the EDW and responds to incidents
Provides documentation to support the Kimball Dimensional Data Modeling Framework
Mentors and educates team members on best practices and industry standards




Requirements:

Strong communication skills and the ability to develop and perform Extract, Transform and Load (ETL) activities using Oracle tools with at least 5 years ETL experience.
Detail oriented ability to independently extract, transform, and load a Oracle ADW data warehouse environment with minimal supervision
Ability to translate business and functional requirements into technical requirements for a Data Warehouse.
Able to demonstrate, direct hands-on recent practical experience in the areas identified with specific examples.
Minimum of seven (7) years of verifiable experience in database design, development, and warehouse architecture supportive of key duties/responsibilities identified above in an Oracle environment
At least two (2) years of experience in the last 6 years performing ETL development activities in a Oracle Autonomous Data Warehouse in a Oracle Cloud Infrastructure Environment.
5 years' experience performing development in Oracle data warehouses within the last 10 years
Excellent communication and collaboration skills to work effectively with technical stakeholders and team members.
Proficient with various Oracle tools used to perform ETL, performance management, and tuning for an Oracle Data Warehouse and Oracle Cloud Infrastructure Environment.
Strong proficiency in Oracle Database, PL/SQL, and SQL
Experience with Oracle Data Integrator (ODI) or Oracle GoldenGate
Solid understanding of data warehousing concepts and dimensional modeling
Familiarity with Oracle Business Intelligence Enterprise Edition (OBIEE) is a plus
Strong analytical and problem-solving skills




Preferred:

Certified for "Oracle Autonomous Database Cloud 2021 Certified Specialist" and/or "Oracle Machine Learning using Autonomous Database 2021 Certified Specialist"
Certified on Oracle Cloud infrastructure 2021 certified architect professional
Certified for Oracle data integrator 12C certified implementation specialist
Ability to perform technical leadership of a Oracle data warehouse team including but not limited to data modeling, requirements solicitation, DBA, data warehouse administration, and data analysis on a hands-on basis.