ETL Developer

INFOWAY LIMITED
Sunnyvale, CA, United States
about 1 month ago
Apply on jobs.smartrecruiters.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
6 years minimum
Working hours
Regular working hours

Tech stack

Databases Data Integration Data Integrity Extract Transform Load (ETL) Data Security Data Warehousing Design of User Interfaces Systems Development Life Cycle Release Management Data Streaming Strategies of Testing Test Scripts
+3 more
Information Technology Data Management Oracle Ebusiness

Job description

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., 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.

Requirements

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.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.smartrecruiters.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · World Congress 2021

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

1:31 min

Managing self-healed test scripts safely within continuous integration

Andrei Nutas Andrei Nutas · World Congress 2026 Europe

4:04 min

Embedding data security and applied ethics into developer education

Daniel Tao +3 · World Congress 2024

56 sec

Introduction to analytical data formats for software developers

Matthias Niehoff Matthias Niehoff · World Congress 2026 Europe

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · World Congress 2022

Videos

See all

Related articles

See all