Job Details

ID #46135940
State New York
City New york city
Job type Contract
Salary USD TBD TBD
Source Aegistech Inc.
Showed 2022-10-01
Date 2022-09-30
Deadline 2022-11-28
Category Et cetera
Create resume

ETL Developer

New York, New york city, 10001 New york city USA

Vacancy expired!

Job Description:

A Business Intelligence Developer Consulting job in

New York City is available through Aegistech for a

Hybrid work module. You have at least 8 years of overall IT experience and are hands on using StreamSets & Informatica in an HR domain to qualify. The client is a Global Investment Bank, and the role lives in their HR Technology team. You will be performing high level and detailed analysis, defining and building pipelines using StreamSets and Informatica, writing scripts within Snowflake and MS SQL databases.

Business Intelligence Developer Job Responsibilities include:
  • Hands-on with a full Business Intelligence stack u sing StreamSets and Informatica in an HR Domain.
  • Development of queries and transformations with SQL, build pipelines within StreamSets, Informatica and scripts, preferably within Snowflake.
  • Database performance tuning.
  • Lead team members to enhance their ETL skills and for support transition. Standardizing team on Best Practices around StreamSets/Informatica /Snowflake driven implementations.
  • Perform and document data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in data warehouses.
  • Participate in Fit/Gap analysis, data migration activities and designing integrations with internal/ external systems.
  • Document as-is/to-be process flows, system configurations and technical/ functional design specifications.
  • Provide expert advice and design inputs in the areas of Data Modelling, Data Warehousing, Data Marts, Data Governance, and Security.

QUALIFICATIONS:
  • 8+ years overall experience with 3+ years working in an HR domain.
  • 5+ years of data modeling, including relational MS SQL, Star (OBI) and Snowflake schemas.
  • 3+ years with semantic layer design and StreamSets & Informatica development.
  • Solid SQL, relational databases, and normalization.
  • Query and reporting analysis tools.
  • Resolving data or performance issues related to workbooks and data sources
  • Bachelor's degree in computer science or engineering

DESIRED:
  • HR ERP systems such as PeopleSoft HR, SAP SuccessFactors.
  • Developing, maintaining and managing OBIEE/Tableau driven dashboards & analytics.
  • Data Quality Management & Data Governance.

Vacancy expired!

Subscribe Report job