Description
JOB PURPOSE:
Design, develop, test, debug, implement and maintain Extract, Transformation & Load (ETL) system. Includes workflows, mapping, scripts and stored procedures to support business application needs.
IMPACT & INFLUENCE:
This position will interact on a consistent basis with: management and personnel within OIT - Enterprise Information System group, external solution providers, and campus units. This position typically will advise and counsel: management and personnel within OIT - Enterprise Information System group, external solution providers, and campus units. This position will supervise: NA.
KEY RESPONSIBILITIES:
Duties may include but are not limited to:
- Perform source to target data mapping.
- Review and assess business rules, project plans, development and test specifications.
- Create and run tests on all solutions while optimizing ETL processes.
- Plan, schedule and coordinate changes internally and externally.
- Provide on-going maintenance and support of production ETL processes. Monitor production processes and respond to errors and emergency issues.
- Collaborate with business units to provide information as appropriate.
- Document all ETL processes.
- Perform other related duties as assigned.
EDUCATION, SPECIALIZED KNOWLEDGE AND EXPERIENCE:
Degrees required for this job: Bachelor's degree in Computer Science or related field or equivalent combination of education and experience
Years of experience required for this job: 5 - 8 years of experience with Data Stage and extensive experience in web service based integrations.
Specialized skills required for this job:
- Data Modeling
- Data Warehousing
- IBM Infosphere DataStage
- Web Service Integrations
- Oracle SQL
- Workday Financials
ABOUT ESG CONSULTING:
ESG Consulting is an award-winning national provider of diversified information technology consulting services to Fortune 1000, public sector entities, and emerging growth firms nationwide.
Founded in 1984, ESG offers almost 35 years of experience in the IT staffing, Engineering and consulting industry. Headquartered in Santa Clara, we have opened offices nationwide and to this day are consistently re- evaluating and expanding our service offerings and geographic capabilities. Today, we serve most major metropolitan markets.
ESG is an equal opportunity company. Our flexible management culture believes in creating a business environment that fosters personal and professional growth and achievement. We make ESG a place where people are treated not as employees but as "partners".