Job DescriptionThe 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.
RequirementsJob Qualifications - Education and ExperienceRequired
- Bachelor's Degree in Computer Science or equivalent 2 years of experience working with large enterprise class Data Warehouse projects as an ETL Developer or equivalent combination of education and work experience.
- Experience working with Informatica PowerCenter 10.x and with many of the transformations of Informatica including complex lookups, stored procedures, update strategy, mapplets, processes, and load routines, etc.
- Strong experience and passion for Business Intelligence and Data Warehousing design principles and industry best practices.
- Experience in requirements gathering and creating architectural, detail design documents and mapping documents.
- Experience in debugging mappings and identifying errors and error rows so that they can be corrected and re-loaded into a target system.
- Experience with Data Integration Web Services, Data Quality, and Data Validation Option.
- Experience automating ETL processes with Informatica PowerCenter.
- Solid experience in database query/performance optimizations.
- Experience with SQL Server 2012 through 2019 in the areas of database administration, as well as schema design, database object development, management, optimization, and SQL programming
- Experience working with and planning projects of medium size or complexity
Job Qualifications- SkillsRequired
- Skilled in developing Informatica objects - mappings, sessions, and workflows based on the prepared low level design documents.
- Ability to perform relational and multidimensional modeling and schema creation.
- Skilled in the development of cube dimensions, measure groups, calculations, and any data management code for the partitioning schemes.
- Good understanding of XML and corresponding XSD's
- Ability to interact with other departments and business users who are not as technical in nature.
- Ability to understand system functionality, process, and architecture at a technical and business level.
- Proven communication and presentation skills to effectively communicate information to all levels within the organization, and to interact well in a team environment
Physical RequirementsGeneral office environment requiring ability to:
- stand, walk, sit for extended periods of time
- speak and listen to others in person and over the phone
- use keyboard and read from computer screen and reports
- Lift up to 15 lbs.
About Harbor Freight ToolsWe're a 45 year-old, $8 billion national tool retailer with the energy, enthusiasm, and growth potential of a start-up. We have over 1,600 stores in 48 states across the country and are opening several new locations every week. We offer our customers more than 7,000 tools and accessories, from hand tools and generators to air and power tools, from shop equipment to automotive tools. We provide our customers with the right tool for the right job at the right price, always delivering quality and value.
