IT - Technology Lead | Data Management - DB | MySQL
This Job was posted over 30 Days Ago on 08-16-2021
Job Seekers, Please send resumes to resumes@hireitpeople.com
Must Have Skills:
- Informatica
- SQL
- Databases
Detailed Job Description:
- Around 8 years of experience in IT Software Development Life cycle involved in Business Requirements
- Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing
- applications in healthcare and retail domains.
- Strong knowledge in ETL Informatica.
- Proficient in T - SQL queries using Store Procedure, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, DDL etc.
- Strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by
- reviewing PLSQL code, modifying database parameters.
- Good understanding of ETL, D Writing scripts in Unix to process source files, target files, to automate the email notifications, Archive the
- files, copy, ftp and cleanse the files to process in ETL.
- Extensive experience in creating documents for Low level and High-level design docs, Unit test plans, test cases and test scripts.
- Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts Good communication and interaction with client.
Minimum years of experience required: 8+