Good understanding of ETL framework and concepts, Microsoft SSIS
Informatica- Develop and support Extraction, Transformation and Load process (ETL) using Informatica Power Center to populate SQL Server tables and flat files
Develop and deploy the code in Informatica for import/export of data into the application
Experience with complex SQL Server PL/SQL, Stored Procedures, Views
Experience with Oracle PL/SQL, Procedures, Package development
Implement stored procedures and effectively query a database.
Develop SSRS reports, Test and deploy.
Create SQL Server Stored Procedures.
Develop and deploy the job scheduling in Tidal.
Troubleshoot ETL process and Query tuning
Provide support and fix issues in the ETL packages.
Author and execute unit test scripts.
Optimize database systems for performance efficiency.
Database programming, SQL performance tuning, data modeling, ETL job scheduling, Windows batch scripting.
Secondary
Programming languages - C#, JavaScript, Typescript(good to have)
Possess knowledge on XML & JSON– structure, elements