Data Warehouse Developer-W2

2 months ago


Los Angeles, United States eTek IT Services, Inc. Full time
Job DescriptionJob DescriptionJob Description:Responsibilities• Support the Cost Transfer buildout process in Workday through data transformation exercises primarily performed in Oracle using PL/SQL• Integration Support – Building out the selection criteria for the integration team to build the integrations into cost and then the process to consume the cost ledger results back into the managerial ledger.• Data Model (FDM) support - Select and transform hierarchy data to be passed to Workday• Data Enhancement (higher complexity) – Support the need to pass Essbase budget data to workday by building processes to allocated higher level budget data to bottom level GL Accounts and Cost Centers. Work with Essbase team to get daily data based on varying criteria.• Data ingestion – Support Proof of concept of data delivery into SnowflakeThis role will spend relatively little time in project management/ meetings and the majority of the work will be as an individual contributor.Skills• Intermediate to Advanced PL/SQL• Excellent problem solving skills• Essbase experience a plus but not required and can be trained• Workday Prism or Snowflake experience a plus but not required and can be trained• Responsible for all phases of the software development lifecycle (analysis, design, and implementation).• Provide application development and maintenance for all phases of the software development lifecycle, including analysis, design, and implementation.• Design and maintain complex ETL (Extract, Transform and Load) processes that load from both data files and other databases.• Develop and maintain complex PL/SQL functions and procedures.• Create and optimize complex SQL queries for reports and applications.• Provide input to project plans that includes estimates of tasks, duties and technologies for future releases and write technical documentation.• Provide end user support and problem diagnosis and resolution.• Perform all assignments in accordance with ESH Q, Security, and business practice requirements and policies.• Provide expert level development support of PL/SQL functions, procedures, and database architecture.• Provide advanced SQL tuning skills to complex queries, ETL’s, and data processing.• Provide advanced support towards the IT needs for financial and/or budget and planning applications.Qualifications• Broad experience developing and maintaining custom ETL scripts.• Comprehensive knowledge and experience with relational database design, techniques, and development methodologies• Broad experience using SQL, PL/SQL, and Oracle 11g or higher.• Broad experience developing ETL processes within Oracle database environments and non-Oracle environments using SQL Server, MySQL, File Transfer, or similar technologies.• Proficient interpersonal skills necessary to effectively collaborate as part of a cohesive development team working with multiple customers and organizations simultaneously with time constraints.• Proficient written and verbal communication skills necessary to effectively prepare, present and explain technical information to others.• Significant experience supporting financial and business applications.• Advanced experience with SQL Tuning and ETL Optimization.• Significant experience with data virtualization tools such as Denodo.


  • Data Architect

    1 month ago


    Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRole : Data Architect Location: Los Angeles, CA (Hybrid)Experience : 10+ yearsW2 Contract& Education/Certification Requirements: Bachelors Degree required& Must Have Skills:·& Strong Data Governance background:o& & & Understands the business side of data and ability to bring consistency for data definitionso& & & Data security...

  • Data Architect

    1 month ago


    Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRole : Data Architect Location: Los Angeles, CA (Hybrid)Experience : 10+ yearsW2 Contract& Education/Certification Requirements: Bachelors Degree required& Must Have Skills:·& Strong Data Governance background:o& & & Understands the business side of data and ability to bring consistency for data definitionso& & & Data security...


  • Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRole : Informatica Data Quality DeveloperLocation: RemoteExperience : 5+ yearsW2 Contract& JD Required SkillsCore requirements: Proficient with Snowflake, Informatica. Data Management Program / Chief Data Office Data Quality Rule development in IDQ Data Profiling. Data Engineering. Nice to have: Denodo and Python.Additional...

  • .NET Data Analyst

    3 months ago


    Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRole : Principal Data AnalystLocation: RemoteExperience : 7+ yearsW2 Contract& JD : Required Skills1. 6+ years of development in .net and modern architecture 2. Proficiency in the programming languages (e.g. Java, Spark, Scala, Angular, React, Python, R, SQL, .NET) 3. Build and continuously evolve a body of current and upcoming...


  • Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRole : Data Engineer Azure with HealthcareLocation : RemoteExperience : 8+yearsW2 ContractNo C2CConsultant should have Healthcare experience Must Have : Data Modeling & Azure Azure Data Modeler Must Have Skills: • Azure Specific experience (Experience moving data from on prem to the Azure cloud and mapping the data)• Data...


  • Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRole : Principal Data AnalystLocation: RemoteExperience : 7+ yearsW2 Contract& JD : Required Skills1. 6+ years of development in .net and modern architecture 2. Proficiency in the programming languages (e.g. Java, Spark, Scala, Angular, React, Python, R, SQL, .NET) 3. Build and continuously evolve a body of current and upcoming...


  • Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRequired SkillsCore requirements: Proficient with Snowflake, Informatica. Data Management Program / Chief Data Office Data Quality Rule development in IDQ Data Profiling. Data Engineering. Nice to have: Denodo and Python.Additional SkillsJob DescriptionApex has an opportunity for an IDQ Developer to join our team in a fast-paced...


  • Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRole : System AnalystLocation: RemoteExperience : 7+ yearsW2 Contract& Required Skills1. 5+ years experience with systems integration experience 2. Visualization – flow charts, business process mapping (any tool, i.e Miro, Visio, etc.) 3. Experience in data mapping and integrations between systems 4. Cloud experience –...


  • Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRole : Full Stack Web DeveloperLocation : RemoteExperience : 8+yearsW2 Contract& Jenkins,React,Node,API,Java Script,MySQL& Job Responsibilities:& · Works closely with leadership, team members and organizational partners to understand business requirements that drive the analysis and design of quality technical solutions.& · As...


  • Los Angeles, CA, United States NTT DATA Full time

    NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. We are currently seeking a Salesforce Release Manager to join our team in Los Angeles, California (US-CA), United States (US). IT Professional with 5+ years of IT Release Management experience working in an enterprise software development...


  • Los Angeles, United States L.A. Care Health Plan Full time

    Job Category: Information Technology Location: Los Angeles, CA, US, 90017 Position Type: Full Time Salary Range: $105,267.00 (Min.) - $139,478.00 (Mid.) - $173,689.00 (Max.) Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We...


  • Los Angeles, United States L.A. Care Health Plan Full time

    ETL Data Integration Developer III Job Category: Information Technology Department: IT Enterprise Data Management Location: Los Angeles, CA, US, 90017 Position Type: Full Time Requisition ID: 11512 Salary Range: $105,267.00 (Min.) - $139,478.00 (Mid.) - $173,689.00 (Max.) Established in 1997, L.A. Care Health Plan is an independent public agency...


  • Los Angeles, United States L.A. Care Health Plan Full time

    Salary Range:  $105,267.00 (Min.) - $139,478.00 (Mid.) - $173,689.00 (Max.)Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation’s largest publicly operated health plan. Serving more than 2 million members,...


  • Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $105, Min.) - $139, Mid.) - $173, Max.) Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation's largest publicly operated health plan. Serving more than 2 million members, we make sure our members get...


  • Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionOverview:The Java Fullstack Developer with Cloud-W2 plays a crucial role in designing, developing, and maintaining high-quality, scalable software solutions. They are responsible for leveraging their expertise in Java, fullstack development, and cloud technologies to contribute to the success of the organization. This role...


  • Los Angeles, United States L.A. Care Health Plan Full time

    Salary Range:  $105,267.00 (Min.) - $139,478.00 (Mid.) - $173,689.00 (Max.)   Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation’s largest publicly operated health plan. Serving more than 2...


  • Los Angeles, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRole : DevOps Engineer with PythonLocation : Remote(big plus if hybrid onsite in Boston, MA; McLean, VA, Richmond, VA, or Plano,TX)Experience : 7+yearsW2 contractRequired Skills : Perl, AWS , Python& & Required SkillsPython AWS DevOps WindowsAdditional SkillsVery nice to have if they have worked with or are familiar with Perl...


  • Los Angeles, United States Aspire Bakeries Full time

    Aspire Bakeries is a North American baking company with a leadership position in specialty frozen baked goods. Formed from leading bakery companies, its innovative food portfolio includes breads, artisan breads, buns, cookies, donuts, muffins and pastries from beloved brands like ®, ®, and ®. With 13 bakeries in North America, we are committed to...


  • Los Angeles, United States Aspire Bakeries Full time

    Aspire Bakeries is a North American baking company with a leadership position in specialty frozen baked goods. Formed from leading bakery companies, its innovative food portfolio includes breads, artisan breads, buns, cookies, donuts, muffins and pastries from beloved brands likeLa Brea Bakery,Otis Spunkmeyer, andOakrun Farm Bakery. With 13 bakeries in North...


  • Los Angeles, United States Aspire Bakeries Full time

    Aspire Bakeries is a North American baking company with a leadership position in specialty frozen baked goods. Formed from leading bakery companies, its innovative food portfolio includes breads, artisan breads, buns, cookies, donuts, muffins and pastries from beloved brands likeLa Brea Bakery,Otis Spunkmeyer, andOakrun Farm Bakery. With 13 bakeries in North...