Data Warehouse Analyst

Requirements:

• 7 or more years of data warehousing and integration experience using Informatica PowerCenter and Snowflake.
• Proficiency in Informatica Intelligent Data Management Cloud (IDMC) tools including CDI, MI, and CAI.
• Experience with ETL/ELT processes, data extraction, transformation, and load across large datasets.
• Experience administering Snowflake Data Cloud and IDMC platforms including Secure Agent Infrastructure.
• Experience with relational databases such as DB2, SQL Server, Oracle, and Snowflake.
• Experience with Linux administration tasks including patching, filesystem management, and scripting.
• Strong communication skills for collaborating with technical and business stakeholders.

Responsibilities:

• Develop and maintain enterprise data warehouse models to optimize reporting and analytics.
• Design and implement ETL/ELT pipelines for data integration, cleansing, and transformation.
• Administer and monitor Snowflake Data Cloud and IDMC environments for performance and reliability.
• Prototype, build, and test dashboards and reports in Power BI and Cognos.
• Conduct performance tuning of Snowflake and Informatica IDMC environments.
• Document processes, standards, and metadata for enterprise data management practices.
• Provide consulting and support to business users on data usage, conflicts, and reporting needs.

Found 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.

Resourcesoft is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

For more information about Resourcesoft and our services, please visit our website.