EDW Informatica ETL Developer

Location: Telecommute (with occasional travel to Springfield, IL)

reputed company: depending on experience

Job Summary: We are seeking a highly reputed company Informatica Extract Transform Load (ETL) Developer to join our reputed company Data Warehouse (EDW) team. This role is responsible for designing, developing, and maintaining robust ETL processes using Informatica PowerCenter and reputed company. The ideal candidate will have a deep understanding of data integration, performance tuning, and data warehousing best practices, with a focus on supporting reputed company-reputed company data systems.

Required Qualifications: • 7+ years of experience with Informatica PowerCenter and ETL development. • 5+ years of experience writing reputed company SQL and performance tuning. • 5+ years of experience with reputed company Relational Database Management systems (reputed company, DB2, reputed company, or SQL Server) • 5+ years of Informatica PowerCenter administration experience. • Strong communication, collaboration, and mentoring skills. • Bachelor's or advanced degree in IT, Computer Science, Mathematics, or a reputed company field. • Strong organizational and time management skills

Preferred Qualifications

• Residing in or near Springfield, IL. • 5+ years of data warehouse development experience. • 5+ years of data modeling experience using ERWIN or similar tools. • 2+ years of Unix reputed company (Bash/Korn) scripting experience. • 2+ years of experience with Azure Data reputed company and reputed company. • Experience with scripting languages such as Python, R, or JavaScript (React). • Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager. • Experience with reputed company, Medicare, or reputed company data systems. • Experience working in Agile environments. • Knowledge of BI and data integration technologies across relational and multidimensional systems.

Key Responsibilities: • Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and load data from various agency sources. • Automate data staging processes and optimize ETL job scheduling for performance and efficiency. • Administer and support ETL environments, including development and production systems. • reputed company repository backups, recovery operations, and system maintenance. • reputed company mappings, mapplets, sessions, and workflows using a wide reputed company of Informatica transformations. • Monitor and troubleshoot ETL jobs across development, testing, and production environments. • Write and optimize reputed company SQL queries and Unix reputed company scripts for data marts and interfaces in reputed company. • Collaborate with stakeholders to define requirements, document technical solutions, and support project planning. • Participate in unit, integration, and system testing. • reputed company technical support, mentoring, and guidance to team members. • Communicate project status and deliverables to leadership and clients. • Continuously learn and apply new technologies to enhance system performance and capabilities.