Lead Software Engineers

Experience RequiredBachelor's degree plus six (6) years or Master's degree plus four (4) years of related experience.Minimum Education RequiredBachelor's degree plus six (6) years or Master's degree plus four (4) years of related experience.Compensation$159,222.00 - $222,200.00 / YearlyHours Per Week40Number Of Positions10ShiftFirst Shift (Day)Job DescriptionADP Technology Services, Inc. seeks Lead Software Engineers at our Roseland, New Jersey location. 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.SALARY: $159,222 - $222,200 per year. Benefits listed at: jobs.adp.com/en/life-adp.JOB 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); and Troubleshooting and identifying root cause of data issues anywhere from initial data source to final data target and all steps in-between.QUALIFIED APPLICANTS: To apply for this position, please respond to requisition 276179 at http://jobs.adp.com. Alternatively, applicants may mail their resume to the following address referencing requisition 276179, 1 ADP Blvd. |MS 248| Roseland, NJ 07068.Place of WorkOn-siteRequisition ID276179Job TypeFull TimeApplication Linkhttp://jobs.adp.com