ETL Developer

Aegistech Inc.
New york city, NY
08 Feb 2025

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.
  • 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. HR domain experience is a plus.
  • 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.

Pay Range: Hourly Pay range: $80 - $90

If you'd like to learn more about this opportunity, please contact us directly at .
  • ID: #49075943
  • State: New York New york city 10001 New york city USA
  • City: New york city
  • Salary: USD TBD TBD
  • Job type: Contract
  • Showed: 2023-02-08
  • Deadline: 2023-04-08
  • Category: Et cetera