My Shortlist

Your shortlisted jobs will appear here. To view your shortlist: Login Or Register

More Jobs Like This
Date Added: Sat 03/04/2021

ETL Developer

Swiftwater, PA, US
Add To Shortlist Apply Now


Job Type: Contract, FullTime

Urgent opening for our client. Job Title ETL Developer Location Swiftwater PA Duration Long-term W2 only Roles and Responsibilities The ETL Developer will be a member of the Data team to maintain and develop data integration solutions. The candidate will need to understand business and technical requirements and translate these into data integration designs and deliverables. The solutions must align with the client's ETL standards and guidelines. The data integration solutions will be based on Informatica with Oracle SQL data warehousesdatabases.The ETL Developer will be a key member of the data-focused durable team and must have a working knowledge of the Agile framework and methodologies (SCRUM, Kanban). Design and Develop ETL programs primarily using Informatica PowerCenter, PLSQL, Unix Shell Scripts. Extract, transform load into dimension model structures of EDW data marts Performance improvement tuning of Informatica mappings, SQL PLSQL scripts Technical reviews, Data validation end to end testing of ETL Objects, Source data analysis and data profiling. Create necessary documentation. Perform Unit Testing of ETL Programs and support QA on End-to-End testing Work with deployment team in the code migration across environments Triage Production issues and work on code fixes Requirements Minimum 5 years of experience in ETL Architecture and ETL products Minimum 3 years of experience with Informatica Developer Minimum 5 years of experience with Informatica Power Center Minimum 6-7 years of experience in implementation of BI projects in a large-scale enterprise data warehouse environment. Dimensional Modeling and Data warehouse, ODS concepts, such as star schemas, snowflakes and normalized data models Converting functional specifications into ETL technical specifications and source to target mappings Experienced in tuning of Informatica mappings, database scripts and procedures. Regards, Sam Mohd Sr Technical Recruiter ll Synapse Tech Services Inc. mailto ll #removed# http#removed# LinkediIn Url https#removed#-fasi-sam-744b6663 https#removed#-fasi-sam-744b6663 4449 Easton Way, Suite 200, Columbus, OH 43219
Apply Now