This position is no longer open for applications

ETL Developer

Job Description:

ETL Developer Summary:

Signature Consultants is seeking an ETL Developer for an opportunity in Charlotte, NC. The ideal candidate will have at least 5+ years of experience doing traditional large scale Database development including SQL, DML, DDL, as well as experience writing ETL packages/programs using Informatica version 9.0 or above. Experience with developing on the Netezza database platform is required.

Requirements:

  • ANSI SQL (T-SQL, PL/SQL,etc). Experience with Netezza or other MPP database platforms.
  • Query Optimization strategies. Extensive experience in construction, testing, and performance tuning of SQL and data integration processes.
  • Excellent hands-on experience in Unix/Linux shell scripting and complex SQL queries.
  • ETL Development leveraging Informatica or other ETL tools
  • Experience with working with data sets from multiple sources (Oracle, Netezza, Teradata, SQL Server, etc.)
  • Experience with complex transformations including Unions, Routers, Normalizers, and custom calculated fields
  • Slowly Changing Dimensions
  • Informatica Administration skills preferred
  • Proficient in Data Warehousing concepts
  • Star/Snowflake schemas
  • Dimensional tables (Type 1, Type 2, Type 3)
  • Strong analytical skills and critical thinking with strong focus on problem solving and converting business requirements into solution specification, design and solution.
  • Must have experience in large multi-terabyte data warehouse environments
  • Work collaboratively with architects and DBAs to identify, troubleshoot, review and resolve any errors and performance issues
  • Candidate must be highly skilled, motivated team player with excellent communication and inter-personal skills.
  • Ability to work well under pressure and meet deadlines. Ability to multi task in a fast paced environment.
  • Experience working at Financial Institutions is preferred

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the seventh consecutive year, Signature was voted as one of the “Best Staffing Firms to Work For” and is now the 15th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 25 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients’ technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com.

Apply Now

To apply for this job, please complete the following 6 fields and we will immediately follow-up (* = required).

Choose File
.doc, .docx, .txt, .pdf, .html
Would you like to help us get to know you even better?

The intent of asking for the following information is to assist Signature in meeting its commitments to equal opportunity and affirmative action requirements. Completing and returning this section is purely VOLUNTARY on your part and will have absolutely no effect on the status of your employment application.

Signature Consultants is committed to providing reasonable accommodation to qualified individuals with physical and mental disabilities according to state and federal disability discrimination laws. If, because of a disability, you need assistance or a reasonable accommodation for any part of the employment process, please email hr@sigconsult.com or call 888-838-1020. Signature Consultants will partner with you in good faith to identify and implement a reasonable accommodation, if any, that is appropriate and consistent with its legal obligations.

Signature Consultants is an Affirmative Action and Equal Opportunity Employer, Minority/Female/Disabled/Veteran/Gender Identity/Sexual Orientation.

EEO is the law: http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf