ETL Developer

Responsible for developing data integration processes to support Paychex data initiatives aimed at assuring accuracy and consistency of critical business data across Paychex systems such as Salesforce, Snowflake, and SQL databases. Requires depth and breadth of experience in data and database technologies including proficient SQL and software development.

• Develops an understanding of the assigned data environment through data profiling and analysis using enterprise data tools to assess quality and cleanliness of data. Identify opportunities to improve data quality.
• Using enterprise data platform and tools, develops batch and streaming integration jobs.
• Learns the source & destination platforms, and develops innovative ways to assure data quality is maintained & failures are monitored.
• Documents data integration and data quality results and requirements, proposed solutions, and code to provide traceability from requirements through code implementation. Develop data monitoring solutions based on defined data quality business rules.
• Consults with infrastructure and application architects to integrate solutions into the Paychex environment to ensure consistency with Paychex architecture and standards, along with Integration Best Practices.
• Works with capacity planning and performance testing groups to ensure that solutions perform to Service Level Agreements.

Requirement:

• Bachelor&aposs Degree in Computer related discipline or equivalent work experience
• 3 years of experience in Software engineering with a focus on data integration and data processing
• 3 years of experience in SQL development.
• 3 years of experience in SQL Server and Snowflake databases.
• 3 years of experience in cloud data integration tools.(Informatica Intelligent Cloud services experience preferred)
• 2 years of experience in cloud technologies.
• Experience with Salesforce preferred
• Experience with Scribe ETL tool, Zuora cloud billing platform, and C# development nice-to-have
• Strong verbal communication and listening skills.
• Demonstrates problem solving skills.
• Possesses flexibility to work in a fast paced, dynamic environment.