Lead Software Engineer

ADP•Roseland, NJ

3d•Onsite

About The Position

ADP Technology Services, Inc. is hiring Lead Software Engineers in our Roseland, New Jersey location. This role is for individuals who are empathetic to client needs and inspired by transformation and impacting the lives of millions of people every day. The ideal candidate will join a dynamic, inclusive team environment with a culture of collaboration and belonging. To thrive in this career, you’ll need to be enthusiastic, eager to learn, and take on stretch assignments. You strive to learn new technologies and find ways to incorporate what you learn into building your results. You’ll be curious, persistent, and at times persuasive. As part of our team, you’ll find exciting challenges, get opportunities to grow your career, and develop solid friendships as we design what’s next for ADP and the industry. Pace should not scare you. We still find time for a healthy dose of fun.

Requirements

Bachelor's degree in Computer Science, Computer Engineering, Information Systems, related Engineering disciplines, or related field of study plus six (6) years of related experience required. The company will also accept a Master's degree and four (4) years of related experience.
Three (3) years of experience must include: Designing and developing ETL Pipelines, Data flows and Control flows using Python, Informatica IDMC, Informatica PowerCenter and associated components
Creating data quality solutions for customer matching and de-duplication processes using Informatica Data Quality (IDQ) and Address Doctor tools
Administering Informatica, IDMC and Denodo data virtualization environments
Writing and tuning complex SQL queries using Oracle and SQL Server databases
Creating logical and physical data models to satisfy business requirements using industry standard techniques such as dimensional and hierarchical modeling and star schemas
Writing Python and UNIX shell scripts to automate manual processes such as data validation, administrative tasks, and other functionality not provided by Informatica
Working with Salesforce data and understanding it’s nuances, Salesforce APIs including bulk APIs, and Salesforce Change Data Capture (CDC)
Troubleshooting and identifying root cause of data issues anywhere from initial data source to final data target and all steps in-between.

Responsibilities

Build Teams that thrive. As an experienced leader, you want everyone to shine. You are constantly looking for ways to share your knowledge, motivate others, and keep everyone engaged and productive.
Learning. You’re always learning new technologies and processes with tools and other training courses, conferences ADP offers, and operating with a “learn as you go” approach with a willingness to figure out new ways of doing things.
Create Results. You’re proactive and hands-on. When you see a potential issue, you never leave things hanging and unfinished. When you and your team deliver a finished product, it’s as polished as you could make it.
Continuous Learning. You will actively collaborate with other associates to share ideas or show what you’ve learned. You are eager to learn, keep up with ever-changing technologies, and maintain the ability to create the best tools for our clients.
Variety of work. There is no typical day. You could be checking in with a team in India one minute, meeting with leadership to review initiatives for the coming quarter later and tomorrow handling a few ad hoc requests from your peers in other departments.
Influence and inspire confidence. You are comfortable presenting to senior leaders, product owners, and peers with a compelling voice that you demonstrate through executive presence, leading change, and creating clear executive-level communications on milestone achievements.
Challenges. Inevitable challenges will arise, and we’ll rely on you to look for a solution.
Responsible for engineering and delivering end-to-end data solutions to meet a wide range of business requirements using IDMC, Databricks and Denodo.
Analyze large data sets, profile the data, and identify strengths and weaknesses of data including any human errors.
Design, build, and maintain reliable, scalable ETL pipelines to transform raw data into a meaning format suitable for analysis.
Administer, troubleshoot and be the primary person for our IDMC and Address Doctor environments as well as our Denodo data virtualization environments.
Create necessary automations to replace any recurring manual tasks and activities.
Develop LINUX and Python scripts to enhance IDMC 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.
Support weekly and monthly data load processes.
Be an active member of our Agile team and process, 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.