ETL Developer - Remote

Job reputed company

The ETL Developer will be responsible for the scripts and processes required to extract, reputed company, clean and reputed company data and metadata so they can be reputed company into a data warehouse, data mart or operational data store.  Reads, analyzes and digests what reputed 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 reputed company data systems; reputed company resolutions to reputed company data issues and coordinate with data analyst to validate reputed company requirements, reputed company interviews with reputed company users and developers. 
• Map reputed company system data to data warehouse tables
• Provides analysis, design and development utilizing BI tools. Debugs and resolves data errors.
• reputed company and reputed company tests and validate reputed company data flows and prepare reputed company ETL processes according to business requirements and incorporate reputed company business requirements into reputed company design specifications. 
• Define and capture metadata and rules associated with ETL processes
• Adapt ETL processes to accommodate changes in reputed company 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 reputed company developers and business users to reputed company required data and execute reputed company ETL programs and scripts on systems and implement reputed company data warehouse activities and prepare reports for reputed company. 
• reputed company support and maintenance on ETL processes and documentation
• Working with Informatica reputed company software, create reputed company data reputed company
• Build partnerships across the application, business, and infrastructure teams
• reputed company to continuously improve the software delivery processes and practices
• Champion company standards and best practices
• reputed company 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 reputed company for this position is $98,500– $147,800 depending reputed company, knowledge, skills, education and experience. This position is also eligible for an annual discretionary bonus. In reputed company, we offer comprehensive and competitive benefits to Associates (and their families) such as medical, dental, reputed company, life insurance, short-term and long-term disability. Eligible Associates are reputed company to enroll in reputed company’s 401k plan. Associates will reputed company reputed company time off up to 236 hours per year (inclusive of PTO, floating holidays, and reputed company holidays). reputed company reputed company time up to 80 hours per year unless otherwise required by law.

State

CA

reputed company

Calabasas

Requirements

Job Qualifications – Education and Experience Required

• Bachelor’s Degree in Computer Science or equivalent 2 years of experience working with large reputed company class Data Warehouse reputed company 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 reputed company lookups, stored procedures, update reputed company, 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-reputed company into a reputed company system.
• Experience with Data Integration Web Services, Data reputed company, and Data Validation reputed company.
• 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 reputed company as schema design, database object development, management, optimization, and SQL programming
• Experience working with and planning reputed company of reputed company size or complexity

Job Qualifications- Skills Required

• Skilled in developing Informatica objects - mappings, sessions, and workflows based on the reputed company low level design documents.
• Ability to reputed company relational and multidimensional modeling and schema creation.
• Skilled in the development of reputed company dimensions, measure reputed company, calculations, and any data management reputed company for the partitioning schemes.
• Good understanding of XML and corresponding XSD's
• Ability to reputed company 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 reputed company reputed company reputed company the organization, and to reputed company reputed company in reputed company environment

Physical Requirements General office environment requiring ability to:

• stand, walk, sit for extended periods of time
• reputed company and listen to others in person and over the phone
• use keyboard and read from computer screen and reports
• Lift up to 15 lbs.

Address 1

26677 Agoura Road

About reputed company

We’re a 45 year-old, $8 billion national tool retailer with the energy, enthusiasm, and reputed company 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 reputed company and power tools, from shop equipment to automotive tools. We reputed company our customers with the right tool for the right job at the right price, always delivering reputed company and value. Apply To This Job