Required Skills

SQL • ETL • SSIS packaging • .Net • Python • Data model

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 27th Jul 2021

JOB DETAIL

Skills needed :-
• Development of SSIS packages for ETL jobs from various source systems (loading data from different file formats -JSON/CSV or via API calls)
• Development of integrated solution needs for extraction and validation purposes.
• SQL development – Stored Procedures, Views, Functions and complex SQL Queries for validation and error handling
• Development on extracting xml data in SQL server to XML file based on XSD file format
• Good understanding of Data Warehouse design including analysis of Data Model changes and impact to existing process and physical schema design
• Discuss and review data/process requirements and offer solutions for a cleaner approach.
• Application testing for various scenarios
• Development of documentation as needed (Architecture, Technical Flow, etc.)
• Experience in data cleansing, data profiling and data standardization
• Experience with Python and .Net programming

REQUIRED QUALIFICATIONS TO BE SUCCESSFUL IN THIS ROLE
• SQL
• ETL
• SSIS packaging
• .Net
• Python
• Data model

 

Company Information