ETL/Informatica Developer / Analyst

Robotics Prcocess Automation, LLC; Jersey City (NJ); On-site; USD 110,000 - 160,000; Full time

Job summary

ROBOTIC PROCESS AUTOMATION LLC is seeking an experienced ETL specialist with deep Informatica PowerCenter and Teradata expertise for our Jersey City team.

The role requires strong SQL tuning, ETL administration, and excellent communication skills to mentor and collaborate with clients and internal teams.

Qualifications

• 7+ years of Informatica PowerCenter/ETL experience.
• 5+ years of complex SQL and performance tuning experience.
• 5+ years of Teradata Version 15+ experience with Teradata Utilities.
• 5+ years of ETL/Informatica PowerCenter administration experience.
• Excellent verbal/written communication, end-client facing, mentoring and team collaboration.
• Experience with Unix Shell scripting.
• Bachelor’s or advanced degree in related IT/CS/Math/Analytics fields.
• Adaptability to team and organizational culture.

Skills

Informatica PowerCenter

ETL

SQL performance tuning

Unix Shell scripting

Communication & mentoring

Team collaboration

Adaptability to culture

Education

Bachelor's or advanced degree in IT/CS/Math/Analytics

Tools

Teradata 15+

Teradata Utilities (Fastload, TPT, Multiload)

Azure Data Factory

Snowflake DB development

ERWIN

IDQ/Address Doctor/Metadata Manager

Korn and Bash Shell scripting

Python/R

Job description

Qualifications:

• 7+ years of Informatica PowerCenter / ETL Experience
• 5+ years of complex SQL and Performance Tuning Experience
• 5+ years of Teradata Version 15+ experience, including Teradata Utilities (Fastload, TPT, Multiload)
• 5+ years of ETL / Informatica PowerCenter administrative experience
• Excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills
• Experience with Unix Shell scripting
• Strong organizational skills and ability to set priorities and schedule work deadlines
• Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology
• Adapting to the team and organizational culture

Preferred Skills:

• 5+ years of Data Warehouse experience
• 5+ years logical and physical data modeling experience using ERWIN or other data modeling tool
• 2+ Years of Azure Data Factory and Snowflake DB development
• Experience in Windows, Unix/Linux scripting, R, React, or Python
• Experience in Informatica Data Quality (IDQ), Address Doctor, Metadata Manager
• Experience with Medicaid / Medicare / Healthcare applications
• Experience working in Agile
• Experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, relational and multi-dimensional database systems
• Experience with Korn and Bash Shell scripting

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.