ETL Developer

Our Financial Services client is seeking a full time Informatica ETL Developer with Data Warehousing experience.. This position is hybrid onsite in Mid-town NYC 3 days a week in the office.

Role description:

The successful candidate will be a key member of the HR Technology team, responsible for developing and maintaining global HR applications with a primary focus on HR Analytics ecosystem. This role combines technical expertise with HR domain knowledge to deliver robust data solutions that enable advanced analytics and data science initiatives.

Key Responsibilities:

Manage and support HR business applications, including problem resolution and issue ownership

Design and develop ETL/ELT layer for HR data integration and ensure data quality and consistency

Provide architecture solutions for Data Modeling, Data Warehousing, and Data Governance

Develop and maintain data ingestion processes using Informatica, Python, and related technologies

Support data analytics and data science initiatives with optimized data structures and AI/ML tools

Manage vendor products and their integrations with internal/external applications

Gather requirements and translate functional needs into technical specifications

Perform QA testing and impact analysis across the BI ecosystem

Maintain system documentation and knowledge repositories

Provide technical guidance and manage stakeholder communications

Required Skills & Experience:

Bachelor's degree in computer science or engineering with 4+ years of delivery and maintenance work experience in the Data and Analytics space.

Strong hands-on experience with data management, data warehouse/data lake design, data modeling, ETL Tools, advanced SQL and Python programming.

Exposure to AI & ML technologies and experience tuning models and building LLM integrations.

Experience conducting Exploratory Data Analysis (EDA) to identify trends and patterns, report key metrics.

Extensive database development experience in MS SQL Server/ Oracle and SQL scripting.

Demonstrable working knowledge of tools in CI/CD pipeline primarily GitLab and Jenkins

Proficiency in using collaboration tools like Confluence, SharePoint, JIRA

Analytical skills to model business functions, processes and dataflow within or between systems.

Strong problem-solving skills to debug complex, time-critical production incidents.

Good interpersonal skills to engage with senior stakeholders in functional business units and IT teams.

Experience with Cloud Data Lake technologies such as Snowflake and knowledge of HR data model would be a plus.