ETL _ Informatica Lead

• Job Title: ETL _ Informatica Lead
• Location: Addison, TX/Plano, TX
• Job Type: Permanent Hire
• Salary Range: $120K with benefits

• Job Description
• :Must Have Technical/Functional Skill

• s
• Primary Skill: ETL Informatica Powercentre/ID
• MCSecondary: Unix, Autosys, Orac
• leExperience: Minimum 15 yea

• rs
• Roles & Responsibilit
• iesBachelor’s or master’s degree in computer science or related fie
• ld.ETL Informatica Lead to lead the design, development, and deployment of enterprise-scale data integration solutio
• ns.The ideal candidate will have strong hands-on expertise with Informatica PowerCenter, 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 suppo

• rt.
• Key Responsibili
• tiesLeadership & Deli
• veryLead end-to-end ETL solution delivery, including requirement analysis, design, development, deployment, and supp
• ort.Serve as the technical lead for Informatica initiatives and mentor ETL develop
• ers.Coordinate with business analysts, architects, DBAs, and cross-functional te
• ams.Perform design and code reviews to ensure best practices and standards are follo

• wed.
• Requirements & De
• sign Collaborate with business and analytics teams to understand data requirements and source-to-target mapp
• ings.Design scalable, high-performance ETL architectures and workf
• lows.Define error handling, logging, reconciliation, and audit mechan
• isms.Prepare and review technical design documents and mapping specificat

• ions.
• Develo
• pment Develop and optimize ETL mappings, workflows, and sessions using Informatica PowerCenter and
• IDMC.Implement complex transformations, lookups, aggregations, and incremental
• loads.Tune ETL processes for performance and scalab
• ility.Develop Unix shell scripts for automation, monitoring, and file han

• dling.
• Scheduling & Auto
• mation Manage and support job scheduling using A
• utosys.Design restartable, dependency-driven wor
• kflows.Ensure SLA adherence and proactive failure ha

• ndling.
• Database & Perf
• ormance Strong interaction with Oracle databases for data modeling, SQL tuning, and performance optim
• ization.Analyze execution plans and improve SQL and ETL eff

• iciency.
• Deployment &
• Support Support ETL deployments across DEV, QA, UAT, and PROD envi
• ronments.Participate in release planning, production cutovers, and post-deployment va
• lidation.Provide L2/L3 production support, including root cause analysis and issue re

solution.