Extensively worked on Informatica to extract data from flat files and Oracle, and to load the data into the target database.Extensively worked on Mapplets, Reusable Transformations, and Worklets there by providing the flexibility to developers in next increments.Involved in writing views based on user and/or reporting requirements Involved in Design, develop and Test process for validation and conditioning data prior to loading into the EDW Created a generic email notification program in UNIX that sends the emails to the production support team if there are any duplicate records or error in load process.Managed and administered a Teradata Production and Development Systems Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit test. Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.Involved in Preparing Detailed design and technical documents from the functional specifications Prepared low level design documentation for implementing new data elements to EDW.Created Data Warehouse Data Modeling used by Erwin.Responsibilities: Involved in the Data warehouse Data modeling based on the client requirements.Looking for drafting your winning cover letter? See our sample ETL Developer Cover Letter. To be considered for this position, candidates are expected to depict an engineering degree in computer science or IT. Though the ETL developers should have a broad technical knowledge, it is also mandatory for these developers to highlight in the ETL Developer Resume the following skill sets – analytical mind, communication skills, a good knowledge of various coding language used in ETL process, a good grasp of SQL, JAVA, data warehouse architecture techniques, and technical problem skills. Other duties include – ensuring smooth workflow, designing the best ETL process and drafting database design in various forms like star and snowflake schemas. The job description entails the ETL developers to execute the following tasks – copying data, extracting data from business processes and loading them into the data warehouse, keeping the information up-to-date, taking responsibility of designing the data storage system, testing and troubleshooting before it goes live. ETL developers load data into the data warehousing environment for various businesses.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |