Ignitec infuses industry standards and leading technology capabilities to solve complex problems and deliver value with increased quality and lower performance risks. Our solutions combine top technology personnel, the latest cutting-edge technology, and Agile approaches to bring innovative ideas to life. We do not seek to meet expectation, we continuously strive to exceed them.
We have received our MBE Certification from NMSDC as a certified Minority Small Business Enterprise. We take pride in the MBE certification and partner with organizations to meet their Minority (D&I) Small Business goals. We are also a certified Minority Business Enterprise by the USPAACC, which recently awarded Ignitec “The FAST 50 Asian American Business Award” in 2022. We are also DBE certified by the Virginia Department of SBSD.
Job Title: ETL Developer
Location: Washington D.C
US Citizen or US Person (Green card) eligible, no 3rd parties
Qualifications
- +3 years of ETL experience with Informatica PowerCenter development and related components technologies (ETL Designer, etc.)
- +3 years of experience in creating, maintaining, and optimizing stored procedures, functions, inllne SQL, and ETL processes
- Familiarity with Informatica performance tuning of sources, mappings, targets, and sessions
- Familiarity with Software Development Life Cycle, specifically Agile, and able to independently participate in each phase
- Experience working with Greenplum (PostgreSQL) and/or Oracle SQL/PLSQL
- Previous experience in monitoring, supporting, and resolving issues for applications with technologies such as Informatica, Greenplum, etc.
- Willing to work during Production maintenance hours & on call support
Responsibilities
- Perform SQL and PL/SQL development, including design and maintenance of back-end ETL processes utilizing Informatica workflow, custom PL/SQL and SQL scripts
- Build and maintain database schemas
- Install, configure, maintain and upgrade ETL software, repositories, and pipelines
- Develop and maintain code and shell Scripts in on-premises and cloud environments
- Maintain, optimize, and tune Oracle and DB2 database scripts
- Perform data mining and performance tuning for large-scale datasets
- Perform data extracts, data purges, or data fixes in accordance with internal procedures and policies
- Complete problem tickets, documenting bug fixes, design modifications, and changes based on customer requirements