Lead ETL Developer
Unit Description
Sodexo is currently seeking a Lead ETL Developer who works to design, document, develop, test, implement and support efficient and...
Unit Description
Sodexo is currently seeking a Lead ETL Developer who works to design, document, develop, test, implement and support efficient and reliable mappings using the latest version of Informatica PowerCenter.
Specifically, the Lead ETL Developer will:
- Apply advanced DW techniques and Informatica best practices to load a Financial, HR & Supply Management Data Warehouse, Data Marts and Downstream Systems.
- Administer Informatica repositories during system outages, software upgrades and user access provisioning.
- Be proficient in working with multiple Informatica repositories, version control, deployment groups, mapping and folder migrations.
- Develop new Informatica programs and debug existing programs and tables within the data warehouse, applying an advanced understanding of relational database design concepts and of writing SQL queries, knowledge of UNIX, and experience using a job scheduler.
- Ensure that all Enterprise procedures such as unit and system testing, change management, documentation, promote to production, etc. are followed.
- Provide reliable and timely 24-hour support on a rotating schedule utilizing advanced problem-solving techniques.
- Work with Business Groups and Data Architects to understand requirements prior to design of ETL solutions.
- Collaborate with the DBA team to ensure optimized performance of all Informatica mappings.
- Work with the Reporting/Analysis teams when dealing with testing and modifications to Data Marts.
- Works closely with the Scheduling team to develop and test AutoSys jils prior to production implementations.
Special skills, knowledge, or certification and/or licensure required for position (not preferred):
- Demonstrated extensive experience using Informatica PowerCenter.
- Demonstrated advanced understanding of relational database design concepts and of writing SQL queries.
- Proven basic UNIX knowledge.
- Demonstrated experience using a job scheduler.
- Demonstrated ability to work in a team environment.
- Proven strong project planning, time management, verbal and written communications skills.
- Experience with big data.
- Experience with data mining.
Sound like the opportunity you’ve been waiting for? Apply TODAY! We look forward to hearing from you.
Position Summary
Works in a data warehouse environment which includes data design, database architecture, metadata and repository creation. Translates business needs into long-term architecture solution. Defines, designs and builds dimensional databases. Responsible for developing data warehousing blueprints, evaluating hardware and software platforms, and integrating systems. Evaluates reusability of current data for additional analyses. Conducts data cleaning to rid the system of old, unused, or duplicate data. Reviews object and data models and the metadata repository to structure the data for better management and quicker access.
Qualifications & Requirements
Basic Education Requirement - Bachelor’s Degree
Basic Functional Experience - 3 years of experience in data warehouse development Sodexo is an EEO/AA/Minority/Female/Disability/Veteran employer.
Below are some other jobs we think you might be interested in.
-
Mobile/Web Developer (.Net)
- Air Line Pilots Association
- Atlanta, GA, USA
May 17 -
Assistant Director, Infrastructure and Business Development
- Metropolitan Transportation Commission
- San Francisco, CA, USA
- Hybrid
Apr 29 -
IT Service Management Specialist
- Pennsylvania Turnpike Commission
- Middletown, PA, United States
- Hybrid
May 01 -
Executive Vice President Information Technology and Chief Information Officer (EVP & CIO)
- Bonneville Power Administration
- Portland, OR, USA
- Hybrid
Apr 27 -
Information Technology Director
- City of Tigard
- Tigard, OR, USA
May 08 -
Assistant Director, Service Delivery
- Metropolitan Transportation Commission
- San Francisco, CA, USA
- Hybrid
Apr 29 -
Senior Cyber Security Analyst
- Valley Water
- San Jose, CA, USA
May 13 -
IT Vendor & Contracts Manager
- Washington State Department of Natural Resources
- Olympia, WA, USA
- Hybrid
May 03 -
Chief Information Officer (CIO)
- National Institute on Aging
- Bethesda, MD, USA
May 09 -
Senior IT Project Manager
- Pennsylvania Turnpike Commission
- Middletown, PA, United States
- Hybrid
May 09 -
Unified Technology Solutions Architect
- Pennsylvania Turnpike Commission
- Middletown, PA, United States
- Hybrid
May 16 -
DevOps Engineer III
- Security Risk Advisors
- Philadelphia, PA, USA
- Remote
May 01 -
Director of Health Informatics
- Pace University
- New York, NY, USA
May 01 -
AdaptiveWork Systems Engineer
- Pinkerton
- Seattle, WA, USA
May 03