prachi.chowhan@nytpcorp.com
Job Title: ETL/Data Integration Engineer
Location: Columbus, OH (Onsite 5 days/week) – Local Only
Visa: US Citizen, Green Card, TN, H4
Summary
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.
Key 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.
Required Qualifications
- Bachelor’s degree in computer science, Engineering, Information Technology, or related technical field (or equivalent experience).
- 7+ years of relevant experience in data integration, ETL development, or related software engineering roles.
- Strong SQL and PL/SQL skills (required).
- Proven experience designing and building ETL solutions and data models; strong analytical skills for interpreting complex datasets.
- Experience integrating data from ERP and enterprise systems (e.g., Oracle, PeopleSoft, Maximo) desirable.
- Excellent communication and collaboration skills; experience working cross-functionally.
Optional / Preferred (but not required)
- Experience with Celonis process mining tools or Celonis Platform Administration (optional — nice to have).
- Experience with Apache Kafka and real-time streaming integrations. (optional — nice to have).
- Proficiency in Python or other scripting/programming languages for automation and data transformation.
- Familiarity with platform administration tasks (user governance, access control, monitoring) for process-mining platforms.
What We’re Looking For
- Strong ETL and data-integration engineering skills with the ability to deliver robust, auditable data pipelines.
- Candidates without prior Celonis experience who demonstrate strong ETL, SQL/PL-SQL, and integration expertise are encouraged to apply.
