Overview
Remote
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)
No Travel Required
Unable to Provide Sponsorship
Skills
Data Integrity
Analytical Skill
Cloud Computing
Collaboration
Communication
Conflict Resolution
Data Integration
Data Quality
Data Warehouse
Data-flow Diagrams
Database
Debugging
Dimensional Modeling
Informatica
Informatica PowerCenter
Insurance
Documentation
Extract, Transform, Load
Health Care
Leadership
Linux
Management
Mentorship
Problem Solving
Project Lifecycle Management
Project Management
Quality Assurance
Regulatory Compliance
Relational Databases
Requirements Analysis
Scripting
Standard Operating Procedure
Shell Scripting
Microsoft Azure
Workflow
Specification Gathering
PL/SQL
Performance Tuning
Soft Skills
Technical Writing
Unix
Technical Drafting
SQL
Job Details
ETL Informatica Lead
Remote
Primary responsibilities
- Team leadership: Manage, mentor, and provide technical guidance to a team of ETL developers throughout the project lifecycle.
- ETL design and development: Architect, design, and develop complex data integration processes using Informatica PowerCenter or Informatica Cloud (IDMC) to extract, transform, and load data from various sources into data warehouses.
- Requirement analysis: Work with business stakeholders, data architects, and analysts to understand business requirements and translate them into technical specifications for ETL solutions.
- Performance tuning: Troubleshoot, debug, and optimize ETL mappings, workflows, and SQL queries for maximum performance and efficiency.
- Quality assurance: Implement data quality rules, validation processes, and governance measures to ensure data integrity and compliance.
- Collaboration and communication: Collaborate with cross-functional teams and the client (Anthem) to ensure data solutions meet business needs and align with project timelines.
- Documentation: Create and maintain technical documentation, including data flow diagrams, technical design specifications, and standard operating procedures.
Required skills and qualifications
- Informatica Expertise: Extensive hands-on experience with Informatica PowerCenter or Informatica Cloud Data Integration (IICS/IDMC), including mappings, workflows, and taskflows.
- Data warehousing and databases: Strong understanding of data warehousing concepts, dimensional modeling, and deep expertise in SQL and relational databases (e.g., Oracle, SQL Server).
- Cloud experience: Familiarity with cloud data platforms such as AWS or Azure is often required, particularly for modern IDMC-based projects.
- Scripting: Proficiency in Unix/Linux shell scripting is common for automating and managing ETL jobs.
- Healthcare domain knowledge: Prior experience working in the insurance or healthcare domain is highly beneficial due to the client (Anthem).
- Soft skills: Excellent analytical, problem-solving, and communication skills are essential for both technical tasks and client interactions.
- Project management: Experience leading end-to-end data integration projects and managing resources
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.