Informatica Developer
Requirements:
- 8+ years in ETL development using Informatica Power Center or IICS
- Proficiency in Oracle or Snowflake for efficient SQL script creation
- Experience in acquiring and integrating data from Oracle, SQL Server, Excel, Access, and PDFs
- Proficiency in transforming data for Tableau visualizations
- Experience in writing Python scripts for data transformation and automation
- Proficiency in technical system analysis within performance/data warehouse projects
- Experience with Java and JavaScript for backend and frontend development tasks
- Proficiency in JIRA for managing agile sprint tasks and backlog items
- Experience developing CI/CD pipelines using GitHub and Git Actions
- Proficiency in Mulesoft for API development and integrations
- Experience with SAS Viya administration and reporting workflows
- Proficiency in creating and maintaining code in C# for system extensions
- Proficiency in technical writing and diagramming using Visio, Erwin, and Office tools
- Excellent oral and written communication skills
Responsibilities:
- Lead an agile data engineering team to deliver robust integration solutions
- Experience in automating ETL processes and managing agile ceremonies
- Design and implement complex SQL scripts to support dimensional models
- Experience in creating materialized views and optimizing Oracle/Snowflake queries
- Develop Informatica workflows to pull and transform data from diverse sources
- Experience with automation for large-scale data ingestion tasks
- Validate and verify SQL, Informatica automation, and data views
- Experience in implementing automated testing and quality control scripts
- Collaborate on integration hub infrastructure setup and enhancement
- Experience in requirement gathering and translating them into functional mockups
- Participate in sprint planning, demos, and retrospectives with cross-functional teams
- Experience with agile development tools and collaborative delivery processes
- Document systems, processes, and architecture with clarity and accuracy
- Experience in aligning technical documentation with business needs and standards
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.
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.
Requirements:
- 8+ years in ETL development using Informatica Power Center or IICS
- Proficiency in Oracle or Snowflake for efficient SQL script creation
- Experience in acquiring and integrating data from Oracle, SQL Server, Excel, Access, and PDFs
- Proficiency in transforming data for Tableau visualizations
- Experience in writing Python scripts for data transformation and automation
- Proficiency in technical system analysis within performance/data warehouse projects
- Experience with Java and JavaScript for backend and frontend development tasks
- Proficiency in JIRA for managing agile sprint tasks and backlog items
- Experience developing CI/CD pipelines using GitHub and Git Actions
- Proficiency in Mulesoft for API development and integrations
- Experience with SAS Viya administration and reporting workflows
- Proficiency in creating and maintaining code in C# for system extensions
- Proficiency in technical writing and diagramming using Visio, Erwin, and Office tools
- Excellent oral and written communication skills
Responsibilities:
- Lead an agile data engineering team to deliver robust integration solutions
- Experience in automating ETL processes and managing agile ceremonies
- Design and implement complex SQL scripts to support dimensional models
- Experience in creating materialized views and optimizing Oracle/Snowflake queries
- Develop Informatica workflows to pull and transform data from diverse sources
- Experience with automation for large-scale data ingestion tasks
- Validate and verify SQL, Informatica automation, and data views
- Experience in implementing automated testing and quality control scripts
- Collaborate on integration hub infrastructure setup and enhancement
- Experience in requirement gathering and translating them into functional mockups
- Participate in sprint planning, demos, and retrospectives with cross-functional teams
- Experience with agile development tools and collaborative delivery processes
- Document systems, processes, and architecture with clarity and accuracy
- Experience in aligning technical documentation with business needs and standards
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.
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.