The ETL Developer will be responsible for the scripts and processes required to extract, transform, clean and move data and metadata so they can be loaded into a data warehouse, data mart or operational data store. Reads, analyzes and digests what the company wants to accomplish with its data, and designs the best possible ETL process around those goals.
Essential Duties and Responsibilities- Work with business requirements to identify and understand source data systems; provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
- Map source system data to data warehouse tables
- Provides analysis, design and development utilizing BI tools. Debugs and resolves data errors.
- Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
- Define and capture metadata and rules associated with ETL processes
- Adapt ETL processes to accommodate changes in source systems and new business user requirements
- Analyze business requirements holistically and as they relate to the ETL process, research, evaluate and recommend alternative solutions.
- Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.
- Provide support and maintenance on ETL processes and documentation
- Working with Informatica cloud software, create simple data flow
- Build partnerships across the application, business, and infrastructure teams
- Strive to continuously improve the software delivery processes and practices
- Champion company standards and best practices
- Perform other duties or responsibilities as necessary or assigned.
- Regular Attendance is required
Scope- Staff supervision and Development -No
- Decision Making - Provides data for decision support, Provides consultation or expert advice
- Travel - Less than 10 %
- Location - Corporate HQ (?)
The anticipated salary range for this position is $98,500- $147,800 depending on location, knowledge, skills, education and experience. This position is also eligible for an annual discretionary bonus. In addition, we offer comprehensive and competitive benefits to Associates (and their families) such as medical, dental, vision, life insurance, short-term and long-term disability. Eligible Associates are able to enroll in our company's 401k plan. Associates will accrue paid time off up to 236 hours per year (inclusive of PTO, floating holidays, and paid holidays). Paid sick time up to 80 hours per year unless otherwise required by law.