The Data Modeler will design, develop and maintain a variety of different ETL programs using various technologies - specifically ODI, Informatica PowerExchange including batch and NRT jobs, Oracle 11g PL/SQL, as well as Unix Scripting (KSH, CSH, PERL). This position will also act as the Enterprise Data Warehouse data modeler.
Duties and Responsibilities
* Work with business requirements and act as a technical analyst to identify and understand source data systems
* Create and maintain SDLC documentation as part of development tasks
* Adapt ETL processes to accommodate source system(s) changes in source systems or new requirements
* Provide expertise in ETL performance tuning
* Serve as the technical data warehouse team expert
* Map source system data into data warehouse models
* Coordinate with Technical Architects, other Data Modelers and DBAs to review design strategies for new ETL processes
* Design, develop and maintain different ETL programs in various technologies including Informatica PowerExchange including batch and NRT jobs, Oracle 11g PL/SQL, and Unix Scripting (KSH, CSH, PERL)
* Strong technical analytical skills with an ability to provide creative solutions to problems
* Participate in aspects of business user consulting, system analysis, and general system designs
* Develop and maintain Enterprise Data Models sources
Skills and Qualifications
* Bachelor of Science degree in Computer Science or a related field
* Knowledge of Oracle 11g Databases
* Demonstrated experience using Informatica PowerExchange (near real time and batch)
* Experience in troubleshooting and debugging * Experience in Logical and Physical Data Modeling
* Experience in Data Warehousing
* Expertise in problem solving at the highest level
* Unix Scripting (KSH, CSH, PERL)
* Communication skills that can energize multi-disciplined work teams to respond to business needs.
* Must be able to work independently and as a member of a team.
* Strong organizational and customer service skills.
* Ability to identify solutions, recognizes the impact of alternatives, and determines a solution which results in the optimum outcome for the business unit.
* Must be able to manage resources, timelines, deliverables and expectations for related projects.
* Must be comfortable and good at interacting and communicating with all levels inside and outside of the IT department
Opportunity for a level of responsibility that could take years to reach in other companies
Equal Employment Opportunity/Affirmative Action Employer
Send resume to Colin.Driessner@echostar.com
No third party recruiters
