ETL Developer
CN-tec - Phoenix, AZ

This job posting is no longer available on Dice. Find similar jobs: ETL Developer jobs - CN-tec jobs

CN-tec is a leading provider of strategic staffing and Information Technology consulting firm for premier organizations. We are currently hiring for the following opportunityThis position is for an ETL developer for Informatica, which is a more specific and different skillset. TOP 3 SKILLS Informatica Candidates should have - bullInformatica workflow, mapping, transformation and scheduling expertise bullData Quality identification and remediation bullUnderstanding of ETL and Data Warehousing processes ETL Developer Responsibilities The ETL Developer is an integral member of the Security Data Intelligence (SDI) team and responsible for data collection, aggregation and loading. The Developer will report to the Director, SDI and will work in collaboration with data architects, developers, and key stakeholders to design robust, scalable data warehouse, data extraction, transformation and loading solutions.

This position will be part of a team responsible for the design and implementation of the Information Security Data Warehouse environment and related source databases. In addition, the successful candidate will possess knowledge of GreenPlum, Pivotal, and Informatica. This position demands a well-organized, action oriented team player with the ability to prioritize daily work and work on multiple initiatives simultaneously. Strong interpersonal communications skills are required.

Essential Functions bullCreation of Informatica workflows, data loads, transformations and scheduling bullProvide expertise in ETL and data warehousing processes bullIdentify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity bullGather, analyze and implement data models for data warehouse and data marts bullMonitor systems capacity and performance, plans and execute disaster recovery procedures. bullAnalyze data and metrics to detect underlying trends and patterns. bullTranslate requirements into data warehouse design specifications. bullUnderstand and leverage Hadoop technology in support of data warehouse.

bullEnsure data standards are reused and enforced across all data-driven initiatives. bullEnsure issues are identified, tracked, reported on and resolved in a timely manner. bullPlan, coordinate and implement security measures to safeguard information in data warehouse against accidental or unauthorized damage, modification or disclosure. Critical Skills bullStrong work prioritization, planning, and organizational skills.

bullBe able to collaborate effectively and work closely within a coordinated team environment and maintain composure while dealing with time sensitive deadlines or challenging people bullAble to learn and follow documented processes and procedures while identifying and implementing improvements in such processes. bullRecognize and deal appropriately with confidential and sensitive information. bullStrong analytical and problem solving skills with ability to clearly articulate solution alternatives. bullProvide recommendations for application design and implement technical solutions bullExperience supporting a production data warehouse environment bullIn depth knowledge of the implementation of technology policies and procedures Technical Skills bullETL experience by creating mappingsprocesses using Informatica is required bullPostgreSQL Server Query creation and analysis bullSQL scripting, stored procedures and scheduled jobs bullExperience with data mining, monitoring, and tuning with very large data sets.

bullHadoop knowledge is preferred bullVersed in Data Warehousing methods, models, and technologies is preferred bullAbility to design and normalize relational databases bullGood troubleshooting, analytical and problem solving skills bullStrong understanding of Microsoft Office tools, including Microsoft Visio ETL, SDI, Visio, SQL, Hadoop

Dice - 6 months ago - save job - block
Recommended Jobs
Junior Data Integration Specialist
Safeway Inc - Phoenix, AZ
Safeway Corp. - 8 days ago

Sr Software Developer
Universal Technical Institute - Scottsdale, AZ
Universal Technical Institute - 12 days ago

IT Senior Architect
GM - Phoenix, AZ
General Motors - 20 days ago