Take2 Consulting, LLC · 5 days ago
Senior SQL/Informatica ETL Developer
Take2 Consulting, LLC is seeking a Senior SQL/Informatica ETL Developer to develop, design, and implement complex ETL solutions in a data warehouse environment. The role requires a seasoned developer to work onsite at the Hoover Building in Washington, DC, supporting mission-critical projects that require a Top Secret clearance.
ConsultingLegalManagement Consulting
Responsibilities
Gather, define, document, analyze, and implement SQL and Informatica ETL solutions
Design, code, test, schedule, and deploy ETL processes and data models
Develop, execute, and document unit test plans, test data, and results
Understand data warehouse concepts and model database structures, tables, and fields
Debug and troubleshoot production environment application issues
Communicate complex technical information effectively with all levels of management
Identify requirements and deliver results in a collaborative environment
Qualification
Required
Bachelor's degree
Top Secret clearance
Minimum of 5 years of experience with SQL data modeling and the latest versions
Strong development skills in PL/SQL, Informatica, and ETL/data integration
Extensive understanding of data warehouse architecture and relational databases
Ability to model database structures, tables, and fields
Proven experience in debugging and troubleshooting production issues
Excellent oral and written communication skills
Ability to gather requirements and deliver solutions effectively
Preferred
Relevant certifications in SQL, Informatica, or related fields
Ability to manipulate Informatica ETL for data analysis
Prior work experience with the Federal Bureau of Investigation