What are the responsibilities and job description for the ETL Developer (Clearance Required) (Remote) position at Yudrio, Inc?
ETL Developer
Location: Remote
Clearance Required: Active IRS MBI Clearance
Overview
Yudrio is seeking a highly skilled ETL Developer with extensive experience in Informatica PowerCenter development and related component technologies (e.g., ETL Designer). The ideal candidate will have a proven track record in building, maintaining, and optimizing ETL processes, stored procedures, functions, and inline SQL. This role requires strong performance tuning skills, familiarity with Agile methodologies, and the ability to work independently across all phases of the Software Development Life Cycle.
Key Responsibilities
- 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.
Required Qualifications
- 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.
Professional Skills
- 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).