Skip to content
Veredus A Hays Company
  1. I am
    I am

Talk to a recruiter


Talk to the recruiter managing this position, located in Raleigh

Contact recruiter
ttelephone:813 936 7004
2840 Plaza Place, Suite 340, Raleigh, North Carolina,NC 27612

Search for jobs

Sr. ETL Developer


Job type
$55 p/h - $60 p/h



This position is NOT eligible for subcontractors or those that require sponsorship

The ETL Designer/Developer (ETLD) will be responsible for designing, developing, testing and administering of transactional and analytical data constructs/structures, data warehouses, data marts, developing the overall design for data movement and aggregation, information delivery and data quality. The ETLD will support the Business SME in gathering the data requirements from the business stakeholders, performing gap analysis and working with the development team in order to transform the requirements vision into working code. Included within the ETLD responsibilities are the areas of integration, performance tuning, data access and delivery technologies, data mining, extract transform load (ETL), design and documentation of data movement schemes, and mapping documents between applications. Leads solutions delivery on Data Management team; work is performed without appreciable direction. Delivers clear concise communication to project team and mid-level managers. Provides support and solutions for data marts and enterprise level data warehouses

This role requires strong knowledge on designing and developing ETL processes including Technical/Functional responsibilities:
• 5 years’ experience with ETL tools with an excellent knowledge of ETL concepts
• Creates ETL Detail Design & ETL specs at the (Informatica) mapping level
• Leads ETL data mapping processes
• Performs design, completes development and implements integration and interface requirements
• Collaborates with team members regarding industry standard data management practices and standards (viz., CDISC, etc.)
• Develops SQL queries and shell scripting
• Creates Informatica, Unix, and Oracle code artifacts
• Automates the jobs and scripts
• Performs Unit Testing
• Does performance tuning using the ETL tool
• Resolves defects during testing
• Creates deployment guide and Runbook for support phase of project
• Organizes and consolidates scripts for workaround and production support
• Extensive experience in developing stored procedures, views, functions, triggers, & advanced logical methods; writes SQL and shell scripts and develops reports as required
• Excellent knowledge of SQL/Oracle and relational databases
• In conjunction with Business SME Data, interviews operations stakeholders and understands/documents their business requirements

• Requires a Bachelor's degree in Computer Science, Information Systems, Business Administration or other related field or equivalent experience
• Training in the use of MDM, Metadata, ETL tools desired

• 5 years direct ETL tool experience
• Experience with Informatica
• Experience working with relational technologies including Oracle and SQL Server, star schemas and OLAP
• Data mapping experience in design and implementation
• Comfortable working with complex data structures
• Microsoft .Net experience (ASP.NET, C#, VB.NET, ADO.NET, WPF, Silverlight) a plus
• Ability to influence multiple levels on highly technical issues and challenges
• Experience in writing SQL and shell scripts
• Expert knowledge of MS Word, Excel, Project, PowerPoint and Visio
• Strong customer focus with a demonstrated ability to work closely with technical teams and business users alike

Follow us on our BLOG to see more jobs like this:

Why Veredus?

Candidates work with a professional Recruiter whose average experience is eight years in the industry. That means they have intimate knowledge of the Information Technology industry and market trends - who is in demand now and who will be next. Your Veredus Recruiter will lead you through a thorough screening process in order to understand your skills, experience, needs, and desires. They also counsel their candidates in resume writing, interviewing, and career planning so when there’s a position you really want, you’re fully prepared to get it. Additionally, if the position is a consulting opportunity Veredus provides full benefits starting Day 1, and at virtually no cost to you.

• Medical
• Dental
• Vision
• 401K
• Life Insurance ($20,000 benefit)
• ATOP - Accrued Time Off Program
• Consultant Lunches and Outings
• Consultant Web-Site
• Name Plates
• Care packages/Survival packs
• Dedicated Consulting Services Representative

Veredus has been recognized as one of the “Best Staffing Firms to Work For” by Staffing Industry Analysts the last 3 years in a row.

Nervous about an upcoming interview? Want to be as prepared as possible?

Click on the link below and you will have access to the Veredus Interview Prep Video - culled from hundreds of years of collective experience in preparing candidates for that all important job interview:

Veredus Corporation is an EEO/Affirmative Action Employer M/F/D/V.

Drug testing may be required; please contact Recruiter for more information.

Email this job to a friend