ETL Developer III Lead Hadoop - Jobs in Wilmington, DE - 526589

TD Bank
Job Summary
  • Skills Developer, SQL, Windows, Oracle, PL/SQL, VBScript, Perl, DOS, UNIX, Web, XML, OLTP, OLAP, SAP, Application, System, Development, HTML, Desktop
  • Job Type
    Full Time
  • Salary
    N/A
  • Telecommuting
    Work from home not available Travel not required



Job Description

TD Description About TD Bank, Americas Most Convenient Bank TD Bank, Americas Most Convenient Bank, is one of the 10 largest banks in the U.S., providing more than 8 million customers with a full range of retail, small business and commercial banking products and services at approximately 1,300 convenient locations throughout the Northeast, Mid-Atlantic, Metro D.C., the Carolinas and Florida. In addition, TD Bank and its subsidiaries offer customized private banking and wealth management services through TD Wealth, and vehicle financing and dealer commercial services through TD Auto Finance. TD Bank is headquartered in Cherry Hill, N.J. To learn more, visit Find TD Bank on Facebook at /TDBank and on Twitter at /TDBankUS. TD Bank, Americas Most Convenient Bank, is a member of TD Bank Group and a subsidiary of The Toronto-Dominion Bank of Toronto, Canada, a top 10 financial services company in North America. The Toronto-Dominion Bank trades on the New York and Toronto stock exchanges under the ticker symbol \ TD\ . To learn more, visit Job Description The Extraction Transformation Load Developer III analyzes, designs, and develops extraction, transformation, and load (ETL) processes that automate the movement of data between systems and data stores. The Extraction Transformation Load Developer III implements bulk ETL and real-time data integration solutions using enterprise data management tools, with particular emphasis on implementing best practices in the design, deployment and management of scalable, reusable and extensible integration components.\tWorks collaboratively within a solution team to design and implement ETL solutions that are of high quality and cost advantage and allow TD Bank, Americas Most Convenient Bank to be the better bank in every market in which it competes\tDesigns complex ETL processes that are high in performance and meet enterprise standards for availability and fault tolerance in a secure environment\tAssists team members in performance tuning and troubleshooting ETL processes under development and in production as needed\tDesigns and develops ETL processing routines that consume or produce complex XML or Mainframe (EBCDIC) datasets and/or services\tParticipates in integration design sessions by sharing knowledge of data elements from analysis phase to data structure designers and ensures all elements are accounted for through the final design\tParticipates in the design and development of large-scale data marts or changes to enterprise data warehouses\tDevelops interfaces to enterprise metadata environments and ensures ETL metadata flows into the metadata environment accurately as part of new ETL development\tDefines and ensures adherence to best practices for ETL development into standard warehouse models and dimensional data structures\tReviews documentation for ETL processes and ensures consistency of implementation\tProvides leadership to other ETL developers on projects, processes and/or problem resolution and/or is a senior role delivering on all aspects of research, analysis, design, support and testing\tProvides assistance to team members and may assume a lead role within projects\tAccountabilities are moderately complex and broad in scopeJob Requirements \t4 year Degree or equivalent experience\t5+ years of related experience\t5+ years of experience in data-base oriented development in an enterprise environment\tDemonstrated skills in data structure analysis, and development of stored procedures, SQL, and scripting in support of data transformation and delivery\tDemonstrated skills in development and performance optimization of SQL queries\tStrong skills in design and development of relational data structures\tProven scripting skills in both Windows and Unix environments\tExtensive experience in designing and implementing ETL processes in enterprise environments\tProven hands-on experience utilizing SQL, Oracle PL/SQL and SQL Loader, Microsoft DTS and T-SQL, VBScript, and Perl, DOS or UNIX shell scripting for manipulating large volumes of data to and from enterprise systems, as well as experience manipulating flat-files, EBCDIC to ASCII conversion, and non-relational data\tExperience with Web development and Web Services is a plusInclusiveness At TD, we are committed to fostering an inclusive, accessible environment, where all employees and customers feel valued, respected and supported. We are dedicated to building a workforce that reflects the diversity of our customers and communities in which we live in and serve, and creating an environment where every employee has the opportunity to reach their potential. If you are a candidate with a disability and need an accommodation to complete the application process, email the TD Bank US Workplace Accommodations Program at USWAPTDO@td.com . Include your full name, best way to reach you, and the accommodation needed to assist you with the application process.EOE/Minorities/Females/Veterans/Individuals with Disabilities/Sexual Orientation/Gender Identity.
Login & Apply

Similar Jobs