ETL _ Informatica Lead

Primary Skills

ETL Informatica Power centre/IDMC

Unix, Autosys, Oracle

Minimum 15 years

Bachelor’s or master’s degree in computer science or related field.

ETL Informatica Lead to lead the design, development, and deployment of enterprise-scale data integration solutions. The ideal candidate will have strong hands‑on expertise with Informatica Power Center, Informatica Intelligent Data Management Cloud (IDMC), Unix, Autosys, and Oracle, and will play a key role in requirements analysis, technical design, development, testing, deployment, and production support.

• Lead end‑to‑end ETL solution delivery, including requirement analysis, design, development, deployment, and support.
• Serve as the technical lead for Informatica initiatives and mentor ETL developers.
• Coordinate with business analysts, architects, DBAs, and cross‑functional teams.
• Perform design and code reviews to ensure best practices and standards are followed.
• Collaborate with business and analytics teams to understand data requirements and source‑to‑target mappings.
• Design scalable, high‑performance ETL architectures and workflows.
• Define error handling, logging, reconciliation, and audit mechanisms.
• Prepare and review technical design documents and mapping specifications.
• Develop and optimize ETL mappings, workflows, and sessions using Informatica Power Center and IDMC.
• Implement complex transformations, lookups, aggregations, and incremental loads.
• Tune ETL processes for performance and scalability.
• Develop Unix shell scripts for automation, monitoring, and file handling.
• Manage and support job scheduling using Autosys.
• Ensure SLA adherence and proactive failure handling.
• Strong interaction with Oracle databases for data modeling, SQL tuning, and performance optimization.
• Analyze execution plans and improve SQL and ETL efficiency.
• Support ETL deployments across DEV, QA, UAT, and PROD environments.
• Participate in release planning, production cutovers, and post‑deployment validation.
• Provide L2/L3 production support, including root cause analysis and issue resolution.

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage:
  Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support:
  Maternal & Parental Leaves.
• Insurance Options:
  Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth:
  Commuter Benefits & Certification & Training Reimbursement.
• Legal & Financial Assistance:
  Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range: $100,000 - $120,000 a year

Addison, TX

Qualifications:

BACHELOR OF COMPUTER SCIENCE