What are the responsibilities and job description for the Informatica Developer with Admin Skills position at TMS, LLC?
We're seeking a skilled Informatica Developer with admin skills to design, develop, and optimize ETL processes, with additional responsibilities for minimal administrative tasks. The ideal candidate will have a strong background in Informatica PowerCenter, source-to-target mapping, and SQL.
Key Responsibilities:ETL Development (80%)
- Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter
- Perform source-to-target data mapping and ensure data transformation meets business requirements
- Develop and optimize complex SQL queries for data extraction, transformation, and loading
- Work with relational databases (Oracle, SQL Server, PostgreSQL) for efficient data processing
- Conduct data profiling, performance tuning, and troubleshooting of ETL processes
- Collaborate with business analysts, data architects, and stakeholders to understand data requirements
- Ensure data integrity, accuracy, and consistency across multiple data sources
Informatica Administration (20%)
- Perform basic Informatica administrative tasks (user management, security settings, performance monitoring)
- Assist in installation, configuration, and upgrades of Informatica components
- Monitor ETL job schedules, troubleshoot failures, and ensure system availability
- Maintain documentation for ETL processes and administrative configurations
Required Skills & Qualifications:
- 5 years of experience in Informatica PowerCenter development
- Strong experience in Source-to-Target (S2T) mapping and ETL workflows
- Expertise in SQL and database management (Oracle, SQL Server, PostgreSQL, or similar)
- Hands-on experience in ETL performance tuning and optimization
- Basic understanding of Informatica Administration tasks (user management, configurations, monitoring)
- Unix/Linux scripting knowledge is a plus
- Strong analytical and problem-solving skills
- Excellent communication and documentation skills
Job Type: Contract
Pay: From $48.00 per hour
Schedule:
- 8 hour shift
- Day shift
- Monday to Friday
Work Location: In person
Salary : $48
