Description:
Job Title: PowerCenter ETL Lead Architect
Technical Requirements:
o Experience with Informatica BDM/BDQ/EDC/AXON product architecture and installing, configuring, and administering the product.
o Experience applying Hotfixes/EBFs to Informatica Big Data platforms and Power Center.
o Experience in troubleshooting the performance issues.
o Excellent analysis, debugging and troubleshooting skills, performance tuning and problem solving required.
o Excellent skills in SQL and PL/SQL Stored procedures, packages and functions using Oracle and Postgres.
o Design, develop, validate and deploy the Informatica ETL processes using Informatica data integration and data quality tools
o Experience in creating SCD Types mappings and Datawarehouse concepts to build the Datawarehouse
o Must have ability to develop complex Informatica ETL mappings and workflows extracting data from various heterogeneous source systems like Flat files, XML, Oracle, SQL Server, Postgres, SAP Systems and Web services.
o Experience in preparing test scripts and test cases to validate data and maintaining data quality
o Using Informatica PowerCenter created mappings and mapplets defining the transformation logic according to the business rules for the loads.
o Experience in conversion of ETL mappings from Oracle to Postgres is plus.
Qualifications:
14+ years of experience in Informatica PowerCenter Development and Administration skills.
Experience in leading the ETL team and Faceoff to the customer.
Excellent communication, team management and driving technical solutions
Good analytical and problem-solving skills for design, creation and testing of programs.
Good communication skills to interact with client, team members, support personnel, and provide technical guidance and expertise to customers and management.
Good interpersonal skills to interact with customers and team members.
Ability to work in a self-directed work environment.
,
Shaik Dadapeer
National Systems America L.P.
5945 Dallas Pkwy, Plano, TX 75093
Desk