• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 17th Jan 2025

1) Strong understanding of relational database concepts, SQL (Structured Query Language), and data modeling. Knowledge of various databases used in data warehousing, such as Oracle, SQL Server, PostgreSQL, or MySQL.

2) Proficiency in ETL tools like Azure Data Factory, Azure Synapse, or Microsoft SSIS (SQL Server Integration Services) to extract data from various sources, transform it to fit the target schema, and load it into the data warehouse.

3) Ability to design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysis.

4) Understanding of data integration techniques and data quality processes to ensure data accuracy, consistency, and reliability in the data warehouse.

5) Knowledge of data warehouse architecture principles, such as data staging areas, data marts, data lakes, and the overall data flow.

6) Familiarity with data warehouse development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses.

7) Proficiency in scripting languages like Python, Perl, or Shell scripting for automating ETL processes and data manipulation.

8) Understanding of data security principles and compliance regulations to protect sensitive information in the data warehouse.

9) Skills in optimizing data warehouse performance, including query optimization, index creation, and partitioning.

10) Ability to collaborate with business stakeholders to gather and document reporting requirements, translating them into effective and performance-optimized Power BI dashboards and reports. This includes designing visually engaging, user-friendly layouts aligned with key performance indicators, as well as implementing row-level security, advanced DAX measures, and interactive visuals to deliver clear, actionable insights.