EDW Informatica ETL Developer jobs in United States
cer-icon
Apply on Employer Site
company-logo

DATAMAXIS, Inc ยท 1 month ago

EDW Informatica ETL Developer

positionUnited States
timeContract
remoteRemote
senioritySenior Level
date7+ years exp

DATAMAXIS is seeking a highly experienced Informatica Extract, Transform, Load (ETL) Developer to join their Enterprise Data Warehouse (EDW) team. This role is responsible for designing, developing, and maintaining robust ETL processes using Informatica PowerCenter and Teradata, with a focus on supporting healthcare-related data systems.

AnalyticsBig DataCloud Data ServicesInformation Technology
badNo H1BnoteU.S. Citizen Onlynote

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

Qualification

Informatica PowerCenterETL developmentSQL performance tuningTeradataUnix Shell scriptingData warehouse developmentData modelingCommunication skillsCollaboration skillsMentoring skillsOrganizational skillsTime management skills

Required

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 Enterprise Relational Database Management systems (Teradata, DB2, Oracle, or SQL Server)
5+ years of Informatica PowerCenter administration 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

5+ years of data warehouse development experience
5+ years of data modeling experience using ERWIN or similar tools
2+ years of Unix Shell (Bash/Korn) scripting experience
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
Residing in or within driving distance of Springfield, IL
U.S. Citizen or U.S. Permanent Resident

Company

DATAMAXIS, Inc

twittertwitter
company-logo
DATAMAXIS takes pride in delivering a wide range of business IT modernization, data analytics, and technology management services.
dateFounded in 2003
location
Wixom, Michigan, USA
people-size51-200 employees
web-link
https://datamaxis.net

Funding

Current Stage
Growth Stage
Company data provided by crunchbase