Job Seekers, Please send resumes to resumes@hireitpeople.com

Must Have:

Minimum of 10 years ETL and Data Warehousing experience. Advanced ETL experience extracting data from databases, flat files, Excel, web applications, etc. Significant database tuning experience. Ability to lead testing initiatives for releases as needed. Experience in supporting multiple products/projects simultaneously. Proven ability to work with customers, managers and executives of varying levels of technical expertise while always maintaining a professional attitude. Complex problem solving and critical thinking skills. Excellent verbal and written communications including ability to translate business information into technical design specifications. Self-motivated, punctual, dependable with ability to prioritize work and succeed despite varying degrees of requirements in a remote work environment.

Nice to Have:

Bachelor's or master's degree in technology or business-related field. Master Data Management (MDM) admin and development experience with Informatica MDM 10.4. Power BI Premium administration, gateways, development, etc. Salesforce ETL Business analysis and project management skills. Drive data integration for the enterprise data warehouse and data marts.  Experience with retail industry sales, inventory, accounting and financial reporting data is preferred.  This position is a member of the Enterprise Data Team and assists in driving alignment of financial analysis and decision support.  As an expert in data integration, this individual will support the delivery of accurate and timely accountingfinancial data for strategic decision support.

Job Responsibilities:

Develop and support Informatica ETL jobs within a complex Enterprise Data Warehouse environment in support of financial users and analytical applications. Our DW environment includes 1TB SQL Server 2017-2019 plus numerous environments to integrate (SQL Server 2008r2-2019, Oracle, AWS PostgreSQL, Salesforce, XML, Excel, Azure and Google Big Data).  Ability to create Informatica integration task flows based upon user requirements and data model Advanced experience with T-SQL, PowerShell, JSON, XMLA, REST API calls, etc. to define methods and best practices for data extraction, interaction, and CRUD operations. Maintain, support and migrate legacy SSIS jobs to Informatica. Package deployments and migrate code between Development, Quality Assurance (QA), and Production environments. Test automation, troubleshooting ETL job functionality, validating data, as well as create test data and table structures through use of SQL. Configuration of the ETL environments to meet user, security, audit requirements. Develop a complete set of ETL documentation describing the current jobs, configuration, schedules, etc. of the system. Performance tune SQL statements executed by ETL code as required for tuning of Informatica, including monitoring, standards, tuning metrics, and alert thresholds. Perform source system analysis as required. On-call DBA rotation to assist with after-hours database issues and related deployments. Assist with upgrades and migrations with SQL Server and related software tools.