ETL Informatica Developer

Synechron Inc.
Sterling, VA
Apr 17, 2018
Apr 18, 2018
Accountant, IT
Full Time
Responsibilities: Strong experience in design, development, implementation, administration troubleshooting and support of ETL process using Informatica Tuned performance of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval Motivated to take independent responsibilities Experience in designing, developing and implementing extraction, transformation and load techniques on multiple database platforms and operating system environments Involved in design, development and maintenance of database for data warehouses projects. Requirements: Designed the ETL process using Informatica tool Excellent experience in requirement gathering, Gap Analysis from both functional and technical perspectives Worked on performance tuning, identifying and resolving performance bottlenecks on various levels like sources, targets, mapping Experience as an architect in mapping designer and transformation developer Developed all mapping, session and workflows according to the design need Should have good expertise in MS SQL Server 2012/2008R2/2008/2005/2000, SSIS, SSRS and SSAS DBA experience, managing, monitoring and troubleshooting SQL Server instances Extensive experience in implementation of data cleanup procedure, transformations, scripts and execution of test plan for loading the data successfully into the target Proficient in data quality management and data quality check methodology Excellent analytical and programming skills Good communication and organizational abilities

Similar jobs