• US Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 15th Aug 2022

·         Actively and consistently support all efforts to simplify and enhance the customer experience

·         Partner with the IT/BI team and cross functionally within the organization to provide insight and technology recommendations that result in enterprise solutions that solve critical business problems

·         Develop and maintain data structures which draw information from multiple sources of data such as corporate databases, corporate data warehouses and field operational data stores

·         Design, deliver, and document multi-platform architecture with a focus on architectural standards, growth, performance, flexibility, reliability, scalability and security

·         Identify architectural risks and plans to mitigate--quickly troubleshoot problems with data generation and reporting to correct problems with a minimum of downtime in the process

·         Work with vendors to develop metadata structures for two-way data communications which allow interchange between existing and new data sources

·         Recommend and implement new ways of exchanging data with corporate or field customers using network or web based reports, forms or files

·         Generate new data products for data licensing which fit client requirements

·         Manage the transfer from prototype to scheduled report

·         Oversee the use of corporate data to create reports in Excel, Crystal Reports and other reporting tools

·         Identify desktop tools which will improve reporting or data gathering ability. Evaluate and recommend purchase if necessary.

·         Quickly learn new tools (desktop or external) which enhance the department’s ability to gather, process, or report data. Integrate these tools with existing structures to improve information flow

·         Use knowledge of business processes to work with personnel in Sales, Marketing, Finance, and Operational disciplines. Be able to quickly understand their problems and devise solutions.

·         Design and help develop ETL, replication schemes, and query optimization techniques that support highly-varied (structured, semi-structured, and unstructured) and high-velocity (near real-time) data processing and delivery

·         Develop standards and methodologies for benchmarking, performance, evaluation, testing, data security and data privacy

·         Perform impact analysis, performance tuning, and capacity planning for the data warehouse and its infrastructure as source systems are added and new integration business rules and logic are introduced

·         Provide recommendations, technical direction and leadership for different technologies as part of the overall architecture

Required Qualifications:

·         Advanced Knowledge of Tables, Queries and Views in MS SQL and Oracle.

·         Knowledge of Relational Data Modeling, Database design, and analysis of data requirements and sources

·         Experience in architecting and building procedures, functions, views, and triggers with SQL relational databases

·         Proficient in complex database concepts and effectively employ different database design techniques

·         Ability to program in TS-SQL and VBA

·         Ability to use MS Office Suite (Word, Excel, PP, Access, Visio)

·         Edwin

·         Snowflake