Informatica/Snowflake Data Engineer

• Design, develop, and maintain ETL workflows using Informatica PowerCenter, including mappings, sessions, and transformations.
• Ingest data from diverse source systems (flat files, APIs, relational databases, mainframe extracts) into Oracle and Snowflake environments.
• Perform source-to-target mapping, data requirements gathering, and documentation of data flow and design specifications.
• Troubleshoot and resolve data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
• Optimize Oracle SQL/PL-SQL queries and Snowflake schemas for performance and scalability.
• Coordinate batch data loads using job scheduling/orchestration tools such as Control-M, Autosys, or Informatica scheduler.

• 8 or more years of experience as a Data Engineer/ETL developer designing, developing, and supporting enterprise data integration solutions.
• Proficiency in Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations.
• Experience with Oracle SQL/PL-SQL, including stored procedures, packages, and ETL query performance tuning.
• Experience with Snowflake, including data loading, schema design, and query performance optimization.
• Experience with Informatica Cloud Data Integration for cloud-based ETL/ELT development and source-to-target mapping.
• Excellent analytical and communication skills, with experience collaborating across structured SDLC environments and business/technical stakeholders.

Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling.