Open Jobs

Back to Jobs

Senior Data Integration/ETL Developer

  • Location: Nashville, TN
  • Salary: DOE
  • Posted: Sep 17

Programming Resources, Inc has an exciting opportunity that may interest you!

Job Description
Senior Data Integration/ETL Developer
 
Location
Nashville, TN
 
Fulltime
 
Position Summary
Responsible for the design, development, and execution of automated and manual data ETL, integration, and exchange processes across the enterprise.  Will recommend, implement, develop and utilize innovative tools and processes to efficiently, rapidly, and securely acquire, integrate, and provision large sets of data from and to thousands of sources and customers around the world.​ 

Primary Duties

  • Responsible for the efficient, compliant, timely, and secure acquisition, integration, provision, and exchange of the enterprise data.
  • Provide data integration architecture leadership across the enterprise.
  • Work with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions.
  • Develop ETL technical specifications and recommend, design, develop, test, implement, and support innovative and optimal data solutions.
  • Develop and document technical best practices for ETL-related activities including data movement, data aggregation, data quality, and data cleansing.
  • Work with the Data Warehousing and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations.
  • Integrate ETL development with existing codebase to maximize object reuse.
  • Create, execute, and document unit test plans for ETL and data integration processes and programs.
  • Document ETL processes, programs and solutions as per established standards.
  • Perform tasks required to conform to the company’s configuration management and software release processes.
  • Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance.
  • Work with internal staff, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues.
  • Assess and document the structure, quality, and compliance of data source data and coordinate with business and technology staff to identify and resolve issues.
  • Mentor other Data Services team members in the ETL tools, programs, processes, and best practices.


Education and Experience

  • Bachelor's Degree in Computer Science or Mathematics.  Work experience as a senior ETL developer in an enterprise business environment may be considered equivalent.
  • Minimum 6 years experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools (experience with IBM DataStage/QualityStage is preferred).
  • Minimum 6 years experience developing and implementing data integration and DW solutions in an Oracle 11g/12g database environment (experience with Netezza preferred; experience with DB2 is a plus; experience with Oracle EBS is a plus; experience with Salesforce is a plus).
  • Minimum 2 years experience working with BI tools (IBM Cognos is preferred).
  • Minimum 2 years experience working in a SOA environment.
  • Minimum 2 years experience working with high volume data exchange and transaction processing systems, preferably in a custom software development environment
  • Minimum 1 year experience in 10+ TB data environment.
  • Minimum 2 years experience integrating large (100M+ rows) structured and unstructured data in multiple formats, character sets, and delivery methods.

Knowledge, Skills and Abilities

  • Expertise in RDBMS, Data Mart and Data Warehouse design. Knowledge of data modeling, MDM, BI, and CRM is preferred.
  • Expert-level SQL and PL/SQL development skills in a multi-tier, SOA environment are required. Experience with advanced features such as PL/SQL analytic functions is highly preferred.
  • Expertise in flat file formats, XML within PL/SQL, and file format conversion.
  • Expertise in web services development.
  • Strong understanding of SDLC and Agile Methodologies.
  • Strong understanding of Model Driven Development.
  • Strong understanding of ETL best practices.
  • Expertise and hands-on experience with design and development best practices.
  • Expertise in working with technical and business teams to extract and document data integration/exchange requirements.
  • Ability to express complex technical concepts effectively, both verbally and in writing.
  • Ability to handle multiple projects and deadlines with minimal supervision.
  • Dedicated to excellence in one’s work; detail-oriented and thorough.
  • Must be willing to work overtime, including weekends, when required.

No relocation or sponsorship available for this position

Interested applicants please forward your resume and desired salary range to 



Job listings powered by the CATS Applicant Tracking System - ©2010 CATS Software, Inc.