Senior ETL Developer

2 months ago


Plano, United States TEKsystems Full time
Job DescriptionJob 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 



  • Plano, Texas, United States ApTask Full time

    About the Role:We are seeking an experienced Abinitio ETL specialist to join our team at ApTask. The successful candidate will have a strong background in Ab Initio ETL and will be responsible for designing, developing, and implementing ETL solutions for our clients.Key Responsibilities:Design and develop ETL solutions using Ab InitioImplement and maintain...


  • Plano, United States Syntricate Technologies Full time

    per - Snowflake exp. || Plano, TX -- Contract 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 development Experience with databases like Snowflake (Cloud DB), Oracle, Netezza,...

  • ETL Developer

    1 week ago


    Plano, Texas, United States Syntricate Technologies Full time

    Job Description: We are seeking an experienced ETL Datastage Developer with expertise in Snowflake to join our team at Syntricate Technologies. In this role, you will be responsible for designing, developing, and implementing ETL processes using Datastage and Snowflake. Key Responsibilities: 10+ years of experience in ETL development using Datastage or other...


  • Plano, United States BCforward Full time

    Hadoop & ETL DeveloperBCforward is currently seeking a highly motivated " Hadoop & ETL Developer " for an opportunity in - Plano, TX 75024.Position Title : Hadoop & ETL DeveloperLocation: Plano, TX 75024 Job Posting Expected Start Date: ASAP (Please note this is the target date and is subject to change. BCforward will send official notice ahead of a...


  • plano, United States Matlen Silver Full time

    Job Title: ETL/DataStage DeveloperLocation: Plano, TX or Newark, DE Job Type: 12-18 month contractJob Summary:We are seeking an experienced ETL/DataStage Developer for a key role in Plano, TX. The successful candidate will have strong expertise in IBM DataStage (ETL), with the capability to manage and deliver complex requirements to meet critical business...


  • plano, United States Matlen Silver Full time

    Job Title: ETL/DataStage DeveloperLocation: Plano, TX or Newark, DE Job Type: 12-18 month contractJob Summary:We are seeking an experienced ETL/DataStage Developer for a key role in Plano, TX. The successful candidate will have strong expertise in IBM DataStage (ETL), with the capability to manage and deliver complex requirements to meet critical business...


  • Plano, United States Matlen Silver Full time

    Job Title: ETL/DataStage DeveloperLocation: Plano, TX or Newark, DE Job Type: 12-18 month contractJob Summary:We are seeking an experienced ETL/DataStage Developer for a key role in Plano, TX. The successful candidate will have strong expertise in IBM DataStage (ETL), with the capability to manage and deliver complex requirements to meet critical business...

  • ETL/PLSQL Developer

    1 month ago


    plano, United States Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • ETL/PLSQL Developer

    3 weeks ago


    plano, United States Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • ETL/PLSQL Developer

    3 weeks ago


    plano, United States Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • ETL/PLSQL Developer

    1 month ago


    plano, United States Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • ETL/PLSQL Developer

    1 month ago


    Plano, United States Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • ETL/PLSQL Developer

    3 weeks ago


    Plano, United States Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • Senior Java Developer

    1 month ago


    Plano, Texas, United States Matlen Silver Full time

    Job Title: Senior Java DeveloperJob Description:We are seeking a highly skilled Senior Java Developer to join our team at Matlen Silver. As a key member of our software development team, you will be responsible for designing, building, and delivering complex software solutions that meet business objectives in an Agile environment.Key Responsibilities:Develop...


  • Plano, Texas, United States Diverse Lynx Full time

    Role OverviewAt Diverse Lynx LLC, we are seeking an experienced Abinitio ETL Specialist to join our team. As a key member of our data integration team, you will be responsible for designing, developing, and implementing Abinitio solutions to meet our business needs.Key Responsibilities* Design and develop Abinitio workflows for data integration and...


  • plano, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Senior PL/SQL Developer with Informatica. This is a 12+months contract opportunity with long-term potential and is located in Plano, TX (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID: 24-46540Pay Range: $65 - $70/hour. Employee benefits include, but are not limited to, health...


  • Plano, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Senior PL/SQL Developer with Informatica. This is a 12+months contract opportunity with long-term potential and is located in Plano, TX (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID: 24-46540Pay Range: $65 - $70/hour. Employee benefits include, but are not limited to, health...


  • plano, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Senior PL/SQL Developer with Informatica. This is a 12+months contract opportunity with long-term potential and is located in Plano, TX (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID: 24-46540Pay Range: $65 - $70/hour. Employee benefits include, but are not limited to, health...


  • Plano, United States Synechron Full time

    Title: Oracle Database DeveloperLocation: Plano TXEmail:mohammed.ahmed3@synechron.com We are seeking a skilled Oracle Database Developer with strong experience in SQL, PL/SQL and database technologies to join our dynamic team.The role is responsible for the design, development, coding, testing, debugging and documentation of datawarehouse/database/business...


  • plano, United States Synechron Full time

    Title: Oracle Database DeveloperLocation: Plano TXEmail:mohammed.ahmed3@synechron.com We are seeking a skilled Oracle Database Developer with strong experience in SQL, PL/SQL and database technologies to join our dynamic team.The role is responsible for the design, development, coding, testing, debugging and documentation of datawarehouse/database/business...