These DH positions are focused on Informatica with ETL, Informatica Cloud experience is a huge plus. Will be leading the ETL portion of the ERP rollout. For the Lead role candidates want to see data warehouse knowledge. Will sponsor H1b. Must be Arizona resident but will be 100% remote. Top 3-5 Technical Skills Needed: Informatica, PowerCenter, SQL, Datawarehousing - experience in a large DW Work Authorization Requirements: Will sponsor H1b if necessary
The ETL Developer/Engineer III position within the Enterprise Data group is responsible for developing, configuring, coding, testing and debugging new software solutions. The ETL Developer/Engineer III serves as a lead technical resource in the development and delivery of data-oriented solutions to support critical business needs.
Develops, tests and implements enterprise data movement/migration (ETL and CDC) solutionsAddresses system defects and implements enhancements to existing functionalityComplies with Company policy and practices relating to the System Development Life CycleDevelops effort estimates for assigned application software implementation activitiesDevelops project plans for application software implementation activities of low to medium level of complexity.Develops strong software vendor and business partner relationships to resolve problems and coordinate the delivery of IT products and services.Maintains productive working relationships with project sponsors and key systems usersMentors junior developers in development techniques and standardsParticipates in the definition of application scope and objectives through research and fact findingReviews and approves code of other developersTroubleshoots issues with negligible guidance, identifies bottlenecks in existing data workflows and provides solutions for a scalable, defect-free applicationWorks with data architects and staff engineers to develop data designs and standardsWorks with onshore/offshore team to analyze, develop and improve ETL run times as well as produce accurate defect free codeProvides Tier 3 support and resolution of open IT issues escalated by IT Customer SupportSupports production environment in the event of issuesProvides performance tuning insight to project team and creates reusable objects and templatesPerforms other job-related duties as assigned or apparent
5 years of experience working with dimensional database modeling and Slowly Changing DimensionsExperience in the design and development of ETL workflowsExperience working with job scheduler and monitoring toolsExperience working with relational database technologyExperience with SQL scripting languages (SSIS, PL/SQL, etc.)Experience with large enterprise-grade data warehouse solutionsExtensive experience working with Informatica Power CenterExperience with Informatica Cloud is a plusExperience working with Change Data Capture (CDC) technologyExperience with large database implementations (Oracle, SQL server, Teradata, IBM, etc.)Experience with Big Data solutions including HadoopExperience with Predictive Analytics and ForecastingStrong analytical skills and focus on bottom-line resultsConduct root cause analysis and performance tuning for complex business processes and functionalityInteract with IT and business users across the organization to resolve issues and provide solutions in a timely manner
Bachelors degree in Computer Science, Engineering or Statistics (willing to accept foreign education equivalent).Minimum of 6 years of experience in IT operations and support performing ETL using the Informatica tool set.Minimum of 5 years of experience working on large data initiatives (5 terabytes).Minimum 3 years of experience with at least three of the following: Oracle, DB2, SQL Server, Teradata, IBM, and Informatica modules (IDQ, PowerCenter, MDM, and ETL)Minimum 3 years of experience with at least two of the following: SQLServer, Oracle, DB2, MySQL, MarkLogic, Denodo, AWSMinimum 3 year of experience with at least 2 of the following Informatica modules:PowerCenterCDCETL workflowsIDQMDM Hub: Configuration, Validation rulesIDD: Configuration, Validation rules