Tech Stack
ETLGreenplumInformaticaOraclePostgresSDLCSQL
About the role
- Design, develop, and maintain ETL processes using Informatica PowerCenter and related tools.
- Create, optimize, and manage stored procedures, functions, and SQL scripts.
- Perform performance tuning for Informatica sources, mappings, targets, and sessions.
- Participate in all phases of the SDLC, with emphasis on Agile project environments.
- Work with Greenplum (PostgreSQL) and/or Oracle SQL/PLSQL for database development and optimization.
- Monitor, support, and resolve issues for applications leveraging technologies such as Informatica, Greenplum, and Mainframe systems.
- Provide support during production maintenance windows and participate in on-call rotations as needed.
Requirements
- Active IRS MBI Clearance (required for consideration).
- 7+ years of experience as a software developer with the specified technologies.
- 3+ years of experience using Rational Team Concert or equivalent tools.
- Demonstrated experience with Control-M (specific to ETL development).
- Hands-on experience with Greenplum or a similar database platform.
- Strong oral and written communication skills with the ability to engage stakeholders at all organizational and technical levels.
- Excellent time management skills and the ability to meet deadlines in a fast-paced environment.
- Proven ability to work effectively in a collaborative, high-performing team environment.
- Proficiency with Microsoft Office Suite (Word, PowerPoint, Excel, SharePoint).