ETL informatic Developer


Global Data Solutions Inc.

2019-01-11 14:07:38

Job location San Leandro, California, United States

Job type: all

Job industry: I.T. & Communications

Job description

Note:

US Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Required Qualifications

5 or more years of IT development experience required.
3 or more years of Oracle experience.
3 or more years of Informatica development experience.
3 or more years of experience in the software development methodology life cycle - including business planning, data analysis, process analysis and design, business and functional requirements analysis, use case analysis, system design, development using various tools and techniques, testing, and implementation.
3 or more years experience working in and/or dynamic cross-competency teams using a structured project development methodology.

Applicants should be able to develop application domain knowledge and provide subject matter expertise as needed over time.

Preferred Qualifications

Experience in Informatica Toolset is must. Ex: Power Center Designer, Power Exchange, Workflow Manager and Workflow Monitor.

Create and maintain source to target mapping specifications, detailing integration and transformation logic, using applicable standards.
Create ETL mappings using Informatica tools to extracts, transform, and load data as per specifications.

Experience with Oracle 11g, Oracle Tools such SQL Loader, External Tables and Stored Procedures and ProC programs.
Experience in UNIX systems, writing Shell Scripts that control Job Execution.
Good understanding and experience in UNIX Operating System Commands and File System management.

Perform peer document reviews and code reviews to ensure adherence to user requirements as well as applicable standards and conventions.
Perform required testing of developed procedures and mappings.
Strong Database skills, experience in writing queries, Data Mining experience, and exposure to ETL development are preferred.
A strong background working across various teams such as Infrastructure, QA, Configuration Management, Database Administration, UNIX Admin and Production Control Teams.

Coordinate with the offshore team during the entire life cycle of the project.

Minimum Education and Certifications

Undergraduate degree or equivalent combination of education and work experience.
Graduate degree preferred

- provided by Dice Informatica, Oracle

Inform a friend!

location

Nearby jobs

C++ WiFi Engineer Sunnyvale

Business System Analyst San Ramon

RF TEST Engineer San Jose

Top