Calance Job Opening

Job TitleInformatica ETL Developer - ID:33062
Duration6 Months
Start DateASAP
Job Skills• 3+ years experience in designing and developing ETL solutions.
• 2+ years experience using Informatica PowerCenter.
LocationDenver, CO
Date Posted06/08/2020

Generated button

ETL Developers

The ETL Developer is responsible for supporting the information management architecture of the Data Warehouse. This role is responsible for extracting, transforming and loading data into data staging, and the data warehouse. This role will work closely with the data architect, data modeler, data analysts and other project team members to understand requirements regarding ETL design flows and data integration. They will collaborate on definition, development, and maintenance of standards and processes. The ETL Developer will develop ETL solutions following the well-defined data warehouse design and development best practices.

Skills &Essential Functions/Responsibilities:
• Develop efficient and high performing ETL solutions using Informatica PowerCenter (Designer, Monitor, Repository Manager & Active Batch Workflow manager).
• Design, develop, test and performance tune complex mappings, transforms, aggregations, joins, enrichment, validations for target data underpinnings.
• Participate in design review sessions and peer ETL reviews.
• Assess and profile source and target data (data structure, quality, completeness, schema, nulls, etc.) and requested business use cases.
• Summarizes testing and validation results and is able to communicate and make recommendations/decisions on the best course of action to remediate.
• Participate in agile work environment, attending daily scrum meetings.

Specific Job Skills and Experience:
• 3+ years experience in designing and developing ETL solutions.
• 2+ years experience using Informatica PowerCenter.
• 3+ years working knowledge in a Data Warehouse/BI environment.
• Strong RDBMS experience; Oracle PL/SQL, SQL Server & Netezza.
• Strong SQL skills including complex SQL constructs, DDL generation.
• Windows batch PowerShell scripting and/or UNIX shell scripting experience.
• Experience with Atlassian JIRA & Confluence preferred.
• Demonstrated excellent organizational, analytical, writing, problem solving and interpersonal skills.

Job Conditions:
• Job requires hours that may exceed 8 hours per day and/or 40 hours per week during times of peak activity. Moderate to high job pressure exists in the balancing of several projects with conflicting and sometimes changing deadlines.
• Less than 5% travel required

Send To Email / Remind Me



Mission Viejo, CA ~ (800) 732-4680
Atlanta, GA ~ (866) 951-1151

Calance is a global IT Services firm specializing in end-to-end solutions for Development, Managed Service,
Security, SAP, Project Control Integration and IT Staffing.Operating in the United States and India,
Calance helps clients bring their ideas and strategies to life through talent, technology and tenacity.

2020 All rights reserved.