Urgent opening for our client. Job Title: ETL Developer Location: Swiftwater PA Duration: Long-term W2 only Salary: $75k Per annum
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 warehouses/databases.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, PL/SQL, Unix Shell Scripts. Extract, transform & load into dimension model structures of EDW & data marts Performance improvement & tuning of Informatica mappings, SQL & PL/SQL 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 4 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 5 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. ll www.synapsetechservice.com LinkediIn Url;: https://www.linkedin.com/in/mohd-fasi-sam-744b6663/ 4449 Easton Way, Suite 200, Columbus, OH 43219