Having 8.7+ Yrs. of experience in ears of Extensive Software Development Life Cycle experience.
• Worked on View, Procedures, Function, Triggers, Indexes, Partitioning.
• Good in SQL Queries.
• Experience in data extraction, transmission and loading.
• Experience in SSIS Package-Data flow and control Flow.
• Worked on SSIS Components- Flat File Source, OLÉ DB Destination, Conditional Split, ADO NET Source, Aggregate, Flat File Destination, Back Up Database Task, FTP Task, Script Task, Execute SQL Task, For each Loop Container, For Loop Container, Sequence Container ,File System Task
• Good explore in Data warehousing concept and Data Modeling.
• Good knowledge on Dimensional data model, Star schema, snowflake schema.
• Working experience in Retail.
• Experience in Python.
• Good Knowledge in AWS Redshift.
• Experience in Hive, Sqoop
• Good knowledge in Cloud (Aws/Azure)
• Expertise in debugging the code.
• Good knowledge in UNIX commands.