We are seeking a highly skilled and experienced ETL Developer with 10+ years of experience in ETL development, data analysis, and performance tuning. The ideal candidate will have strong expertise in Informatica, SQL/PLSQL, Unix/Linux, and job scheduling tools like Autosys. You should be detail-oriented, self-driven, and able to communicate effectively with cross-functional teams.
Key Responsibilities
- Develop, test, and maintain ETL processes using Informatica.
- Write complex SQL and PL/SQL queries for data manipulation and analysis.
- Design and manage data models, table partitions, and database tuning strategies.
- Work with stored procedures, triggers, and various third-party tools.
- Perform root cause analysis and ensure data quality and consistency.
- Collaborate with cross-functional teams including business technology partners.
- Ensure performance optimization for high-volume data processing.
- Use Autosys for job scheduling and monitoring.
- Utilize Unix/Linux for scripting and automation tasks.
Required Skills
- 10+ years of ETL development experience.
- Strong SQL, PL/SQL, and database design skills (Sybase/SQL Server).
- Proficient in Informatica PowerCenter.
- Familiarity with Java and integrating it into ETL processes.
- Solid understanding of Unix/Linux environments.
- Experience with Autosys or similar scheduling tools.
- Knowledge of capital markets/treasury business is a strong plus.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work independently and collaboratively in a team environment.