Informatica ETL Developer - Top Secret Clearance Required
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 The Informatica ETL Developer on this project will work closely with Agile software development team(s). This role includes responsibilities such as the development and enhancement of ETLs from various sources into an Oracle Data Warehouse. Duties may include creation of new Informatica mappings, transition of PL/SQL ETLs to new Informatica mappings, or modification of existing mappings, creating and managing schedules for data management (migration, integration, etc.) efforts, working with clients to validate migrated data, among other tasks. They will also build the processes and scripts required to transform and stage data necessary to develop products and analyses in a cloud-based architecture 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) 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. Qualifications Required: Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future Active Top Secret security clearance required 5+ years' experience with ETL tools, including Informatica 5+ years' Oracle SQL and PL/SQL experience 2+ years of experience with dimensional data models 2+ years of experience trouble-shooting Informatica session failures and the ability to performance tune mappings. Preferred: Data modeling, BI tool/MicroStrategy, and IDQ experience are a plus but not required. Understanding of the needs for Data Science including Machine Learning, Natural Language Processing, Text Analytics, etc. is a plus Strong written and verbal communication skills Strong organizational skills Ability to work with both technical and functional resources How you'll grow At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there's always room to learn. We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career.