Advisory Software Engineer

Job Description

At Pitney Bowes, we do the right thing, the right way. As a member of our team, you can too. We have amazing people who are the driving force, the inspiration and foundation of our company. Our thriving culture can be broken down into four components: Client. Team. Win. Innovate. We actively look for prospects who: Are passionate about client success. Enjoy collaborating with others. Strive to exceed expectations. Move boldly in the quest for superior and best in market solutions. Job Description: Join Pitney Bowes as a n Advisory Software Engineer Years of experience: 6 + years Job Location -Pune Impact We are looking for a skilled Data Warehousing Support individual to be part of a highly integrated, cross-disciplined team that will be responsible for supporting modern ETL services for cross systems, applications and Business Intelligence leveraging Cloud Data Warehouses, SAP, SFDC and other enterprise databases. 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 modern 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 design and outline solutions using cloud based and on-premises technologies Ability to understand data pipelines and modern ways of automating data pipeline Actively test and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions Expert in source and target system analysis and prior experience on project analysis and cost estimations Ability to work effectively in a remote team environment Excellent written and verbal communication, time management, and presentation skills Additional Skills Problem-Solving: Ability to troubleshoot and resolve technical issues efficiently. Communication: Effective communication skills to interact with stakeholders and team members. Analytical Thinking: Ability to analyse data and identify patterns and trends. Attention to Detail: Meticulous approach to ensure data accuracy and integrity. Adaptability: Willingness to learn new technologies and adapt to changing requirements. Time Management: Effective time management skills to meet project deadlines. Adaptability: Flexibility to adapt to changing project requirements. Stakeholder Management: Ability to manage expectations and build relationships with stakeholders. Experience More than 1 years experience with Snowflake cloud-based data warehouse Hands-on experience with at least one Snowflake project 4-6 years experience developing ETL, ELT and Data Warehousing solutions 4-6 years experience with HVR or Snaplogic (preferred) More than 2 years experience with CDC technologies(preferred) More than 2 years experience AWS cloud, Azure or Google cloud 2-4 years experience developing Python based code that reads/writes data into databases 2-4 years experience developing SQL scripts and stored procedures that process data from databases 2-4 years experience with batch job scheduling and identifying data/job dependencies Strong understanding of various data formats such as CSV, XML, JSON etc. About Pitney Bowes Pitney Bowes (NYSE:PBI) is a global technology company providing commerce solutions that power billions of transactions. Clients around the world, including 90 percent of the Fortune 500, rely on the accuracy and precision delivered by Pitney Bowes solutions, analytics, and APIs in the areas of ecommerce fulfillment, shipping and returns; cross-border ecommerce; office mailing and shipping; presort services; and financing. For 100 years Pitney Bowes has been innovating and delivering technologies that remove the complexity of getting commerce transactions precisely right. For additional information visit Pitney Bowes at https://www.pitneybowes.com/in . Only Talent Matters at Pitney Bowes Pitney Bowes is an equal opportunity workplace. To remove unconscious biases from our hiring process, we encourage Blind Applications from candidates applying for jobs at Pitney Bowes. This means that details such as gender, caste, religion, nationality, and age are omitted from applications. And candidates can choose to reveal only their first or last name on the application. Watch the video here: https: / / www.youtube.com / watchv=dNB-K5KFU78 Watch the videos below for more information about Life at Pitney Bowes: Who we are Pitney Bowes All Stars Pitney Bowes named a Great Place to Work Pitney Bowes Gratitude Video Pitney Bowes COVID Care Pitney Bowes was the recipient of several coveted Awards: We will: Provide the will: opportunity to grow and develop your career Offer an inclusive environment that encourages diverse perspectives and ideas Deliver challenging and unique opportunities to contribute to the success of a transforming organization Offer comprehensive benefits globally ( P B Live Well ) Pitney Bowes is an equal opportunity employer that values diversity and inclusiveness in the workplace. All interested individuals must apply online.