Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations. We are currently seeking a Microsoft Fabric ETL Senior Developer for our client in the Professional Services domain. We value our professionals, providing comprehensive benefits and the opportunity for growth. This is a Contract position, and the client is looking for someone to start immediately.

Duration: 4+ Months Contract

Location: Remote

Salary: $75.00-$80.00/Hourly

Role: Microsoft Fabric ETL Senior Developer

Primary Skills: ETL

Role Description: The Microsoft Fabric ETL Senior Developer must have 6+ years of experience. n this role, you will design, implement, and optimize ETL processes using Microsoft Fabric for a new major application, working closely with an established, globally distributed development team to understand the application architecture, tools, and the processes, established during the build of MVP.

Responsibilities:

- Ensure that data is efficiently and accurately processed from source systems into the Microsoft Fabric data layer and transformed across the various levels of transformation inside Fabric.

- Collaborate with business analysts and business stakeholders to understand data requirements, transformation rules, and relevant accounting business logic.

- Develop transformation logic to clean, enrich, aggregate, and otherwise modify data to meet business needs.

- Implement data validation and error handling procedures to ensure data integrity.

- Implement processes to load processed data into Microsoft Fabric data storage or previously worked in technologies like Azure Synapse, Azure Data Lake, etc.

- Optimize data loading processes to ensure performance and scalability.

- Design and deploy ETL pipelines using Python and PySpark within Microsoft Fabric.

- Collaborate with data architects to design the data architecture and models that align with the accounting application requirements.

- Implement data schemas, star/snowflake schema designs for data warehouses, and OLAP cubes, as necessary.

- Optimize ETL processes for performance and resource utilization.

- Implement indexing, partitioning, and other performance enhancements to handle large volumes of data efficiently.

- Develop and execute unit tests, integration tests, and end-to-end tests for ETL processes.

- Troubleshoot and resolve issues, making improvements and adjustments as needed.

- Validate data accuracy and consistency throughout the ETL lifecycle.

- Create and maintain comprehensive documentation for ETL processes, data sources, data flow diagrams, and data models.

- Ensure documentation is up-to-date and accessible to relevant stakeholders.

- Ensure all data processing complies with relevant policies and standards.

Qualifications:

- High proficiency in Microsoft Fabric and related ETL tools (e.g., Azure Data Factory).

- Knowledge of database systems (e.g., SQL Server, Azure SQL Database, Synapse Analytics) and understanding of data warehousing concepts and architecture.

- Experience with data modeling and schema design.

- Familiarity with programming languages used in ETL processes (e.g., Python, PySpark).

- Strong understanding of data engineering principles, including data modeling, data transformation, and data optimization.

- Strong SQL skills for data extraction, transformation, and querying.

- Knowledge of accounting principles and logic is highly beneficial.

Certifications are nice to have, not required:

- Microsoft Certified: Fabric Analytics Engineer Associate (strongly preferred)

- Microsoft Certified: Azure Data Engineer Associate

- Microsoft Certified: Azure Developer Associate

- Microsoft Certified: Azure Solutions Architect Expert

Education: Bachelor?s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field or Equivalent

Experience: Minimum 6+ years of experience

Relocation: This position will not cover relocation expenses

Travel: No

Local Preferred: Yes

Note: Must be able to work on a W2 basis (No C2C)

Recruiter Name: Zulker Ali

Recruiter Phone:

Benefits:

We have various coverages and additional benefits to choose from:

- Medical, Dental (Including Ortho) & Vision Insurance (Option to Enroll).

- Paid Leaves (Wherever applicable).

- Life & Disability Coverage (Upon eligibility).

- 401K Option, Education Assistance Program and more.

Mastech Digital is an Equal Opportunity Employer - All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

#LI-ZA1

#Mastech1