The Job
- Analyze, develop and support ETL and CDC pipelines in and out of data warehouse with a focus on automation, performance, reliability, durability, data quality, security and SLA expectations
- Provide production support for Data Warehouse issues such data load problems, transformation translation problems
- Perform data mappings and design of system for ETL/CDC workflow solutions
- Adhere to and promote CI/CD best practices, processes, and deliverables in accordance with up-to-date standards in a DataOps environment
- Work closely with business analysts to implement integration technology solutions that meet the specifications of a project or service request
- Develop automated data audit and validation processes
- Participate in architectural design review sessions and ensure all solutions are aligned to pre-defined specifications
- Ensure accurate and timely data availability to meet business SLA, especially around critical time periods
- Document ETL and data warehouse processes and flows

Qualifications Skills required




- Ability to support and/or develop ETL pipelines and scripts in and out of data warehouse using combination of HVR, Goldengate, Snaplogic, Python and Snowflake s SnowSQL
- Experience with different source systems like SAP, HANA, OLFM and SalesForce preferred
- Strong SQL skills including stored procedures
- Extensive experience performance tuning, troubleshooting and debugging solutions
- Experience in supporting Data Warehouse and data transformation issues
- Demonstrated experience providing production support during time sensitive situations
- Experience in integrating premise infrastructure with public cloud (AWS, AZURE, Snowflake)
- Experience with AIX/Linux shell scripting
- Experience performing detailed data analysis (i.e. determining the structure, content, and quality of the data through examination of source systems and data samples)
- Ability to translate requirements for BI and Reporting and data transformations
- Ability to des

📌 Advisory Software Engineer (Pune)
🏢 Pitney Bowes
📍 Pune