Lead ETL Developer (Informatica)

US, US, CA - San Diego

Minimum Level of Education Required: Bachelors Degree

Percentage of Travel: Up to 10%

Location: CA - San Diego

Ref#: 16357

Share with: LinkedIn Google Plus Facebook Twitter

Apply Now
Job Description

Summary:

Now is the perfect time to join a growing company with an extremely noble cause. At NuVasive, you will not only help to drive business value, but actually see its impact. As part of NuVasive’s IT organization, you will be joining the best IT business in the spine industry. In IT, we are in a unique position which allows us to positively impact patients’ lives. As a part of our team, you will truly make a difference in someone’s life.

This is an exciting opportunity to showcase your Data Warehousing & ETL expertise and help grow and mature the enterprise data warehouse. This position will help design, develop and provide operational support for ETL projects and activities. He or She will also be required to work with functional analysts, end users and other BI team members to design ETL solutions, convert user requirements and functional specs to technical designs and mentor BI team to use best practice ETL designs. Other responsibilities may include gathering BI / reporting requirements, development and maintenance of BI Reports, models and Cubes as needed. 

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

 

QUALIFICATIONS:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

 
  • Technical design, development, testing, documentation of Data Warehouse / ETL projects

  • Perform data profiling and logical / physical data modelling to build new ETL designs and solutions

  • Develop, implement and deploy ETL solutions to update data warehouse and datamarts

  • Maintain quality control, document technical specs and unit testing to ensure accuracy and quality of BI data

  • Troubleshoot, debug and diagnose ETL issues

  • Provide production support and work with other IT team members and end users to resolve data refresh issues – provide off hours operational support as needed

  • Have the ability to work with users, BI and ERP teams to get ETL solutions developed and implemented

  • Performance tuning and enhancement of SQL and ETL processes and prepare related technical documentation

  • Meet with functional analysts and /or end users to gather/ clarify requirements as needed to complete BI/ DW projects

  • Participate in ad-hoc BI/ DW projects as required

  • Develop and enhance BI reports, models and Cubes and provide support as needed

  • Work with Offshore team to coordinate development work and operational support

  • Keep abreast of latest ETL technologies and plan effective use

  • Help build solutions pertaining to Predictive analytics and/or  Big data

  • Communicate very clearly and professionally with users, peers, and all levels of management. The communication forms include written and verbal methods

  • Adhere to the processes and work policies defined by management

Basic Qualifications
  • EDUCATION and/or EXPERIENCE

    Bachelor's degree (B.S.) from four-year college or university. Understanding of ERP business processes, data warehouse and BI concepts and ability to apply educational and practical experience to improvise business intelligence applications and provide simplified and standardized solutions to achieve the business objectives.

     

    More than 7 years in ETL:

  • Expert knowledge of data warehouse architecture

  • Expertise in dimensional modeling, star schema designs including best practices for use of indexes, partitioning, and data loading.

  • Advanced experience in SQL, writing Stored procedures and tuning SQL, preferably using MS SQL Server.

  • Strong experience with Informatica Powercenter.

  • Experience developing software applications as part of a team, employing practical and effective software design concepts.

  • Well versed with database administration tasks and working with DBAs to monitor and resolve SQL / ETL issues and performance tuning

  • Experience in trouble shooting data warehouse refresh issues and BI reports data validation with source systems.

  • Independent problems solving skills.

  • Strong interpersonal and communication skills and ability to interact positively with peer groups within IT / BI teams and management.

  • Open to learn and acquire new skills.

Preferred Qualifications
  • Preferred experience with Informatica Cloud

  • Preferred experience in Tableau, Cognos or other BI applications

  • Preferred with experience working in the SAP ECC, SAP B1 or other ERP applications

  • Preferred with experience in Big Data and/ or use of Predictive tools (eg SPSS, R)

#GD1
NuVasive is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability. The “EEO is the Law” poster options are available here.
Apply Now

Share with: LinkedIn Google Plus Facebook Twitter

Talent Community

Join one of our Talent Communities

Are you interested in joining NuVasive , but don't see the job opening that 's right for you? Join one of our talent communities and your information will be added to our prospect pool to be used when future positions open up!