We are redirecting you to the source. If you are not redirected in 3 seconds, please click here.

EDW Informatica ETL Developer (Remote - Illinois) at Jobgether. This position is posted by Jobgether on behalf of DATAMAXIS, Inc. We are currently looking for an EDW Informatica ETL Developer in Illinois (USA).. This role offers an opportunity to contribute to the design, development, and maintenance of enterprise-level data warehouse systems. The EDW Informatica ETL Developer will focus on creating robust, efficient, and scalable ETL processes that support healthcare-related data operations. This position requires expertise in Informatica PowerCenter, Teradata, and advanced SQL, while collaborating closely with cross-functional teams to ensure data integrity, system performance, and timely delivery. The role balances hands-on technical work with mentoring and knowledge sharing, helping the organization implement best practices in data integration, automation, and performance optimization.. Accountabilities. ·         Design, develop, and maintain ETL solutions using Informatica PowerCenter to extract, transform, and load data from multiple sources.. ·         Automate data staging processes and optimize ETL job scheduling for performance and efficiency.. ·         Administer and support ETL environments, including development, testing, and production systems.. ·         Develop mappings, mapplets, sessions, and workflows using Informatica transformations, ensuring data quality and consistency.. ·         Monitor, troubleshoot, and optimize ETL jobs, SQL queries, and Unix Shell scripts for data marts and interfaces.. ·         Collaborate with stakeholders to define requirements, document technical solutions, and support project planning.. ·         Provide mentoring, guidance, and technical support to team members while sharing best practices.. ·         Participate in unit, integration, and system testing to ensure deliverables meet quality and performance standards.. ·         7+ years of experience with Informatica PowerCenter and ETL development.. ·         5+ years of experience with complex SQL and performance tuning.. ·         5+ years of experience with enterprise RDBMS (Teradata, DB2, Oracle, or SQL Server).. ·         5+ years of Informatica PowerCenter administration experience.. ·         Bachelor’s or advanced degree in IT, Computer Science, Mathematics, or a related field.. ·         Strong communication, collaboration, mentoring, and organizational skills.. ·         Preferred: data warehouse development experience, data modeling (ERWIN or similar), Unix Shell scripting (Bash/Korn), Azure Data Factory, Snowflake, scripting languages (Python, R, JavaScript), Informatica Data Quality tools, and familiarity with healthcare data (Medicaid, Medicare).. ·         Experience working in Agile environments and knowledge of BI and data integration technologies across relational and multidimensional systems.. Company Location: United States.