Job ID : 34658
Location : Boston, MA
Company Name : MSIT
Job Type : Full-Time, Part-Time, Contract, Training
Industry : Information Technology
Salary : $34000 - $44000 per hour
No. of Positions : I have ongoing need to fill this role
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.
