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.
WHAT YOU'LL DO: - 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.
- LearningYou'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.
- ChallengesInevitable challenges will arise, and we'll rely on you to look for a solution.
- Responsibilities. 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.
TO SUCCEED IN THIS ROLE:- Education and Qualifications/Skills and Competencies. 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.
- Work 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); and Troubleshooting and identifying root cause of data issues anywhere from initial data source to final data target and all steps in-between.
YOU'LL LOVE WORKING HERE BECAUSE YOU CAN:- Have courageous team collaboration. Courage comes from how associates are willing to have difficult conversations, speak up, be an owner, and challenge one another's ideas to find the best solution.
- Deliver at an epic scale. We deliver real user outcomes using strong judgment and good instincts. We're obsessed with the art of achieving simplicity with a focus on client happiness and productivity.
- Be surrounded by curious learners. We align ourselves with other smart people in an environment where we grow and elevate one another to the next level. We encourage our associates to listen, stay agile, and learn from mistakes.
- Act like an owner & doer. Mission-driven and committed to leading change, you will be encouraged to take on any challenge and solve complex problems. No tasks are beneath or too great for us. We are hands-on and willing to master our craft.
- Give back to others. Always do the right thing for our clients and our community and humbly give back to the community where we live and work. Support our associates in times of need through ADP's Philanthropic Foundation.
- Join a company committed to equality and equity. Our goal is to impact lasting change through our actions.
Benefits listed at: jobs.adp.com/en/life-adp
