Data Engineer

Hello Everyone,

Title: Data Engineer

Location: Boston.

Working Model-Initial onsite for 6months later will keep you posted on the mode of work.

Payrate: $45/hr on W2

Note: ***Looking for W2/1099 candidates only. H1b sponsorship/Transfer can be processed.

Exp: 4-7 years (Data Engineer -3 positions)

Qualification: BTech /Masters in IT or related background

Interview process: Total four rounds (1 HR; 2 Technical;1 management) will be taken by DEFTeam through video call. Candidates must share the screen and have proper eye contact with the panel during the whole interview process. All AI tools are strictly prohibited during the interview process.

JD for the Data Engineer(PL/SQL)

Looking for US Citizens/ GC holders/H1/EAD close to Boston location within the radius of 50 to 100 miles who can commute for 1 to1.30hr.

We are seeking highly skilled Data Engineers/Analysts to support the Discovery Phase of a large-scale legacy system modernization project. The role involves analyzing undocumented enterprise systems containing 500 database tables, 1600 stored procedures, legacy SSIS packages, Microsoft Access applications, and multiple interdependent systems. The selected candidate will play a critical role in extracting technical and business knowledge, documenting findings, and populating a metadata repository to enable future modernization and migration efforts.

Skills required:

• Strong expertise in SQL Server (T-SQL), schema design, and stored procedure analysis.
• Experience with Microsoft Access (queries, forms, reports, linked tables).
• Knowledge of ETL concepts, data lineage, and dependency analysis.
• Strong documentation and metadata management skills (data dictionaries, lineage diagrams, metadata repositories).
• Ability to design searchable, queryable outputs using Excel, metadata tables, or lightweight dashboards.
• Experience analysing large, undocumented legacy systems with complex interdependencies.
• Strong communication and collaboration skills for working with technical and business stakeholders.
• exposure to Power BI / Tableau for visualization of metadata and dependencies.
• Basic understanding on SSIS package analysis and reverse engineering is preferable.

Roles and Responsibilities:

• Perform detailed discovery and analysis of SQL Server databases, stored procedures, views, triggers, and functions.
• Reverse engineer SSIS packages, Access applications, and legacy ETL workflows to understand logic, dependencies, and data flows.
• Build and maintain metadata repository tables to capture discovered information about objects, dependencies, and transformation rules.
• Document application and system dependencies, identifying hidden or undocumented business logic.
• Develop data dictionaries, dependency mappings, lineage diagrams, and system inventories.
• Work with SMEs and stakeholders to validate discovered information and capture undocumented business rules.
• Deliver searchable, navigable documentation and dashboards (not static reports) for MassDOT review and audit
• Contribute to stakeholder interviews, workshops, and technical discovery sessions.
• Ensure deliverables are version-controlled, indexed, and reusable by client teams.

Initial contract for 3- 6months on 1099 or Corp to Corp later there is a probability of extension of contract or absorbed by the DEFTeam based on the performance of the candidates.