Top Consulting Data Engineering Jobs in Boston, MA

The PostgreSQL Database Developer will manage database environments, support migration from Oracle to PostgreSQL, and ensure database performance and security.

Develop and support Informatica ETL solutions (development 70%, support 30%). Build error-handling frameworks with Autosys/Control-M/Tidal, configure PowerCenter Grid, use IDQ and MDM, perform performance tuning, Unix scripting, Teradata/SQL development, and data cleansing/profiling.

Lead development, validation, and operationalization of P&C actuarial models and workflows. Convert actuarial requirements into production-ready code, leverage cloud/AI tools, validate data pipelines, produce client-ready reporting, and liaise between actuarial SMEs and engineering teams while contributing to practice tooling and business development.

Administer and maintain IBM DataStage environments: create/manage projects, manage engine and WAS services, install patches, perform server restarts and maintenance, script in Unix, plan capacity, tune performance, manage code migration/version control, and coordinate with clients and offshore teams.

Senior Informatica ETL consultant responsible for designing and developing ETL pipelines, data modeling (Kimball), Oracle performance tuning, and using Erwin. Tasks include ETL tuning, implementing Lookup/Joiner/Hash and other transformations, SQL join types, explain plans, function-based indexes, shell scripting, and applying performance hints. Strong communication skills required. Contract role (~2+ months).

Design, develop and optimize Informatica ETL mappings and workflows for banking data. Perform data cleansing/matching (IDQ), performance tuning, Unix scripting, and job scheduling (Control-M). Train and advise developers on ETL best practices, work with Oracle 11g, and support monitoring, exception handling, and reporting.

Design, develop, test, and maintain ETL processes using Informatica. Create data mappings and technical specifications, schedule and support production ETL jobs, perform root cause analysis, validate data flows, and collaborate with analysts and metadata management to handle large data volumes and resolve data issues.

Lead end-to-end delivery of modern data platforms for private equity clients: manage scope, schedule, budget, and multi-workstream agile teams; enforce medallion/lakehouse architectures, data quality, CI/CD, and governance; oversee Snowflake and Azure data services; act as primary client executive, manage SOWs and staffing, and enable repeatable delivery playbooks. Drive measurable business outcomes and platform stability, security, and cost efficiency.

Develop and maintain SQL Server solutions including migration from SQL Server 2012 to 2014. Work with DTS packages and design, build, and support SSIS ETL processes and SSRS reports.

Oversee client proposals and projects, leveraging coding skills for data processes, mentoring teams, and identifying growth opportunities in life sciences.