Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+


Job Id : 14673

Jobtitle : SQL / ETL Developer

Location : Secaucus, NJ

Company Name : Phoenix Technology Partners, LLC

Industry : Information Technology

Salary : $23,000 - $150,000  PER YEAR

Job type : Fulltime

Posted on: 2020-06-29


Required Skills : Experience In Azure Or AWS Cloud Platform Is Highly Desired,Advanced SQL Coding Skills For Data Transformations

Benefits : No benefits are available


Job Description  :

 

Responsibilities:

 

  • Duties primarily involve performing ETL tasks but also include performing other information integration tasks: B2B and EAI.
  • Analyze, develop/enhance data integration jobs which include data cleansing, migration and transformation.
  • Translate functional requirements into ETL mapping documents.
  • Identify, recommend and implement ETL process improvements
  • Adapt standard methodology for ETL development and establish best practices.
  • Responsible for troubleshooting, debugging and creating unit tests for ETL jobs.
  • Develop stored procedures when needed.
  • Utilize tools/technologies such as Azure Logic Apps, Azure Data Factory, Azure functions and SSIS.
  • Work with DBAs and Data Architects to plan and implement best ETL strategies.
  • Develop Power BI reports/dashboards as needed to monitor and triage production issues.
  • Review, analyze, construct, and modify workflows and translation maps. These maps may be in XML, CSV, FF, EDI and/or other data formats.
  • Set up partner communications and develop specifications for translation maps.
  • Work with business systems analysts to create technical design specifications, gaining a sound understanding of business processes for related applications so that integration processes fulfill the end-user requirements.
  • Follow testing standards and execute unit, integration, and performance testing activities to ensure complete, timely, and accurate data.

 

Qualifications :

 

  • Bachelor’s degree is preferred but 5+ years of proven work experience in a development environment will be considered equivalent to education.
  • 3+ years of experience in designing, developing ETL processes.
  • * 3+ years of experience in design/development using programming languages such as C# or Node.JS.
  • Possess sound knowledge of data integration, strong experience with any ETL tools such as SSIS, Informatica, Talend, etc.
  • Advanced SQL coding skills for data transformations.
  • Prior experience in B2B/EAI domains is a huge plus.
  • Must be well organized and able to handle multiple projects simultaneously.
  • Self-starter who takes initiative and can work with minimal supervision.
  • Prior experience in logistics, transportation industries is desired
  • Experience in Azure or AWS cloud platform is highly desired.
  • Familiarity with Power BI is a plus.

Latest jobs for you

  • DevOps Engineer

    Computer Resource Solutions Chicago, IL

    Job Description: Deliver container-based solutions utilizing the Kubernetes orchestrator in ...

    View Job
  • AWS DevOps Engineer- Senior

    CGI Group, Inc. Lafayette , LS

    Job Description: Seeking an AWS DevOps Engineer with proven technical experience to join its ...

    View Job
  • AWS/JAVA DevOps Engineer II

    Russell Tobin & Associates Reston, VA

    Job Description: DevOps Engineer II will coordinate and manage the entrance of new hardware and ...

    View Job
  • CISCO Network Engineer

    Nam Info Inc New York City, NY

    Experience/Qualifications: Requires good knowledge of Cisco routers and switches. Requires ...

    View Job
  • Network Engineer (Cisco, NMT, VLAN)

    Net2Source Inc Kohler, WI

    Job Description: Support for Cisco Switches, Riverbed WAN Accelerators, F5 Load balancers ...

    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