Technical Specialist - PL-SQL/ETL tools

Description :

About the job :

Experience : 4-7 Years

Job Type : Hybrid Bangalore, Hyderabad 2nd Shift 2-11 PM

Location : Contract with client

Job Description :

Key Responsibilities :

- Develop, implement, and maintain PL/SQL scripts and procedures to facilitate data transformations and integrations.

- Utilize ETL tools (Talend, Informatica, or DataStage) to conduct transformation activities and ensure data quality.

- Monitor and enhance data quality through validation, cleansing, and enrichment processes.

- Manage and optimize SQL Server databases to support robust and efficient data management.

- Collaborate with cross-functional teams to design and implement data warehousing (DW) and business intelligence (BI) solutions.

- Stay informed about the latest trends and best practices in data management, ETL, DW, and BI.

- Troubleshoot and resolve data-related issues to maintain workflow efficiency.

Required Skills & Experience :

- Proven experience with PL/SQL programming and database management.

- Expertise in ETL tools such as Talend, Informatica, or DataStage.

- Strong knowledge of data quality principles and practices.

- Proficiency in SQL Server and experience in database administration.

- Understanding of data warehousing (DW) and business intelligence (BI) concepts.

- Excellent analytical and problem-solving skills.

- Strong communication and collaboration abilities.

Preferred Qualifications :

- Bachelors degree in Computer Science, Information Technology, or a related field.

- Experience in managing large-scale data transformation projects.

- Familiarity with cloud-based data management and ETL solutions.

- Certification in relevant ETL tools or database management systems.

- Demonstrated experience in developing BI reports and dashboards