Job was saved successfully.
Job was removed from Saved Jobs.
Job Details
Deloitte
Informatica ETL Engineer and Database Developer
In this age of disruption, organizations need to navigate the future with confidence by tapping into the power of data analytics, robotics, and cognitive technologies such as Artificial Intelligence (AI). Our Strategy & Analytics portfolio helps clients leverage rigorous analytical capabilities and a pragmatic mindset to solve the most complex of problems. By joining our team, you will play a key role in helping to our clients uncover hidden relationships from vast troves of data and transforming the Government and Public Services marketplace.
Work you'll do
Deloitte's DOJ client teams are currently searching for experienced ETL developers to develop and enhance pipelines from various sources into a PostgreSQL Data Warehouse.
- Duties may include creation of new mappings/workflows through Informatica or PL/SQL
- Modification of existing mappings/workflows, performance tuning, trouble-shooting, and tool administration.
- Candidate must have ETL experience (Informatica is a plus), SQL experience, and an understanding of dimensional data models.
- Candidate must have the necessary experience to debug and troubleshoot production environment application issues and the ability to performance tune mappings.
The team
Deloitte's Government and Public Services (GPS) practice - our people, ideas, technology and outcomes-is designed for impact. Serving federal, state, & local government clients as well as public higher education institutions, our team of over 15,000+ professionals brings fresh perspective to help clients anticipate disruption, reimagine the possible, and fulfill their mission promise.
The GPS Analytics and Cognitive (A&C) offering is responsible for developing advanced analytics products and applying data visualization and statistical programming tools to enterprise data in order to advance and enable the key mission outcomes for our clients. Our team supports all phases of analytic work product development, from the identification of key business questions through data collection and ETL, and from performing analyses and using a wide range of statistical, machine learning, and applied mathematical techniques to delivery insights to decision-makers. Our practitioners give special attention to the interplay between data and the business processes that produce it and the decision-makers that consume insights.
Required
- 5+ years working knowledge of SQL and PostgreSQL warehousing
- 5+ years experience in ETL and PL/SQL
- 5+ years experience in data warehouse concepts and relational databases
- 5+ years experience in technical testing, implementation, and troubleshooting in production environments
- 2+ years experience working in data modeling
- 2+ years experience working in Informatica
- Ability to support a hybrid schedule with onsite needs in Downtown DC
- Top Secret Clearance - Current
#LI-BL2