Etl Developer
Job ID : 34658
Job Title : Etl Developer
Location : Boston, MA
Comapny Name : MSIT
Job Type : Full-Time, Part-Time, Contract, Training
Industry : Information Technology
Salary : $34000 - $44000 per hour
Work Authorization : ["OPT","CPT","Entry Level","F1","H4","L1","H1 Visa","TN Permit Holder","Green Card Holder","Canadian Citizen","All EAD","US Citizen"]
No. of Positions : I have ongoing need to fill this role
Posted on : 09-11-2023
Required Skills : SQL, data storage techniques, Big Data technologies.
Benefits : Medical Insurance, Dental Insurance, Vision Insurance, 401K, Life Insurance
Job Description :
Responsibilities:
- Design, develop, and maintain ETL workflows to integrate data from various sources into our data warehouse and business intelligence systems.
- Responsible for designing and implementing ETL workflows, as well as writing scripts to automate data processing tasks.
- Obtain data requirements and ensure that the ETL workflows meet stakeholder requirements.
- Perform data analysis and profiling to identify data quality issues and recommend solutions.
- Build data integrations using SSIS, Azure Data Factory, and other tools.
- Analyze and optimize ETL process performance from file processing through writing to database.
- Collaborate with developers and other IT staff to troubleshoot and resolve issues with the ETL workflows.
- Develop and maintain technical documentation for ETL processes and workflows.
- Keep up-to-date with emerging trends and technologies in ETL and data integration.
Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or equivalent experience.
- Minimum of 5 years of experience in ETL development and data integration using SQL Server or PostgreSQL development skills, as the ETL Developer.
- Must have strong experience in ETL development, data integration, and data analysis, preferably in a healthcare environment. Professional experience developing with SSIS or similar ETL toolset.
- Experience writing views, stored procedures, functions.
- Experience with SQL optimization and execution plan analysis.
- Experience with source control management and deployment tools.
- Experience working in an Agile environment a plus.
Key Skills:
- SQL competence.
- Understanding of data modeling concepts.
- Knowledge of at least one ETL tool Informatica, SSIS, Talend, etc.
- Knowledge of different SQL/NoSQL data storage techniques and Big Data technologies.
Company Details :
Company Information hidden please Login to view details