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

About vinceter1

Onthe company side: TechEdge Recruiting delivers with a one on one approach to staffing technical hiring needs for clients throughout New England. With over 15 years of relative industry experience, we will deliver Quality versus Quantity. We have full life cycle recruiting expertise to provide you with a seamless and confidential process from initial interview set up through salary negotiations. We will respond quickly to your planned and unplanned staffing needs. In fact, we often present candidates that you may miss in your internal recruiting efforts. We thoroughly screen and extensively check credentials and references to present candidates who best match your business needs, functional requirements, and company culture. Then, we handle negotiations and monitor satisfaction. We have a diverse client base to draw from in various industries which includes High Tech, Financial Services, Life Sciences, Retail, Manufacturing, Healthcare and Government. Our goal is to provide companies with the talent they need to grow and to enhance the careers of the candidates we represent. We provide the best-suited candidates for you to screen based upon your requirements. We become a partner with your organization to provide you with the most compatible fit for your specific needs. We will make sure each candidate is well informed and qualified for your position. Companies turn to us for our expertise in understanding exactly what they seek (and because we take the time to learn what our candidates seek). We take pride in offering the most effective and discreet placement services available. Because of that, we are able to attract top notch, technology savvy, bright individuals and help them grow in great companies. You pay us NO FEE unless or until you hire our candidate. Expertise in the following areas: Database Administration/Development-Oracle, SQL Server Desktop/Help Desk Support Network & Infrastructure Engineering-LAN/WAN/SAN, Security, Firewalls, Messaging System Administration-Unix or Windows based, Linux Web Development/Software Engineering SAP/Peoplesoft Consultants SharePoint Developers, Administrators, Analysts & Architects On the Candidate side: TechEdge Recruiting works with Information Technology professionals using a one on one approach to assist in attaining your career goals. Our services are effective and discreet. We have a diverse company client base in various industries which include High Tech/Software, Financial Services, Life Sciences, Retail, Manufacturing, Healthcare and Government. Companies turn to us for our expertise in understanding exactly what they seek because we take the time to learn what our candidates seek. We are results oriented and pride ourselves in elevating the careers of talented people. We do this while helping View all posts by vinceter1

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

TechEdge Recruiting Blog

Quality versus Quantity

Captain Kirk's Fishing Blog

Quality versus Quantity

%d bloggers like this: