ETL Informatica Developer

Company: Robert Half
Location: Saint Paul
Posted on: November 21, 2020

Job Description:

Description Our client in the East Metro is looking to bring in an additional mid to senior level ETL Database Developer with 5 years of Informatica Power Center and SQL experience to help support the existing workflow and make enhancements when necessary. Position Summary The ETL Software Developer will serve as a member of the Data Warehouse team supporting the business and Data Warehousing projects. RolesResponsibilities Serve as a subject matter expert for the Enterprise Data warehouse. Perform data analysis activities to ensure comprehensive understanding of data sourced into the EDW. Define and maintain Data Warehouse Extract, Transformation Load (ETL) architecture to ensure data is available to support data related business needs. Development and Maintenance of Enterprise Data Warehousing business solutions. Perform data discovery and analysis activities to ensure detailed understanding of source data and how it can be related to other data sources. Design and develop data flows and data interactions in support business requirements. Collaborate with System Administrators to ensure computing resources are configured and optimized to support the EDW databases and ETL Architecture. Collaborate with the Business Intelligence Developer to ensure data base designs can be optimized in the Cognos Framework Model. Ensure existing data flows operate efficiently over time. Job Duties bullWork with IT Business Analyst define data business requirements. bullConduct data discovery and data analysis activities. bullScope, design and develop Informatica data warehousing solutions as prioritized by the Data Warehousing and Business Intelligence Manager. bullPerform system testing to validate EDW data structures and ETL solutions accurately support business requirements. bullEnsure data load processes remain efficient over time. bullTroubleshoot and maintain all data warehouse load processes. bullDetermine SQL Server Indexing strategies to ensure optimal performance. For Immediate consideration please send your resume to Lynn Skauge at Requirements Qualifications 10 years Information Technology work experience. 5 years Data Warehouse development experience. Required Skills Informatica Power Center experience is required for this role. SQL experience is required. Previous experience supporting existing workflow and making enhancements. Nice to Have Power Center Cloud experience is a plus. Robert Half Technology matches IT professionals with some of the best companies on a temporary, project or full-time basis. From roles in software and applications to IT infrastructure and operations, we provide you unparalleled access to exciting career opportunities. Our personalized approach, innovative matching technology and global network with local market expertise help you find the technology jobs that match your skills and priorities - fast. By working with us, you have access to challenging opportunities, competitive compensation and benefits, and training to enhance your skill sets. From philanthropy to environmental stewardship to employee programs, Robert Half is proud to have an active role in the communities in which we live and work. Our company has appeared on FORTUNE's "Most Admired Companies" list every year since 1998. Download our mobile app to take your job search on the go Contact your local Robert Half Technology office ator visit www.roberthalf.comjobstechnology to apply for this job now or find out more about other job opportunities. All applicants applying for U.S. job openings must be authorized to work in the United States. All applicants applying for Canadian job openings must be authorized to work in Canada. 2020 Robert Half Technology. An Equal Opportunity Employer MFDisabilityVeterans. By clicking 'Apply Now' you are agreeing to Robert Half Terms of Use httpswww.roberthalf.comterms-of-use .

Keywords: Robert Half, St. Paul , ETL Informatica Developer, Other , Saint Paul, Minnesota