Senior Informatica Developer at Lifion by ADP

| Greater NYC Area
Sorry, this job was removed at 12:57 p.m. (EST) on Saturday, February 6, 2021
Find out who's hiring in NYC.
See all Developer + Engineer jobs in NYC

Position Summary:

We are looking for a candidate who can join our talented team and make an impact in the areas of data integration and virtualization. The candidate will deliver solutions that will enable business users to use data to drive desired business outcomes. The candidate will work with technologies and tools such as Informatica, Denodo, Python, Oracle, Tableau and AWS. The ideal candidate will have a passion for data, be inquisitive and repeatedly ask why, enjoy interacting with others, not be afraid to fail or ask for help and want to be part of a highly performing agile team.

 

Responsibilities:

  • Engineer and deliver end to and data solutions to meet a wide range of business requirements using Informatica PowerCenter and Denodo
  • Administer, troubleshoot and provide developer support for the Informatica PowerCenter and Denodo environments
  • Develop LINUX and Python scripts to enhance Informatica's ETL capabilities and shortcomings
  • Work with business users to acquire and analyze data to meet their business needs
  • Investigate data issues by tracing data flows from source to target systems and writing SQL
  • Performance tune ETL workflows, scripts and SQL written by other team members and business users
  • Support weekly and monthly data load processes, investigate and bring issues to resolution
  • Be an active member of our Agile team and processes, participating in all ceremonies and continuous improvement activities
  • Embrace learning, innovation and disruption in a continually changing world where new technologies and techniques are introduced on a continual basis

Qualifications:

  • 5 years of experience creating Informatica workflows and associated components
  • 3 years of experience creating tables and views in an Oracle database
  • 3 years of experience writing and tuning complex SQL queries
  • 2 years of experience in designing data models (star and snowflake schemas)
  • 2 years of experience in writing LINUX shell scripts
  • In depth understanding of data warehousing, ETL concept, data loading strategies, data archiving, and ETL error handling
  • Ability to work independently as well as on a team
  • Pays attention to detail, is value and results oriented and driven
  • Always gives 110% no matter what the task, takes pride in their work
  • Good communication skills, can convey a message, make a point and most importantly listen
  • Experience writing Python scripts, using Denodo, TOAD, Tableau or Tableau Data Prep a plus
  • Prior application administration experience a plus
  • Basic knowledge of how Finance, Sales and HR organizations work a plus
  • 4 year Bachelor's degree in Engineering/Computer Science/Math

 

#LITECH
 

 

We're designing a better way to work, so you can achieve what you're working for. Consistently named one of the 'Most Admired Companies' by FORTUNE® Magazine, and recognized by DiversityInc® as one of the 'Top 50 Companies for Diversity,' ADP works with more than 740,000 organizations across the globe to help their people work smarter, embrace new challenges, and unleash their talent. "Always Designing for People" means we're creating platforms that will transform how great work gets done, so together we can unlock a world of opportunity.

At ADP, we believe that diversity fuels innovation. ADP is committed to equal employment opportunities regardless of race, color, genetic information, creed, religion, sex, sexual orientation, gender identity, lawful alien status, national origin, age, marital status, or protected veteran status. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.

Read Full Job Description

Technology we use

  • Engineering
  • Product
    • GolangLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • ReactLibraries
    • ReduxLibraries
    • Node.jsFrameworks
    • TensorFlowFrameworks
    • MySQLDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • JIRAManagement

Location

Our office is a converted loft space in Chelsea steps away from shopping, galleries, coffee, and great food (that is, if you want to skip free lunch).

An Insider's view of Lifion by ADP

What are some social events your company does?

There are lots of events constantly going on at Lifion! From meetups to tech talks to our weekly Thursday happy hours, there's a good mix of work and play. We also do outings: in my one year of working here we’ve done laser tag, Barcade, happy hour on a boat, the vessel, a picnic in central park, escape the room, VR world, and more.

Kelsey

Application Developer

What's the biggest problem your team is solving?

The People Ops Team is in full swing for FY19 Performance Reviews. It's an exciting time for the business, but requires a lot of backend work & support for our associates. We're drafting communications and timelines for management & associates, and creating the right process to gather ratings and self-assessments for a great associate experience.

Quinton

Director, People Operations

How has your career grown since starting at the company?

I have been able to work with many different teams since I started here and have grown tremendously. I have worked with new product teams, Reliability teams and now work with Security and Compliance teams. This experience has enriched my technical and product knowledge, and I get to be part of the teams which are solving complex business problems.

Gargi

Technical Program Manager

How do you empower your team to be more creative?

Creativity is best fueled by collaboration, and has two simple ingredients: First, you hire passionate & talented people, people who care about users and who want to solve meaningful complex problems. Then, you support a culture of openness, with every designer constantly sharing their best ideas across the whole org. That's how creativity thrives!

Chris

Head of UX

What makes someone successful on your team?

Success on our team is enjoying ownership over our work while staying open to suggestions. We have an open-door policy to share knowledge with one another, strengthening us individually and as a team. We check our egos at the door and are lucky enough to be surrounded by people who feel like family more than coworkers.

Sam

Software Engineer

What are Lifion by ADP Perks + Benefits

Culture
Friends outside of work
Eat lunch together
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Diversity manifesto
Someone's primary function is managing the company’s diversity and inclusion initiatives
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Employee Stock Purchase Plan
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Child Care Benefits
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Free Daily Meals
Stocked Kitchen
Happy Hours
Fitness Subsidies
Professional Development Benefits
Tuition Reimbursement
Lunch and learns
Promote from within
Mentorship program
Continuing Education stipend
Online course subscriptions available
More Jobs at Lifion by ADP53 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Internships
Operations
Product
Project Mgmt
Developer
new
New York
Data + Analytics
new
New York
Operations
new
New York
Operations
new
New York
Developer
new
New York
Data + Analytics
new
New York
Developer
new
New York
Data + Analytics
new
New York
Developer
new
New York
Developer
new
New York
Design + UX
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Project Mgmt
new
New York
Data + Analytics
new
New York
Developer
new
New York
Product
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Data + Analytics
new
New York
Project Mgmt
new
New York
Data + Analytics
new
New York
Product
new
New York
Operations
new
North Jersey
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York