ETL Developer

ETL Developer

22 Jun 2024
Pennsylvania, Swiftwater, 18370 Swiftwater USA

ETL Developer

Vacancy expired!

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

Job Details

  • ID
    JC15728110
  • State
  • City
  • Job type
    Contract
  • Salary
    Depends on Experience
  • Hiring Company
    Synapse Tech Services Inc
  • Date
    2021-06-18
  • Deadline
    2021-08-17
  • Category

Jocancy Online Job Portal by jobSearchi.