Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 22nd Jul 2021
FUTURE DUTIES AND RESPONSIBILITIES
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
DESIRED QUALIFICATIONS/NON-ESSENTIAL SKILLS REQUIRED
• C#
• Power BI / SAP-BO / SSRS
• Visio
• Azure Dev Ops