Senior Technical Specialist - SQL/ETL

Description :

Title : Senior Technical Specialist

Location : Hyderabad

Exp level : 10+ Years

Key Responsibilities :

- 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.