Informatica/Datastage Developer

Company: TechDigital Corporation
Location: Scottsdale
Posted on: March 26, 2020

Job Description:

Description Position Summary The ETL Developer III position within the Enterprise Data group is responsible for developing, configuring, coding, testing and debugging new software solutions. The ETL Developer III serves as a lead technical resource in the development and delivery of data-oriented solutions to support critical business needs. PRINCIPAL RESPONSIBILITIES bull Develops, tests and implements enterprise data movement (ETL and CDC) solutions. bull Addresses system defects and implements enhancements to existing functionality. bull Works with onshoreoffshore team to analyze, develop and improve ETL run times as well as produce accurate defect free code bull Troubleshoots issues with minimal guidance identifies bottlenecks in existing data workflows and provides solutions for a scalable, defect-free application bull Complies with Company policy and practices relating to the System Development Life Cycle. bull Participates in the definition of application scope and objectives through research and fact-finding bull Maintains productive working relationships with project sponsors and key systems users bull Develops effort estimates for assigned application software implementation activities bull Provides Tier 3 support and resolution of open IT issues escalated by IT Customer Support. bull Supports the production environment in the event of an emergency bull Provides performance tuning insight to project team and creates reusable objects and templates bull Performs other job-related duties as assigned or apparent. QUALIFICATIONS bull Experience in the design and development of ETL workflows. bull Experience working with job scheduler and monitoring tools. bull Experience working with relational database technology. bull Experience with SQL scripting languages (TSQL, PLSQL, etc.) bull Experience with SSIS bull Experience with large enterprise-grade data warehouse solutions. bull Extensive experience working with Informatica. bull Experience working with Change Data Capture (CDC) technology bull Experience with large database implementations (Oracle, SQL Server, Teradata, IBM, etc.) bull Experience with Big Data solutions including Hadoop bull Experience with Predictive Analytics and Forecasting bull Strong analytical skills and focus on bottom-line results bull Ability to conduct root cause analysis and performance tuning for complex business processes and functionality bull Ability to interact with IT and business users across the organization to resolve issues and provide solutions in a timely manner MINIMUM REQUIREMENTS bull Bachelor's degree in Computer Science, Engineering or Statistics (willing to accept foreign education equivalent). bull Minimum of 6 years of experience in IT operations and support performing ETL using the Informatica toolset. bull Minimum of 5 years of experience working on large data initiatives (?5 terabytes). bull Minimum 3 years of experience with at least two of the following SqlServer, Oracle, DB2, MySQL, Mark Logic, Denodo, AWS bull Minimum 3 years of experience with at least 2 of the following Informatica modules o Informatica PowerCenter, Informatica Developer (Includes IDQIDD) and CDC

Keywords: TechDigital Corporation, Scottsdale , Informatica/Datastage Developer, IT / Software / Systems , Scottsdale, Arizona