Tag Archives: ETL Development

Sr./Principal ETL Developer-up to 120K base plus bonus -NH Seacoast location

Responsibility Summary:

The position is responsible for generating all scripts required to transform the source data into the Oracle physical tables including the associated processes necessary to provide robust recovery and performance. This position is responsible for producing and maintaining logical and physical data models of enterprise business data as well as the physical data architecture of the Oracle data warehouse.

Major Activities and Functions:

Creates deliverables that include: PL/SQL scripts, various ETL jobs, job schedules. Uses SQL and Oracle utilities to research and trouble shoot data issues.  Collaborates on deliverables that include: Physical Data Models, Dimensional Data Models and other Data Management artifacts.  Analyzes business and functional requirements of assigned projects and translates into technical specifications and data rules required for the construction of the Oracle data warehouse.  Keeps all documentation (business and technical metadata, data models, guidelines and standards, etc., processes) current.  Develops standards and strategies to ensure data quality.  Establishes standards for tools and infrastructure for data management.  Participates in a team environment for the delivery and maintenance of data models in support of application system databases.  Effectively applies software development methodology and adheres to standards, including change management. Assists in system monitoring responsibilities and makes recommendations for capacity planning. Provides training and knowledge transfer to the application support group.  Provides project documents and deliverables in adherence to project plans.  Fosters/maintains good relationships with customers and IT colleagues to meet expected customer service levels.

Job Requirements

BS   in Computer/Information Science, Mathematics or equivalent is required.3-5   years of relevant data warehouse experience including at least 2 years   experience in:

Designing,   developing and testing PL/SQL scripts for ETL development

Experience   in at least one COTS ETL tool

Usage   of SQL and Oracle utilities to research and troubleshoot data issues

Understanding   of Oracle performance tuning sufficient to communicate with tuning team

Understanding   of BI concepts sufficient to insure good communication with BI team and   provide design solutions that meet their needs

Demonstrated   experience with logical, physical, and dimensional data modeling,   process modeling and data mart / warehouse design.

Understanding   of diagramming and the documentation of requirements, including data   dictionary and metadata repository.

Must   be highly motivated, have a great work ethic and work effectively with other   team members, while requiring minimum direction.

Ability   to analyze, diagnose and resolve data management related problems.

Familiar   with full life cycle software development processes, especially as they   pertain to data movement and data integration.

Candidate   must be willing to delve into the details to solve technical taking a   hands-on approach.

Strong   written and oral communications skills coupled with active listening skills.

Ability   to be flexible with work schedule, including nights, weekends, and holidays   as required and to be part of the on call rotation when the application   enters the support phase.

Knowledge   of Oracle ERP and Cognos Tool set is a plus.

Education

Bachelor’s Degree

Advertisements

TechEdge Recruiting Blog

Quality versus Quantity

Captain Kirk's Fishing Blog

Quality versus Quantity