Purpose of Role/Organizational Unit: This is a senior position that requires 8+ years of data development. This organizational unit is responsible for managing architecture, development, and operational services delivery of the various elements of the big data and analytics management including Informatica ETL Jobs. In this capacity, this Senior Informatica ETL Developer role is responsible for implementing Informatica Services.
The following functions are the responsibility of the Senior Informatica ETL Developer within data management team. This individual will be responsible to design and develop ETL jobs, perform code reviews, enhance standards, performance tuning, code migrations from dev to QA and production.
• Has expertise in various Informatica suite of products: PowerCenter, Big Data Edition, PowerExhange(CDC), and Data Quality.
• Expertise on ETL performance tuning
• Design responsibility for Operational and Data Warehouse ETLs
• Oracle and SQL knowledge is must
• Experiences with various tools such as Informatica Data Quality and Profiler Tools are preferred, but PowerCenter is must.
Minimum of 8 years in Informatica tools and with focus in performance tuning
Experience with Informatica PowerCenter, Big Data Edition, PowerExchange (CDC), Informatica Data Quality (IDQ)
Creation of complex parallel loads and dependency creation using work flows
Data modeling and data mapping design experience
Experience in PL/SQL and conversion of PL/SQL into Informatica
Required – 8+ years’ experience in Informatica PowerCenter
Preferred - Informatica Big Data Edition, PowerExchange (CDC), Informatica Data Quality (IDQ) v10 or higher tools architecture and design
Preferred – 2+ years’ experience in data lake development including Cloudera
Preferred – 1+ years’ experience in reporting and analytics i.e. BusinessObjects, QlikView, Tableau
Bachelors Degree in Computer Science, Information Systems, or equivalent
PMC is a leading provider of quality, engineering, manufacturing, supply chain, operations productivity, and IT Staffing solutions. Our solutions help customers shorten product life cycles, increase quality and throughput, reduce lead time, and improve their return on capacity and technology investments (ROI). Please visit www.PMCorp.com to learn more.