ETL Developer - Informatica Powercenter

JOB TITLE: Senior Software EngineerJOB LOCATION: Remote but need to be open to travel to Albuquerque, NM during implementation WAGE RANGE*: $50hr to $55hr w2 JOB NUMBER: 26-01420 REQUIRED EXPERIENCE: Informatica PowerCenter 10.5.5 Design and maintain relational database models, schemas, tables, indexes, and views. Develop complex SQL queries, stored procedures, functions, and performance tuning solutions. Perform database optimization and data quality analysis for large healthcare datasets. Build ETL processes for Medicaid claims, provider, eligibility, and encounter data.JOB DESCRIPTION The Senior Software Engineer is responsible for designing, developing, implementing, and supporting enterprise data integration and reporting solutions for Medicaid Management Information Systems (MMIS/T-MMIS) and Federal Reporting programs. This role requires expertise in database design, SQL development, Informatica PowerCenter 10.5.5, ETL architecture, and CMS regulatory reporting.

• Design and maintain relational database models, schemas, tables, indexes, and views.
• Develop complex SQL queries, stored procedures, functions, and performance tuning solutions.
• Perform database optimization and data quality analysis for large healthcare datasets.
• Build ETL processes for Medicaid claims, provider, eligibility, and encounter data.
• Troubleshoot ETL failures, performance issues, and production incidents.
• Implement data validation, error handling, and audit controls.
• Investigate and resolve CMS reporting errors and DQ Atlas findings.
• Support audits, PERM reviews, and federal certification activities.

Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities * While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.#Dice