ETL Developer
Previous Job
Previous
ETL Developer
Ref No.: 18-31799
Location: Plano, Texas
Position Type:Full Time/Contract
Start Date: 05/08/2018
 
Must have skills
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Strong experience in ETL using Informatica Power Center
• Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 5.x/6.x/7.x/8.x.
• Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages
• Create data migration/system integration strategies
• Experience in  Service mgmt. processes
• Experience in working in Onsite-Offshore support model
• Meeting with business and coordinate with teams to support operations systems in support of core enterprise functions