Description
You will design, develop, and maintain ETL workflows, reusable components, and data integration interfaces.
Responsibilities
- Design and optimize stored procedures and complex SQL queries within DB2 and Sybase environments.
- Perform data modeling, database design, and performance tuning to ensure efficient data processing.
- Develop and maintain automation scripts using Python, shell scripting, Perl, and Unix commands.
- Build APIs to enable seamless integration across systems.
- Ensure data quality, consistency, and integrity across multiple database platforms.
Required Skills
- 12+ years of experience in data integration, ETL development, and database management.
- Strong expertise with Informatica and Python scripting.
- Hands-on experience with DB2 and Sybase database platforms.
- Advanced knowledge of data warehousing concepts and relational database design.
- Proficiency in writing stored procedures and query optimization.
- Strong scripting skills in Python, shell scripting, and Perl.
- Solid understanding of Unix/Linux environments.
- Bachelor’s or Master’s degree in Computer Science, IT, or a related field.
Preferred Skills
- Familiarity with PostgreSQL.
- Experience in API development and integration.
- Exposure to Business Intelligence tools and Source-to-Pay applications like SAP Ariba.