ETL (Informatica) Developer
Skills
- Informatica PowerCenter expertise
- Extensive ETL development experience
- Strong PL/SQL and Oracle development skills
- Proficient SQL and data modeling skills
- Experience with data lake concepts, HDFS, and Kafka
- Familiarity with RDBMS and NoSQL systems
- Knowledge of mainframe modernization and legacy data sources
- Software development lifecycle and version control experience
- Strong written and verbal communication
- Active IRS MBI clearance (required)
Responsibilities
- Design, develop, and test ETL mappings and workflows using Informatica PowerCenter following development standards and best practices.
- Partner with business analysts and end-users to gather and translate business requirements into technical specifications and data transformation logic.
- Define data models, data flow diagrams, and detailed transformation rules for structured and semi-structured data.
- Lead complex database design, implementation, administration, tuning, ETL, backup, and recovery activities for assigned projects.
- Analyze database schemas, triggers, and stored procedures and implement changes as required.
- Design, develop, implement, and maintain custom Oracle applications and PL/SQL code.
- Conduct code reviews and enforce code quality and testing standards.
- Work with data lake architectures and technologies (HDFS, Kafka) and integrate ETL with RDBMS and NoSQL systems.
- Develop and execute test plans, test scripts, and validation procedures; provide post-deployment support and issue remediation.
Education
- Bachelor's degree in Information Technology, Computer Science, or a related field (required)
Benefits
- Paid vacation and sick leave
- Health insurance coverage
- Career training and development
- Performance bonus programs
- 401(k) with employer match
- 11 federal holidays
- Equal Opportunity Employer and reasonable accommodations
Average salary estimate
If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.
IntusCare is hiring a Software Engineer II - Data to build reliable, scalable data pipelines and analytics that drive clinical and operational decisions for PACE programs.
Lithia & Driveway is hiring a remote Manager, Technical Data Analysis to lead a team ensuring data quality, lineage, and governance across modern data platforms.
QAD is hiring an FTZ/Global Trade Data Integration Specialist to design and implement SSIS/ETL data mappings that connect customs ABI and global trade systems with QAD's FTZ inventory and compliance software.
We modernize legacy infrastructure, secure mission-critical systems and design digital experiences that impact millions of federal workers and American citizens every day. Human-centered design is at the heart of everything we do, working side-by...
3 jobs
🔮
Hi, I'm Risa! Your AI Career Copilot
you, just ask me below!
Proudly made in NYC.
