Design, develop, test, debug, implement and maintain Extract, Transformation & Load (ETL) processes in IBM DataStage. 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 Georgia Tech Campus Services, external solution providers, campus units. This position typically will advise and counsel: management and personnel within Campus Services information Technology Group (ITG). This position will supervise: NA.
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: Four to five years job related experience
Years preferred: Five or more years in ETL development.
Certifications or licenses required for this job:
Certifications or licenses preferred:
Specialized skills required for this job:
This job requires advanced knowledge and expertise in IBM DataStage, SQL Server and (to some degree) Oracle. Additionally required are skills in analysis, critical thinking, problem solving and trouble shooting, oral and written communications and presentation and expertise in data profiling and data quality concepts and techniques.