Bachelors degree in Computer Science, Computer Engineering, Information Technology or a related technical field and 10 years of experience in the job offered or a related occupation.br br Experience must includebr br 1 10 years of experience designing, delivering, and implementing technologybased business intelligence solutions using ETL tools like Informatica, IDQ Cognos tools or equivalent.br 2 10 years of experience working on data warehouse initiatives with both relational and nonrelational database management systems using databases such as Oracle, SQL Server.br 3 Experience in building mappings and workflows in IDQ to parse and identify different patters of data and validate duplication, conformity, and integrity of data.br 4 Experience in programming languages like Python, Unix scripting like similar tools to data load or automate the manual workbr 5 Experience in Source code management control using SVN or GIT or equivalent.br 6 Write SQL statements and PLSQL code for data validation and data analysisbr 7 Handle complex projects in Data warehousing and business intelligence with SDLCAgile procedures for systems design, development, verification, and implementationbr 8 Experience is using ETL skills to extract, transform and load data from multiple sources using any ETL tools to store the data into databasebr 9 Experience in working with cloud related technologies like AWS S3, Snowflake database and equivalent.br 10 Have experience in Architectural functional and technical design and review, sizing, scalability, administrationbr 11 Experience in analyzing explain plan and use query optimization techniques to improve the performance of the querybr 12 Experience in developing frameworks to integrate data from different source systems and develop incremental batch loads.br 13 Experience in dealing with large set of transactional data in efficient way without impacting performance and load on database.
Categories: eb3
0 Comments