Data Analyst - SQL ETL/SSIS - KPO

SQL Data Analyst-SQL ETL/SSIS

Eligibility Criteria:

- 4+ years strong proficiency with SQL and its variation among popular database like Postgres, Mysql.

- Expertise in writing SQL queries/procedures/functions/triggers/views.

- Requirements gathering and develop business logic using T-SQL script.

- Good understanding on tracking deadlocks on SQL.

- Should be able to troubleshoot SQL queries for performance tuning.

- Skilled at optimizing large complicated SQL statements.

- Great problem solving, analytic and troubleshooting skills.

- Familiar with tools that can aid with profiling server resource usage and optimizing it.

- Has good understanding and experience on data migration using ETL tools

- Ability to understand requirements and changes to requirements

- Strong communication skills - in onsite / offshore engagement models

Responsibilities:

- Responsible for delivering projects heavy in back end database work.

- Partner with other developers optimizing in application SQL statements necessary, and establishing best practices.

- Performance tuning, query optimization and using SQL profiles and other related monitoring and troubleshooting tools.

- Develop high quality database solutions.

- Design, build and launch new data extraction, transformation and loading processes.

- Strong knowledge of data structures and algorithms.

- Ability to drive tasks to completion and take ownership of projects by working in a fast paced agile development environment.

- Mentor other engineers, defining our challenging technical culture with sharp analytical abilities, and proven design skills.

- Strong written and oral communication skills; Ability to communicate effectively with technical and non-technical staff.