Vacancy expired!
- Design, develop, test, and maintain data warehouse subject areas for the gift management platform.
- Design and build integrations supporting standard Kimball data warehousing objects (type-2 dimensions, aggregations, star schemas, etc.)
- Participate in design of new or changing mappings and workflows with the team.
- Collaborate with architects, product owners and functional leads in areas such as Security, Business Intelligence, and Data Governance.
- Iterate and improve on testing (Unit Tests, Integration Testing and Automated Testing).
- Create and modify technical specifications and end user documentation.
- 7+ years of experience in data warehousing projects using Informatica PowerCenter to create Mappings, Mapplets, Workflows, and Worklets
- 7+ years of experience in ETL development on a RDBMS (Microsoft SQL Server, Oracle, and Teradata preferred), including development of stored procedures and database functions
- 3+ years of UNIX experience, including scripting (kshell preferred)
- 1+ year of experience using Informatica Intelligent Cloud Services, Informatica Data Quality, and/or Informatica Managed File Transfer
- Experience performance tuning Informatica and database objects
- Experience using APIs and flat file/XML sources in Informatica integrations
- Experience using version control systems for the ETL repository and supporting code, with specific emphasis on Informatica version control and deployment groups
- Advanced SQL skills including data profiling, data analysis and interpretation, and building advanced data manipulation macros
- Experience creating test cases and writing SQL to perform Unit Testing and Integration Testing
- Thorough understanding of OLTP, OLAP and the software development lifecycle (SDLC)
- Outstanding written/verbal communication skills
- Experience with Teradata data warehouses, including tools like BTEQs, MultiLoad & FastLoad
- Experience with AWS Redshift
- Experience with scripting in PowerShell and/or Python
- Experience with SDLC tooling such as Atlassian Jira and HP ALM
- Experience with cloud-based data integration platforms in AWS or Azure
- Experience with real-time data streaming and event-driven architectures
- Experience in high-complexity projects with cross-team dependencies
- Exposure to automation testing frameworks
Vacancy expired!