Previous Job
Previous
ETL Developer
Ref No.: 18-31556
Location: Plano, Texas
Position Type:Full Time/Contract
Start Date: 05/08/2018
 Must have:
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..