Homeoffice ETL Developer bei Briljent, LLC

We are seeking a highly experienced Informatica Extract Transform Load (ETL) Developer to join our Enterprise Data Warehouse (EDW) team. This position is responsible for designing, developing, and maintaining scalable ETL processes using Informatica PowerCenter and Teradata, with a focus on supporting healthcare-related data systems. The ideal candidate will have a strong background in data integration, performance tuning, and data warehousing best practices, and will thrive in a fast-paced, collaborative environment.

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 both development and production ETL environments.
• Perform repository backups, recovery operations, and ongoing system maintenance.
• Develop and maintain mappings, mapplets, sessions, and workflows utilizing a wide range of Informatica transformations.
• Monitor and troubleshoot ETL jobs across development, testing, and production environments.
• Write and optimize complex SQL queries and Unix Shell scripts for data marts and data interfaces in Teradata.
• Collaborate with business and technical stakeholders to gather requirements and document technical solutions.
• Participate in unit, integration, and system testing to ensure high-quality deliverables.
• Provide technical mentoring and support to junior team members. 
• Communicate effectively with leadership, clients, and project teams regarding progress, risks, and deliverables.
• Stay current with emerging technologies to continuously improve ETL and data warehouse capabilities.

• 7+ years of experience with Informatica PowerCenter ETL development.
• 5+ years of experience writing and tuning complex SQL queries.
• 5+ years of experience with Teradata (v17+), including Fastload, TPT, and Multiload utilities.
• 5+ years of Informatica PowerCenter administration experience.
• 2+ years of Unix Shell scripting (Bash/Korn) experience.
• Strong communication, documentation, and collaboration skills.
• Bachelor’s or advanced degree in Computer Science, IT, Mathematics, or a related field.
• Excellent organizational and time management abilities.
   

Preferred Qualifications:

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

Physical Requirements & Environmental Conditions: 

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this position, the employee is regularly required to sit and use hands to handle, or feel objects, a keyboard and other office equipment. The employee frequently is required to sit in meetings for long periods of time. The employee will utilize technology tools such as a laptop computer for extended periods of time. The employee must be able to reach with hands and arms and talk or hear. Specific vision abilities required by this position include close vision, color vision, and the ability to adjust focus. The noise level in the work environment is usually moderate.

Briljent is a solutions-based company. Solutions come from creative ideas; ideas come from being creative with differences. Briljent believes diversity and inclusion are critical to the success of the company. Employment at Briljent is based on merit and professional qualifications. We do not discriminate against any employee or applicant because of race, creed, religion, gender, sexual orientation, gender identity/expression, national origin, disability, age, veteran status, marital status or any other basis protected by federal, state or local law, regulation or ordinance.