Vacancy expired!
VDart Inc is the leading global provider of digital solutions, products and talent management company providing digital technology solutions in Automotive, Manufacturing, Energy & Utilities and Healthcare Industries. Led by a strong global team located across 10 countries including USA, Canada, Mexico, Brazil, UK, Japan, Australia & India. We are currently accepting applications from staffing firms for our Preferred Partner Program, where we align niche staffing firms with specific verticals based on their strengths. To apply, please visit: https://www.vdart.com/suppliers/ Role: PowerCenter Developer Plano, TX Contract Technical Requirements:
- Experience with Informatica PowerCenter Development.
- Excellent skills in SQL and PL/SQL Stored procedures, packages and functions using Oracle and Postgres.
- Design, develop, validate and deploy the Informatica ETL processes using Informatica data integration and data quality tools
- Experience in creating SCD Types mappings and Datawarehouse concepts to build the Datawarehouse
- Must have ability to develop complex Informatica ETL mappings and workflows extracting data from various heterogeneous source systems like Flat files, XML, Oracle, Postgres, SAP Systems and Web services.
- Experience in preparing test scripts and test cases to validate data and maintaining data quality
- Using Informatica PowerCenter created mappings and mapplets defining the transformation logic according to the business rules for the loads.
- Experience in conversion of ETL mappings from Oracle to Postgres is plus.
- Experience in troubleshooting the performance issues.
- Excellent analysis, debugging and troubleshooting skills, performance tuning and problem solving required.
- 8+ years of experience in Informatica PowerCenter Development.
- Experience in PowerCenter code migration between different RDBMS is a plus.
- Experience in PostgreSQL SQL and Pl/PGSQL is a plus.
- 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.