Role name: ETL Data Engineer
Work Location: Columbus, Ohio
Start date: Immediate availability.
Background check MANDATORY
Job Type: Contract (C2C/W2)
Interview: Phone/Video
Role and responsibilities:
Join a team delivering high-quality ETL and data-integration solutions to support Process Intelligence initiatives. You will design, develop, and maintain ETL pipelines and data models that feed process-mining platforms. Celonis and Celonis Platform Administration knowledge is optional — candidates with strong SQL/PL-SQL, ETL, data modeling and integration skills are encouraged to apply.
Responsibilities:
•Lead design, development, and implementation of ETL processes and data models to integrate source data into a Process Intelligence platform (e.g., Celonis).
•Participate in analysis sessions and work with data analysts to document data mappings and ETL requirements.
•Build reliable, secure connections to source systems (JDBC, Kafka, APIs) and validate data ingestion.
•Implement and optimize ETL pipelines for performance, scalability, and data integrity.
•Design and implement audits and reconciliation processes to ensure data completeness and correctness from application platforms to the process-mining environment.
•Provide operational support for production ETL jobs; troubleshoot failures and performance issues.
•Define and enforce governance, access control, and best practices for process data and ETL artifacts.
•Collaborate with business, PM, BA, and infrastructure teams to enable continuous improvement and automation opportunities.
•Support Agile delivery (Scrum/Kanban) and contribute to planning, estimation, and delivery activities.
All your information will be kept confidential according to EEO guidelines.
Skills Required
- Strong SQL / PL-SQL skills
- ETL development experience
- Data modeling experience
- Experience integrating source data and building ETL pipelines
- Experience building connections via JDBC
- Experience with Kafka
- Experience using APIs for data ingestion
- Celonis and Celonis Platform Administration knowledge
- Experience supporting production ETL jobs and troubleshooting failures/performance issues
- Experience designing audits and reconciliation processes to ensure data completeness and correctness
- Define and enforce governance, access control, and ETL best practices
- Familiarity with Agile delivery (Scrum/Kanban)
- Background check (mandatory)
What We Do
PDDN is a leading software engineering solution & Staffing solution provider focusing on enterprise wide solutions enabling its customers to realize best value on its investments. We have expertise in application development and professional staffing . We provide on-shore,off-shore and hybrid model for outsourcing. We also provide wide spectrum of IT services customized to client's needs. Please log on to our company website www.Pddninc.com
