EDW Informatica ETL Developer (Remote - Illinois)

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.

·         Competitive salary based on experience.

·         Telecommute opportunity with occasional travel to Springfield, IL.

·         Comprehensive healthcare, dental, and vision benefits.

·         Paid time off, holidays, and flexible work arrangements.

·         Opportunities for professional development, training, and mentoring.

·         Collaborative team environment with knowledge-sharing and technical growth.

Jobgether is a Talent Matching Platform that partners with companies worldwide to efficiently connect top talent with the right opportunities through AI-driven job matching.

When you apply, your profile goes through our AI-powered screening process designed to identify top talent efficiently and fairly.
🔍 Our AI evaluates your CV and LinkedIn profile thoroughly, analyzing your skills, experience, and achievements.
📊 It compares your profile to the job’s core requirements and past success factors to determine your match score.
🎯 Based on this analysis, we automatically shortlist the 3 candidates with the highest match to the role.
🧠 When necessary, our human team may perform an additional manual review to ensure no strong profile is missed.

The process is transparent, skills-based, and free of bias—focusing solely on your fit for the role. Once the shortlist is completed, we share it directly with the company managing the job opening. The final decision and next steps (such as interviews or additional assessments) are then made by their internal hiring team.

Thank you for your interest!

#LI-CL1