Offer summary

Qualifications:

10+ years of Business Intelligence experience, 8+ years of Informatica PowerCenter and/or Informatica IDQ experience, Strong SQL development experience using tools like Toad, Oracle SQL Developer, or Microsoft SQL Developer, Good analysis, problem-solving skills, and interpersonal skills..

Key responsibilities:

Understand business requirements in the BI context and design data models to convert raw data into meaningful insights.

Perform ETL transactions and develop jobs to fetch data, including complex stored procedures and functions.

Monitor scheduled jobs and provide resolution for issues raised by end users.

Conduct data warehouse development and manage execution and rollout of solutions.

Job description

Job Description

Title: Senior Technical Specialist

Location: Hyderabad/Mumbai/Bangalore

Education: Any Degree

Job Description:

10+ years of Business Intelligence experience
To understand business requirements in the BI context and design data models to convert raw data to meaningful insights.
To be able to convert business requirements into technical specifications and decide the timeline to accomplish tasks.
8+ years of Informatica PowerCenter and/or Informatica IDQ experience.
8+ years of SQL development experience using tools like Toad, Oracle SQL Developer, or Microsoft SQL Developer.
Proven extensive working experience on Informatica Power Center.
Proven extensive working experience on Informatica Power Center.
Perform ETL Transactions and develop Jobs to fetch data.
Knowledge of strong SQL Server but should be able to understand and develop complex database objects.
Should be able to develop complex Stored Procedures, Functions, Trigger, User-defined Functions, Views and Indexes.
Performance tuning of Informatica jobs is preferable.
Experience on Designing and Implementing ETL methodologies/solutions on basis of requirements.
Production support activities including on call support.
Experience in Azure Technologies like ADF, Storage Accounts is a good to have.
Providing resolution of issues.
Monitoring of scheduled jobs and reports in case of issues.
Giving expert support and information to the queries raised by the end user.
Ability to work in a team driven environment under stringent targets.
Good Analysis, Problem Solving skills and Interpersonal Skills.
Strong data analysis skills, with an attention to detail Ability to code in SQL
To conduct data warehouse development.
To perform SQL querying for best results.
Experience of database design or integration experience with Oracle and/or SQL Server databases
Developing projects from a detailed business requirement, working through solutions and managing execution and rollout of these solutions, in the context of an overall consistent global platform
Understand business requirements and take the complete ownership till the product delivery.

About Us

Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner.

About The Team

Datavail’s Data Management Services:

Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. Datavail’s team is comprised of not just excellent BI & analytics consultants, but great people as well. Datavail’s data intelligence consultants are experienced, knowledgeable and certified in the best in breed BI and analytics software applications and technologies. We ascertain your business objectives, goals and requirements, assess your environment, and recommend the tools which best fit your unique situation. Our proven methodology can help your project succeed, regardless of stage. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the Data Management experts on demand you desire. Datavail’s flexible and client focused services always add value to your organization.

Required profile