Required Skills

Sr. ETL Developer with (SSIS)

Work Authorization

  • Us Citizen

  • Green Card

  • 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 :- 8th Oct 2021

JOB DETAIL

1.    Hands-on architecture/development of ETL pipelines using our internal framework written in Java

2.    Ability to handle large volume of data.

3.    Strong hands-on experience in Azure Data Factory (ADF).

4.    Provide maintenance support/Troubleshooting any issues that may arise.

5.    Experience working with SQL Server/Stored Procedures/API.

6.    Experience working with SSIS.

7.    Consulting with data management teams to identify data storage needs and providing warehousing options based on the storage needs

8.    Designing and coding data warehousing system to desired specifications

9.    Conduct preliminary testing of the warehousing environment prior to data extraction

10. Extract company data and transferring it into the new warehousing environment

11. Testing the new storage system once all the data has been transferred

12. Interpret data, analyze results using statistical techniques and provide ongoing reports

13. Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality

14. Acquire data from primary or secondary data sources and maintain databases/data systems

15. Identify, analyze, and interpret trends or patterns in complex data sets

16. Filter and clean data by reviewing reports and performance indicators to locate and correct problems

17. Work with management to prioritize business and information needs

18. Locate and define new process improvement opportunities

19. Provide maintenance support/Troubleshooting any issues that may arise

 ·      Technical expertise regarding data models, database design development, data mining and segmentation techniques

·      Good experience writing complex SQL and ETL processes

·      Experience working with large data volumes, including processing, transforming and transporting large-scale data

·      Experience in cloud-based data integration service for creating ETL and ELT pipelines like Azure Data Factory (ADF)..

·      Excellent working knowledge of Apache Hadoop, Apache Spark, Kafka, Scala, Python etc.

·      Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention  to detail and accuracy

·      Good understanding & usage of algorithms and data structures

·      Good Experience building reusable frameworks.

·      Experience working in an Agile Team environment.

·      Excellent communication skills both verbal and written

Company Information