Sign In
 [New User? Sign Up]
Mobile Version

Lead ETL Developer


Norfolk, VA
Job Code:
  • Transportation / Warehouse
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

Company ADP USA

Job Title: Lead ETL Developer

JobID: adp-5000176084206

Location: Norfolk, VA, 23509, USA

Description: You have one of the most important positions at ADP: Keeping our technology solutions performing for our 600,000+ clients and 57,000 associates around the globe. As part of the GETS team (Global Enterprise Technology Solutions), our mission is simple: Keep people productive by building solutions they want and keep them smiling with our awesome service. #winning What's our secret sauce for success? Well, that's easy. It's our growing team of fantastic associates who make it all happen. We're collaborative, fast-paced, transparent, fun and expect the same from you. Your ideas matter and your impact can be felt from the moment you arrive. So, are you ready to get in on the ground floor of something great? Awesome... ADP has a Lead ETL Developer for our Norfolk location! Job Summary Provides Data Warehouse data model and data integration solutions on complex projects. Partners with business owners and technology liaisons to translate requirements into data warehouse and business intelligence solutions. Architects, develops and maintains logical/physical data models, data integration, data transformations and data loads. Primary Activities and Responsibilities
* Design and develop overall data architecture, data model, database design, data integration, transformations, and load processes
* Perform data analysis to design and develop appropriate design models for warehouse and BI analytics
* Collaborate with team to develop data architecture design
* Develop logical and physical data models to support design and development of data warehouse and data marts
* Work in partnership with database administrators to implement physical data model in to high performing database
* Translate client user requirements into data flows and data mappings
* Architect, develop and implement data integration process (ETL) using Informatica to load data warehouse and data marts
* Monitor operational ETL data loads; Investigate and resolve any ETL/data warehouse issues, as needed
* Troubleshoot and provide technical assistance in the use and understanding of existing data warehouse
* Miscellaneous activities and responsibilities as assigned by manager Minimum Qualifications
* Bachelors degree in Information Systems/Technology, Computer Science, or Computer Engineering
* 7-10 years of Data Warehouse and ETL experience
* 7-10 years working with Oracle and/or MS SQL Server databases in a Data Warehouse environment Knowledge and Skills
* 7 - 10 years of logical and physical data model development in data warehouse environment
* 7 -- 10 years of ETL development
* Experience with Informatica PowerCenter 9.x and Informatica Data Quality (IDQ)
* Ability to perform data analysis and data profiling to help in data architecture
* Experience in developing dimensional models with conformed dimensions
* A good working knowledge of Oracle and MS SQL Server databases
* Skill in developing requirements and technical specifications documentation
* Ability to design, develop, and deploy new solutions while supporting and enhancing existing enterprise solutions
* Experience with Data model development using Erwin is a plus
* Experience with OLAP development is a plus
* Knowledge of Big Data platform is a plus
* Knowledge of Cognos 10 is a plus
* Knowledge of Agile data warehouse development methodologies is a plus
* Good oral and written communication skills are expected Education: Bachelors #cb# #LITECH

Featured Employers

Featured Jobs

CareerConnection Video