ETL Developer Analyst - Solution Analyst

Are you an experienced, passionate pioneer in technology - a solutions builder, a roll-up-your-sleeves technologist who wants a daily collaborative environment, think-tank feel and share new ideas with your colleagues - without the extensive demands of travel? If so, consider an opportunity with our US Delivery Center - we are breaking the mold of a typical Delivery Center.

Our US Delivery Centers have been growing since 2014 with significant, continued growth on the horizon. Interested? Read more about our opportunity below...

Work you'll do/Responsibilities

Not only will candidates be joining a project team, but they will also be joining a team of resources dedicated to delivering client engagements from an off-site location focused on common tools, technologies, and methodologies.

The successful candidate will work with the Deloitte team to implement, maintain, and enhance its enterprise-level data architecture using Informatica Power Center and Power Exchange tool.

Work with Business Analysts and Data Modelers to understand requirements.

Design and develop sustainable database ETL applications to support those requirements.

Create technical design documents that capture source to target mapping, define transformation algorithms, and document data quality rules.

Required Qualifications

• 1+ Years of experience with ETL, preferably Informatica.

• Bachelor's degree, preferably in Computer Science, Information Technology, Computer Engineering, or related IT discipline; or equivalent experience

• Must have experience moving data between systems

• 1 + Years of experience in data engineering with an emphasis on data analytics and reporting.

• Must have experience maintaining an Enterprise Data Warehouse (EDW) in support of business intelligence analytics

• 1 + Years of experience developing and maintaining data warehouse objects

• Experience working within an Extraction Transform Load (ETL) software

• Must have experience working within Data Warehouse environments

• Ability to travel 10%, on average, based on the work you do and the clients and industries/sectors you serve

• Must live a commutable distance to one of the follow cities or be willing to relocate to one of the following USDC locations: Gilbert, AZ; Lake Mary, FL; Mechanicsburg, PA.

• No sponsorship available for this role

• Must be in your designated office location 10%-30% of each work week

Preferred Qualifications

• Experience with Object-Oriented methodologies, Test-First Development, Continuous Integration, and Agile Development processes
• Strong SQL skills with the ability to tune and optimize complex queries
• Experience with Unix/Linux (Specifically RHEL)
• Experience in software development using Oracle and XML
• Relational databases
• Experience at physical database modeling