Should have good querying skills on MSSQL Oracle Postgres databases with ability to understand debug PL/SQL procedures.
SQL proficiency with experience in constructing/deconstructing complex reports and queries
Experience in modifying PowerShell scripts
Experience in performance tuning of mappings, error handling, testing, debugging, troubleshooting skills and migration of objects.
Experience in managing Files, MSSQL DB, XMLs through ODI
Experience in developing Load Plans, Scheduling Jobs
Experience in integrating ODI with multiple Source / Target
Excellent verbal and written communication skills
Skilled problem-solver and detail oriented
Requires ability to work on assigned tasks independently with limited direction.
Takes personal responsibility for the quality and timeliness of work and achieves results with minimal oversight.
Must be a team player and work well in a deadline-driven environment with multiple priorities.
Data modeling experience using dimensional data modeling, star/snowflake schema, fact and dimension tables, physical and logical data modeling.
Roles Responsibilities:
AWS working knowledge
Responsible for design, development, customizations, deployment, and post-implementation support for ODI, and ETL solutions
Provide expertise in performing application development, configuration and unit testing of data integration (using ODI, PL/SQL, SQL).
Work closely with business stakeholders and database administrators to plan, design, develop and implement applications, scripts, procedures and metadata for relational databases.
Responsible for performing analysis, design, development, testing and performance improvements of complex queries based upon the specific needs of USP
Responsible for troubleshooting, debugging, optimizing and performance tuning of data warehouse and ETL(ODI) scripts.
Responsible to develop and maintain documentation for ongoing operational activities.
