ETL informatic Developer
Global Data Solutions Inc.
San Leandro, California, United States
Job type: all
Job industry: I.T. & Communications
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.
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