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.