Jobs
>
Plano

    Senior ETL Developer - Plano, United States - TEKsystems

    TEKsystems background
    Description

    Job Description

    Job Description
    24 month Contract


    Top 3 Skills:
    1)
    Datastage Development
    2)
    Unix Scripting Experience
    3) Conceptual knowledge of
    Data Modeling and DW concepts

    1. Skills
    a.
    ETL DataStage and/or data integration (5 years or more)
    b.

    SQL Programming
    (5 years or more)
    c. Shell scripting experience
    d. Data Warehouse Design and Implementation
    e. Hadoop and Big Data implementation (optional)
    f. Azure experience (plus)


    1. Tools
    a. Databases (DB2, Oracle,
    SQL Server, Taradata, Netezza)
    b. SAP Business Objects (BO), Microsoft SSRS, Tableau
    c. ETL tools (DataStage, Informatica, Microsoft SSIS or similar tools)
    d. Reporting tools (SAP Business Objects, Miccrosoft SSRS, Power BI, Tableau)


    1. Responsibilities
    a. Provide programming services to FASG IT D&A work streams
    b. Provide guidance to junior team members
    c. Understand business priorities and requirements and translate the requirements into technical designs
    d. Deliver all assign tasks on-time with high quality


    Job Description:


    An ETL senior developer is responsible for developing data flow architectures (designed by an ETL Architect) within various integration patterns for loading analytical structures (DW, DM, ODS etc.), or integrating and migrating applications (EAI).

    In doing so, he/ she leverages industry-strength data movement technologies such as InfoSphere DataStage, Informatica PowerCenter or others.

    The person must be able to:

    • Configure and customize the chosen ETL tool for client installations.
    • Optimally leverage the ETL tool components for developing efficient solutions for data management, conversion, migration and integration. Develop overall design and determine division of labor across various architectural components (for example ETL tool vs. database).
    • Deploy and customize Standard Architecture components.
    • Mentor client personnel. Train junior staff on the Integration Methodologies and related supplemental solutions.
    • Support development of task plans including schedule and effort estimation, under the guidance of an ETL architect.

    Minimum Requirements:

    Supplier resources will have the following skills / experience / background:


    • Advanced ETL experience using either Informatica or Data Stage
    • Strong individual contributor in complex Data Warehousing and Business Intelligence project implementations; leadership experience a plus
    • Proven experience in working directly with business customers
    • Strong
      SQL skills including complex query building and query performance tuning
    • Data analysis skills - ability to dig in and understand complex models and business processes
    • UDB,
      SQL Server, Oracle, My
      SQL, Netezza or Teradata database experience
    • Strong UNIX shell scripting skills (primarily in COBOL, Perl)
    • Strong understanding of Data warehousing design concepts/skills
    • Data profiling experience
    • Defining and implementing data integration architecture
    • Strong ETL performance tuning skills. The ability to quickly and efficiently analyze and resolve performance issues within variety of operational environments
    • Demonstrated ability to analyze data concerning production volumes, batch schedules, and i/o statistics
    • Proven problem-solving / problem resolution abilities.
    • Microsoft Office (Outlook, Excel, Word, PowerPoint, Access)

    Required:
    ETL experience using either Informatica or Data Stage or an equivalent technology

    SQL
    UNIX shell scripting


    Other information:

    Sources:
    DB2, Relational DBs


    Targets:
    Netezza, Hadoop


    • 2 week Agile sprints
    • Straight ETL Development, no interaction with business
    • Conceptual knowledge of Data modeling and DW'ing is big plus
    o Erwin = for data modeling

  • Diverse Lynx

    ETL Developer

    3 weeks ago


    Diverse Lynx Plano, United States

    10+ Yrs Relevant IT software experience (Technical) in ETL Datastage or any other cloud based ETL Tool development Experience with databases like Snowflake (Cloud DB), Oracle, Netezza, MS SQL Server 2012+, DB2 and MS AccessExperience with job automation & scheduling software (Con ...

  • Mando Technologies

    ETL Developer

    3 days ago


    Mando Technologies Plano, United States

    Looking for Mid level Data Engineers with 8+ years ETL Experience for financial client in Dallas, TX · Location: Plano, TX (Onsite Day 1) · Duration: 1 year and may get extended · Must-Have: · Experience designing and developing data integration solutions using ETL tools (Ex: Da ...


  • Syntricate Technologies Plano, United States

    per - Snowflake exp. || Plano, TXContract · Job Title: ETL Datastage Developer - Snowflake exp · Location: Plano, TX · Duration: Contract · Job Description: · Required Skills:10+ Yrs Relevant IT software experience (Technical) in ETL Datastage or any other cloud based ETL Tool de ...

  • Fults & Associates LLC

    ETL / SQL Developer

    3 weeks ago


    Fults & Associates LLC Plano, United States

    ***WE ARE NOT ABLE TO WORK WITH SPONSORS AT ANY POINT. MUST NOT REQUIRE SPONSORSHIP OF ANY KIND*** · SUMMARY · Technical position to · support the data management aspects of the organization . This is an on-site · (non-remote) · position based at our Plano, TX headquarters l ...


  • ICONMA Plano, United States

    ResponsibilitiesParticipates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications. · Creates ETL Mappings, Mapplets, Workflows, and Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation. · Design ...

  • Real Time Resolutions

    ETL Developer

    3 days ago


    Real Time Resolutions Dallas, United States

    About Us: · Real Time Resolutions is a dynamic and innovative organization in the financial sector. We are currently seeking a motivated and analytic ETL Developer to join our Data Services team. This is a unique opportunity to contribute to both technical and business aspects w ...

  • Verdant Infotech Solutions

    ETL Developer

    2 weeks ago


    Verdant Infotech Solutions Lewisville, United States

    Formal Job Title: ETL DeveloperLocation: must be local to Texas/no relocationTerms: 1+ Year ContractInterview Process: 2 rounds Status: No H1B Please send DOB (no year), last four of SSN, Linkedin, and times available for a call*Candidate must be on your companies W2 Required Ski ...

  • SPECTRAFORCE

    ETL Developer

    3 weeks ago


    SPECTRAFORCE Irving, United States

    Position: ETL Developer · Location: Irving, TX - hybrid 3 days onsite · Type - Direct hire · Client is seeking qualified applicants for the position of ETL Developer. This position is responsible for the design, development, testing, debugging, and optimization of ETL to suppo ...

  • Resource Informatics Group

    ETL Developer

    16 hours ago


    Resource Informatics Group Irving, United States

    Note:Only local candidates are needed; those who apply elsewhere will be denied right away since this is an on-site interview. · ETL Developer · Location: Melville, NY · Exp: 08+ years · Long Term Contract · Job Description: · Implementation, operations and maintenance of en ...


  • Diverse Lynx Plano, United States

    Job Title:Informatica ETL Developer with Snowflake · Location: Plano, TX (Onsite) · Contract · Mode of interview: Video Call · Note :: Require candidate to join onsite from day 1 · Must have skills : Snowflake, DBT, ETL Informatica, PL/SQL, Informatica Powercentre ,Python · ...


  • Diverse Lynx Plano, United States

    Job Title: Informatica ETL Developer with SnowflakeLocation: Plano, TX (Onsite)ContractMode of interview: Video CallNote :: Require candidate to join onsite from day 1 Must have skills : Snowflake, DBT, ETL Informatica, PL/SQL, Informatica Powercentre ,PythonJob Description: · • ...


  • AA SOFTWARE & NETWORKING PRIVATE LIMITED Plano, United States

    Job Title: ETL/Data Warehousing Developer · Job Location: Plano, TX · Job Type: W2 Only · Job responsibilities: · Executes software solutions, design, development, and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or ...


  • Leadsonline Plano, United States

    Reporting to the Director of Technical Integration, the SQL/ETL Software Engineer will design, develop, and implement front-end user interfaces, and develop back-end systems. This role interacts with external customers with a service mindset, diligence, energy, and confidence. · ...

  • Globe Life Inc.

    Sr. ETL Developer

    2 weeks ago


    Globe Life Inc. McKinney, United States Full time

    Job Description: · Sr. ETL Developer · Primary Duties & Responsibilities · JOB SUMMARY: · Experience what being part of the Globe Life family feels like. Be inspired by your leaders, encouraged, and cheered on by your teammates to excel and be supported in your career while work ...

  • Verdant Infotech Solutions

    ETL Developer

    4 days ago


    Verdant Infotech Solutions Lewisville, United States

    Contract: 12-18 months +Location: Remote - travel to Nashville, TN one time to meet the team - paid expenses. Job Description: Requirements: Experience with o9 and IBP (integrated business planning). SQL and Data Integration Experiences in general. Strong ability to do some ETL w ...

  • Globe Life

    Sr. ETL Developer

    5 hours ago


    Globe Life McKinney, United States

    Sr. ETL Developer · Primary Duties & Responsibilities · JOB SUMMARY: · Experience what being part of the Globe Life family feels like. Be inspired by your leaders, encouraged, and cheered on by your teammates to excel and be supported in your career while working with us. We o ...

  • Globe Life

    Sr. ETL Developer

    3 weeks ago


    Globe Life McKinney, United States

    Sr. ETL Developer – Interoperability (Hybrid) · Primary Duties & Responsibilities · JOB SUMMARY · Experience what being part of the Globe Life family feels like. Be inspired by your leaders, encouraged, and cheered on by your teammates to excel and be supported in your career ...

  • Resource Informatics Group

    DWH/ETL Developer

    3 days ago


    Resource Informatics Group Irving, United States

    Job Title: - DWH/ETL Developer - Expert in SSIS · Location: - WI · Duration: -10-15 months · Experience: - 8+ yearsDeveloping complex SQL - 6 years · Must have expert level experience with SSIS for ETL · Using ETL tools to design ETL jobs - Must have 2 years in Alteryx (do not ...

  • Open Systems Technologies

    ETL Developer

    2 weeks ago


    Open Systems Technologies Irving, United States

    A financial firm is looking for an ETL Developer (Talend and Ab Initio) to join their team in Irving, TX. · Duration: 1 year · ETL developer position requiring a candidate with Talend and AbInitio ETL experience. · The Key responsibility will be development and maintenance of ETL ...

  • Open Systems Technologies

    ETL Developer

    3 weeks ago


    Open Systems Technologies Irving, United States

    A financial firm is looking for an ETL Developer (Talend and Ab Initio) · to join their team in Irving, TX. · Pay: $70-80/hr · Duration: 1 year · ETL developer position requiring a candidate with Talend and AbInitio ETL experience. · The Key responsibility will be development ...