Get your dream job within 2 days (HURRY UP)ENROLL NOW
+


Job Id : 5233

Jobtitle : ETL Developer

Location : United, PA

Company Name : Synapse Tech Services Inc

Industry : Information Technology

Salary : $67,000 - $92,000  YEAR

Job type : Contractor

Posted on: 2019-10-09


Required Skills : PowerCenter, Power BI, ODS, ETL, Informatica, SQL. SQL Scripts

Benefits : No benefits are available


Job Description/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 MS SQL data warehouses/database plus some SSIS solutions are in place too. 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, T-SQL, Unix Shell Scripts; however, some SSIS work will be necessary too.
  • Extract, transform & load into dimension model structures of EDW & data marts
  • Performance improvement & tuning of Informatica mappings, SQL, T-SQL & PL/SQL scripts
  • Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.
  • Create necessary documentation
  • Update the project documentation (Change Requests and JIRA s)
  • Upload the code to version control tool
  • 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 or PowerBI
  • Minimum 6-7 years of experience in implementation of BI projects in a large-scale enterprise data warehouse environment
  • Minimum 3 years of experience with SSIS
  • 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.

 

Recommended jobs for you

  • Java ETL Developer

    Unicorn Technologies, LLC Owings Mills, MD

    TOP SKILLS / EXPERIENCE: 5 years of experience in Java

    View Job
  • java ETL Developer

    Unicorn Technologies, LLC Owings Mills, MD

    Java ETL Developer Location: Owings Mills MD

    View Job
  • Java ETL Developer

    Unicorn Technologies, LLC Owings Mills, MD

    Java ETL Developer Location: Owings Mills MD

    View Job
  • Java ETL Developer

    Unicorn Technologies, LLC Owings Mills MD

    Java ETL Developer Location: Owings Mills MD

    View Job
  • Java ETL Developer

    Unicorn Technologies, LLC Owings Mills MD

    Java ETL Developer Location: Owings Mills MD

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First