ETL Developer
Chicago, IL (Onsite 3 days/week)
Full-time
Job Description:
- Minimum of 5+ years with Informatica Power Center 10.x and IDMC designing, developing, testing, and debugging.
- Minimum of 5+ years of development experience in Oracle, Oracle Exadata, SQL Server, or another industry accepted database platform.
- Minimum of 3+ years in Data Warehouse / Data Mart / Business Intelligence delivery.
- Minimum of 2+ years of Linux / shell scripting complementary with Informatica.
- Minimum of 2+ years of experience in job scheduling using AutoSys or another industry accepted scheduling tool.
- Domain knowledge within Community Reinvestment Act.
- Responsible for coordination of onshore and offshore development to assist in build efforts, including meeting with the team on a daily basis to discuss ongoing work.
- Accountable for on-time delivery of all documentation, design, build, testing, and deployment.
- Responsible for reviewing and understanding requirements and translating them into high-level and low-level documentation including source to target mappings.
- Responsible for development of data mappings, sessions, and workflows to meet requirements (Informatica 10.x or above).
- Responsible for development of job schedules that integrate with upstream and downstream systems (AutoSys jobs).
- Responsible for unit testing, debugging, and performance testing, with key focus on data accuracy and integrity.
- Work with the production support teams as needed to support production activities, including production migrations, L3 support, continuity testing, and environment migration activities.
- Must have impeccable written and oral communication skills down to the mapping documentation level.
