IICS Ccontractor

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.