ETL Developer Details

ETL Developer

DMI - Remote

Employment Type : Full-Time

About DMI:

DMI (Digital Management, LLC.), the world’s first end-to-end mobility company, combines all the skills and services necessary to deliver mobile enterprise solutions. Built to reinvent business through mobility, DMI has expertise in mobile strategy, UX, web, and app development, omni-channel commerce, brand and marketing, IoT and big data analytics, and secure device and app management. The company’s unique, integrated approach to mobility has resulted in dramatic growth as well as an expanding client base, which includes hundreds of Fortune 1000 commercial clients and all fifteen U.S. Federal Departments. DMI is headquartered in Bethesda, MD, with satellite offices around the world. The company was named one of the 2018 Top Workplaces in the Washington, DC area by The Washington Post and received Inc. Magazine’s Hire Power Award as one of the top 100 Private Job Creators in the US. Additional information is available at www.dminc.com and on LinkedIn, Twitter, Facebook, and Instagram.

About the Opportunity: DMI is Seeking an experienced ETL Developer
Location: Remote
Minimum Citizenship Requirement: US Citizen/GC
The Opportunity
automotive financial services company powered by a top direct banking franchise with the opportunity, experience and people to redefine the industry.

The automotive services business offers a full suite of financing products and services, including new and used vehicle inventory and consumer financing, leasing, inventory insurance, commercial loans and vehicle remarketing services. the company's direct banking subsidiary and member FDIC, offers an array of deposit products, including certificates of deposit, savings accounts, money market accounts, IRA deposit products and interest checking. The Corporate Finance unit provides financing to middle-market companies across a broad range of industries.

Business Unit/Enterprise Function Description

The IT organization is focused on supporting and improving the position of its industry-leading business franchises through cost effective, innovative IT solutions as well as overseeing critical functions that enable the day-to-day operations of the entire Ally Financial enterprise. IT is also responsible for the administration and execution of information protection, disaster recovery and IT risk management.

Position Description

Position will be responsible for the integration, expansion, and support of the North American Automotive and Insurance data warehouse solutions. The Data Warehouse Developer is responsible for interpreting, organizing, designing, executing, and coordinating technical assignments within the Data Warehouse.

Candidates must have hands on experience with Oracle 10g or higher and Data Stage. Applicant will work closely with a multitude of groups throughout the organization, which will require the ability to communicate with associates with backgrounds ranging from DB development, Application Support, Networking, Operating System Administrators, Software Development Managers, and Business users from a wide range of operating units.

Job Responsibilities

• Lead evaluation and recommendations efforts for future data architecture structure and standards.
• Recommend the modeling approach for projects.
• Lead design of high-level conceptual and logical models that facilitate a cross-system/cross functional view of data requirements.
• Develops Extract, Transform, and Load (ETL) Specifications to support data conversion and integrations.
• Conducts data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks.
• Develop code for Data Warehouse in support of business intelligence projects
• Ensure consistency of Logical and Physical Data Models for all Data Warehouse applications
• Possess a broad understanding of multiple technologies, including DBMS, ETL, Reporting, OLAP, performance tuning for high-end hardware and storage
• Maintain responsibility for global data definitions used in the Data Warehouse
• Integrate data from multiple source systems into Data Warehouse
• Adhere to standards for Data Warehouse, including security, archiving, backup, and recovery
• Participate in architectural decisions for data transitions from source to staging to ODS to EDW
• Communicate regularly and effectively with team members and supervisors
• Identify system and process issues then engage the team in problem solving
• Plan and participate in cross-training with team members
• Develop technical skills comparable to other developers
• Fill in for other developers as requested
• Recognize accomplishments and contributions of team members
• Promote an image of a high quality organization through expertise and responsiveness
• Take responsibility for assignment completion and follow-through
• Provide high level of customer service
• Establish and maintain good working relationships with internal and external customers
• Facilitate satisfactory communication and resolution of problems

Qualifications:Qualifications

• 8+ years of IT experience
  
  • 5+ years of Data Warehouse experience
  • 5+ years of experience with extraction, transformation, and loading tools and development of strategies for loading data into production enterprise Data Warehouse
  • 5+ years of Data Warehouse development experience
  • 3+ years of production experience in an Oracle enterprise Data Warehouse
  • 3+ years of Data Stage ETL experience
  • Ability to effectively present information and respond to questions from executives, directors, managers, clients and customers
  • Must have dimensional modeling skills at the conceptual, logical, and physical levels, and experience documenting data models
  • Ability to work in a rapid-development environment
  • Ability to work closely with customers in analyzing requirements
  • Ability to work flexible hours
  • Project management and technical leadership
  • Strong communication skills, written and spoken
  • Comfortable working independently, but has experience working in a team environment
  • Skills establishing and maintaining effective working relationships with clients and staff
  • Ability to read, write, speak, and understand English required
  • Can discern when escalation is needed
  • Experience in Agile / SCRUM with sprint methodologies preferred
  • Finance or Automotive Industry experience preferred
  • BS and 6 + years or equivalent

Working at DMIDMI is a diverse, prosperous and rewarding place to work. Being part of the DMI family means we care about your wellbeing. As such, we offer a variety of perks and benefits that help meet various interests and needs, while still having the opportunity to work directly with a number of our award winning, Fortune 1000 clients. The following categories make up your DMI wellbeing:

• Community – Blood drives, volunteering opportunities, Holiday parties, summer picnics, Tech Chef, Octoberfest just to name a few ways DMI comes together as a community.
• Convenience/Concierge - Virtual visits through health insurance, pet insurance, commuter benefits, discount tickets for movies, travel and many other items to provide convenience.
• Development – Annual performance management, continuing education and tuition assistance, internal job opportunities along with career enrichment and advancement to help each employee with their professional and personal development.
• Financial – Generous 401k match for both pre-tax and post-tax (ROTH) contributions along with financial wellness education, EAP, Life Insurance and Disability help provide financial stability for each DMI employee.
• Recognition – Great achievements do not go unnoticed by DMI through Annual Awards ceremony, service anniversaries, peer-to-peer acknowledgement through Give-A-Wow, employee referral bonuses.
• Wellness – Healthcare benefits, Wellness programs, Flu Shots, Biometric screenings, on-site lactation rooms provide employees with several wellness options.

Employees are valued for their talents and contributions. We all take pride in helping our customers achieve their goals, which in turn contributes to the overall success of the company. The company does and will take affirmative action to employ and advance in employment individuals with disabilities and protected veterans, and to treat qualified individuals without discrimination on the basis of their physical or mental disability or veteran status. DMI is an Equal Opportunity Employer Minority/Female/Veterans/Disability. DMI maintains a drug-free workplace.
***************** No Agencies Please *****************
Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.