Analytics Engineer

• 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.

EDW Informatica ETL Developer

Associate Analytics Engineer