Job title: PL/SQL SR DEVELOPER
Exp: 15+ yrs
Location : Alpharetta, GA
Job summary JD:
Primary Skill : ODI / Secondary Skill : PL/SQL
• Should have 8-10+ years of experience working with ODI
• Expert/Advanced level experience with ETL Tools particularly Oracle Data Integrator (ODI) and PL/SQL
• Should have strong understanding in BI/data warehouse analysis, design, development & test experience.
• Expert level experience of Data analysis, Data Profiling, Data Quality, Data modeling, Data integration Expert.
• Should have customized existing knowledge module Should have created packages / functions/procedures within ODI /implementation of CDC
• Should have created and schedule ODI load plans.
• Should have ability to design and develop ETL Interfaces, Packages, Load plans, user functions, variables and sequences in ODI to support both batch and real-time data integrations
• Good knowledge in customization and ODI plugin creation.
• Should have knowledge of ODI security.
• Experience in writing complex queries, Stored Procedures in Oracle SQL and Oracle PL/SQL
• Deep experience in SQL tuning, tuning ETL solutions, physical optimization of databases.
• Collaborate to prepare data verification and testing methods for data/applications loaded into the warehouse, or other data repositories, to ensure compatibility across different sources
• Code, develop, and document complex scripts integration mappings and workflows, and stored procedures
• Provide technical expertise and direction in developing and supporting system level programs
• Troubleshoot advanced data problems and recommend appropriate action
• Create new or enhanced components of data architecture and interfaces
• Collaborates with other Data Engineers and Data Architects to build optimal and efficient ETL and Database code.
Required Skills Technical Skills- ,Oracle Data Integrator
Nice to have skills Techincal Skills- ,PL/SQL,Oracle NoSQL, Snowflake
Technology: Oracle Data Management 7