Responsibilities

• Design, develop, and implement ETL processes using Informatica, Java, and MongoDB.
• Collaborate with business analysts and data scientists to translate business requirements into technical specifications.
• Create and manage robust, scalable, and highly available database solutions.
• Perform data cleansing, transformation, and loading into data warehouses.
• Monitor and optimize the performance of ETL processes.
• Develop and implement data auditing strategies to ensure data quality.
• Troubleshoot and resolve ETL job failures and data discrepancies.
• Prepare documentation for ETL processes, including data models, data flow diagrams, and ETL job descriptions.
• Stay current with the latest technologies and best practices in data warehousing and ETL development.

Requirements

• Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
• 5+ years' Proven experience as an ETL developer, specifically with Informatica, Java, and MongoDB.
• Strong understanding of ETL principles and how to apply them within a data warehousing environment.
• 5+ years Experience with database programming and design, including mastery of complex SQL queries and stored procedures.
• Knowledge of data modeling and data warehousing concepts.
• Familiarity with data integration and enterprise integration patterns.
• Excellent problem-solving skills and attention to detail.
• Ability to work in a fast-paced, team-oriented environment.
• Strong communication and collaboration skills.
• 5+ years experience required
• Must be able to obtain and maintain Public Trust Clearance
• U.S. CITIZENSHIP REQUIRED to support our Federal clientNO EXCEPTIONS**

MUST be willing to consent to personal, employment, clearance and education verification. No Exceptions!