What are the responsibilities and job description for the ETL Informatica Developer with Oracle PL/SQL position at ICONMA?
Description:
- Perform data analysis and reporting to support business decision-making
- Develop, Design and Implement ETL process using Informatica and/or Oracle PLSQL in a large Datawarehouse environment.
- Collaborate with cross-functional teams to support dev leads identify and prioritize business needs
- Support server updates and Informatica cloud migration projects to ensure seamless system integration
- Work closely with the IT team to ensure data security and compliance
- Analyze and troubleshoot data discrepancies and system issues
- Understanding the scope of Project Management and be able to scale up to lend a hand when required.
- Bachelor's degree in Computer Science, Information Systems, or related field
- At least 7 plus years of experience in data analysis.
- Candidates must have more than 8 plus years of experience in Oracle/PL SQL, ETL/Informatica
- Strong knowledge of Unix shell scripting
- Hands on experience on Informatica Upgrade/Migration experience
- Experience in data quality approaches and techniques is a must
- Excellent written and communication skills and ability to clearly indicate data integration solution designs and implementations.
- Agile experience
- Financial Services / Banking experience
- Build & Release orchestration tools
- Experience in working with larger projects involving multiple groups including nearshore and offshore teams
- Performance Tuning experience
- Strong SQL knowledge and ability to develop Informatica repository queries
- Strong experience with server updates and cloud migration
- Proven experience in the financial industry / compliance/ regulatory reporting/ fraud detection
- Ability to work in a fast-paced environment and meet deadlines
- Proficiency in data visualization tools and programming languages (SQL)
