ETL Developer

Infoway Group; Sunnyvale (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

A staffing firm is seeking a skilled data warehousing and ETL specialist with over six years of experience. The role involves developing robust systems for data reporting, managing multiple projects, and ensuring adherence to documentation and quality standards. Candidates should have expertise in ETL processes and database design, with additional experience in Oracle EBS/ERP preferred. This position is based in Sunnyvale, California, and offers an opportunity for individuals to work independently or collaboratively in a dynamic environment.

Qualifications

• Minimum of six years of experience in data warehousing, data management, and ETL processes.
• Hands-on experience with designing and implementing ETL solutions.
• Strong analytical skills to analyze complex problems and implement solutions.

Responsibilities

• Develop logical and physical data flow models for ETL applications.
• Oversee transformation activities such as normalization, cleansing, and integration.
• Ensure data integrity and handle errors in a timely manner.

Skills

Data warehousing

ETL processes

Data integration

Problem-solving

Communication skills

Education

Bachelor’s Degree in Computer Science

Tools

Pentaho

Oracle EBS/ERP

Job description

Company Overview

Since 2009, Info Way Solutions has earned a reputation as a full-service staffing firm that excels in a fast-paced marketplace. We have placed highly skilled professionals on a temporary, temporary-to-hire and direct-hire basis in the fields of accounting and finance, IT technology, office administration, marketing and design.

Info Way Solutions is dedicated to providing you quality professionals with well‑matched skills to your unique hiring requirements and workplace environment. We collaborate with customers to consistently and cost‑effectively plan, execute and deliver high‑quality services and results. Our consultants are seasoned professionals who build long‑term, trusted relationships that bring about a high level of energy, integrity, experience and value to our client’s work.

Our superior client‑consultant relationships and in‑depth insight of services have resulted in significant repeated business with clients. In addition, we are partners with best‑in‑class technology vendors that enable us to best determine the most appropriate hardware, software and services to cater to any of our client’s business needs. We have often collaborated with them to make optimal use of today’s technology while also planning for the future.

More than 50 customers – including mid‑market leaders and many of the Fortune 500 Companies – rely on our expertise to leverage their investments.

Job Description

Greetings!!!

Please send updated resume to ravi at infowaygroup dot com

Job Description:

• Develop and document the systems, processes and logic required to expose the existing data sets in the warehouse to end users for reporting and analysis purposes.
• Keep abreast of the tools, techniques and components being used in the industry through research and applies this knowledge to the system(s) being developed.
• Develop testing strategies, including test script formulation and execution, used to validate the accuracy and results of ETL solutions; participation and contribution in quality assurance walk‑throughs of ETL components.
• Manage multiple broader efforts that span multiple projects/initiatives. Prioritize and monitor project/task status and risk management/mitigation, by working with appropriate manager on level of effort/estimates, resource assignments, etc.
• Adhere to standard SDLC procedures and ensure the creation of appropriate documentation.
• Ensure adherence to Change Control and release management procedures, including generation of appropriate packages, documentation, and coordination with other technical areas.
• Establishes and maintains productive working relationships with peers and users, including effective collaborative problem solving, responsive communications and cordial interpersonal relationships.

Skill Set/Technologies:

• Bachelor’s Degree in Computer Science, Management Information Systems or related field or equivalent knowledge.
• Six (6) plus years of experience in data warehousing, data management, ETL processes and data modeling tools, required with experience Pentaho preferred.
• Six (6) plus years of experience in database and interface design, data integration, conversion processes and optimization, preferred.
• Hands‑on experience with all aspects of designing, developing, testing and implementing ETL solutions.
• Knowledge of Oracle EBS/ERP is mandatory.
• Ability to learn and implement new and/or different techniques.
• Self‑starter with ability to work independently or as part of a team.
• Strong technologist with excellent ability to analyze complex problems and identify and implement solutions.
• Excellent ability to organize tasks and maintain project schedules.
• Strong interpersonal skills demonstrated by an ability to communicate with all levels of staff in a courteous, constructive, patient and informative manner.
• Strong oral and writing skills characterized by the ability to communicate technical and non‑technical information thoroughly and clearly to a range of reading and comprehension skill levels.

Responsibilities:

• Develops logical and physical data flow models for ETL applications; oversees basic and advanced transformation activities such as normalization, cleansing, aggregation, summarization, and integration; designs automation processes to control data access, transformation and movement; ensures source system data availability and update accessibility, data integrity, restorability and appropriately handles errors, in a time sensitive manner.
• Demonstrate expertise.
• Demonstrate proficiency with the principles and methodologies of process improvement. Apply these in the execution of responsibilities in support of a process focused approach.

Contact

Thanks & Regards,

ravi at infowaygroup dot com

Direct [phone]

Info Way Solutions LLC. | 46520 Fremont Blvd, Suite 614 | Fremont, CA – 94538