1 jobs found

Job Description Job Description Remote : Informatica powercenter developer with Teradata exp. Most recent project must be Healthcare 10+ years and W2 role H1b transfer is fine H4 EAD,GC,USC Required Qualifications: • 7+ years of experience with Informatica PowerCenter and ETL development. • 5+ years of experience writing complex SQL and performance tuning. • 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 (Bash/Korn) scripting experience. • Strong communication, collaboration, and mentoring skills. • Bachelor's or advanced degree in IT, Computer Science, Mathematics, or a related 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 experience with Azure Data Factory and Snowflake. • Experience with scripting languages such as Python, R, or JavaScript (React). • Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager. • Experience with Medicaid, Medicare, or healthcare 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. • Perform repository backups, recovery operations, and system maintenance. • Develop mappings, mapplets, sessions, and workflows using 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 interfaces in Teradata. • Collaborate with stakeholders to define requirements, document technical solutions, and support project planning. • Participate in unit, integration, and system testing. • Provide 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.