Good knowledge in Tuning SQL Queries and ETL Code to Improve Performance.
Good Hands On working experience on writing SQLs and PL/SQL in Oracle or SQL Server.
Experience in developing Unix Shell Scripts.
Involved in Integration Testing and UAT Testing.
Understands whole DWH Project life Cycle and was part of all phases.
Prepared required SDLC Documents as per Client Standards and guidelines. Should have involved in Deployment process.
Experience on JAVA is added advantageExperience in Redshift will be added advantage.
Roles & Responsibilities
Minimum 3 yrs of IT Experience on areas like Data Warehouse/ETL/Informatica. Extensive experience in building Data Warehouses/Data Marts using ETL tools like Informatica Power Center.
Excellent Knowledge on DWH, ETL, RDBMS Concepts. Knowledge on dimensional modeling, Star and Snowflake schemas, Data mart and Fact, Dimension tables, Slowly Changing Dimensions -Type I & II & III is highly needed.
Developed complex Mappings and Workflows in Informatica to implement critical Business rules.
Implemented Parameterization and Restartability techniques in Informatica.
DataFactZ is a Business Analytics company that has made it our mission to help executives transform their company mindset from reactive to predictive to enable Data Drive Decision making. We're doing exactly that for iconic companies across the United States, from New York to Hawaii and from Florida to Washington. At DataFactZ, our passion is using technology and our experience to help our clients turn business problems into a competitive advantage. The evolution of Big Data Analytics has made this a reality in virtually every area of the enterprise, from HR to Supply Chain, and from the Plant Floor to the Board Room. DataFactZ is now 800+ strong, all focused on managing and leveraging data to create value for our clients with a suite of Strategic and Implementation services in the areas of Data Engineering, Data Science, and Decision Science. If it's in that space, we've probably already done it.