Senior ETL Developer

6 days 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 TEKsystems Full time

    Job Title: Senior ETL DeveloperWe are seeking a highly skilled Senior ETL Developer to join our team at TEKsystems. As a Senior ETL Developer, you will be responsible for designing, developing, and implementing data integration solutions using industry-strength data movement technologies such as InfoSphere DataStage, Informatica PowerCenter, or others.Key...

  • ETL Developer

    4 weeks ago


    Plano, Texas, United States Syntricate Technologies Full time

    About the RoleWe are seeking a highly skilled ETL Snowflake Developer to join our team at Syntricate Technologies. As a key member of our data engineering team, you will be responsible for designing, developing, and implementing efficient ETL processes using Snowflake and other cloud-based ETL tools.Key ResponsibilitiesETL Development: Design, develop, and...


  • Plano, Texas, United States Syntricate Technologies Full time

    Job Title: ETL Datastage Developer - Snowflake ExpertJob Summary:We are seeking an experienced ETL Datastage Developer to join our team at Syntricate Technologies. The ideal candidate will have a strong background in ETL development, particularly with Snowflake, and be able to design and implement efficient data integration solutions.Key Responsibilities:•...


  • Plano, Texas, United States Insight Global Full time

    Job Title: ETL Informatica DeveloperWe are seeking an experienced ETL Informatica Developer to join our team at Insight Global. As an ETL Developer, you will play a crucial role in managing data for 65 legacy applications across our client environment.Key Responsibilities:Design, develop, and optimize ETL processes using Informatica PowerCenterCollaborate...


  • Plano, Texas, United States Insight Global Full time

    About the RoleWe are seeking an experienced ETL Informatica Developer to join our team at Insight Global. As an ETL Developer, you will play a critical role in managing data for 65 legacy applications across our client environment.Key ResponsibilitiesDesign, develop, and optimize ETL processes using Informatica PowerCenterCollaborate with cross-functional...


  • Plano, Texas, United States Syntricate Technologies Full time

    Job Title: ETL Datastage Developer - Snowflake expLocation: Plano, TXDuration: ContractJob Description:Required Skills:• 10+ years of relevant IT software experience in ETL Datastage or other cloud-based ETL tool development• Experience with databases like Snowflake (Cloud DB), Oracle, Netezza, MS SQL Server 2012+, DB2, and MS Access• Strong ability to...


  • 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,...


  • Plano, Texas, United States Apex Systems Full time

    Job Title: ETL Support DeveloperApex Systems is seeking a highly skilled ETL Support Developer to join our team. As an ETL Support Developer, you will be responsible for monitoring application jobs across multiple DataStage/Informatica production environments, performing initial triage of job failures/production issues, and gathering information to determine...

  • ETL Developer

    4 weeks ago


    Plano, United States BCforward Full time

    ETL Developer BCforward is currently seeking a highly motivated Application Programmer (ETL Developer) for an opportunity in Plano, TXPosition Title: Application Programmer Location: Plano, TX Anticipated Start Date: ASAP Please note this is the target date and is subject to change. BCforward will send official notice ahead of a confirmed start date....


  • Plano, United States Syntricate Technologies Full time

    Required Skills: 10+ Years 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 Access Experience with job automation & scheduling software (Control-M) Strong ability to write SQL queries ...


  • Plano, Texas, United States Matlen Silver Full time

    {"About Matlen Silver": "Matlen Silver is a leading provider of complex talent and technology solutions to Fortune 500 companies and industry leaders. With over 40 years of experience, we deliver innovative solutions that drive business success.Our team of experts is dedicated to helping our clients achieve their goals through our expertise in talent and...


  • Plano, Texas, United States Matlen Silver Full time

    Job Title: ETL / Informatica Developer W2 OnlyLocation: Onsite up to 3 days a week; Hybrid – Office location is Plano, TXRequired Pay Scale: $60-68hr W2***Due to client requirements this role is only open to USC or GC candidates***Job SummaryWe are seeking an experienced ETL / Informatica Developer to join our team at Matlen Silver. As a key member of our...

  • ETL Developer

    2 weeks ago


    Plano, United States MANDO TECHNOLOGIES INC Full time

    Looking for Mid level Data Engineers with 8+ years ETL Experience for financial client in Dallas, TXLocation: Plano, TX (Onsite Day 1)Duration: 1 year and may get extendedMust-Have:Experience designing and developing data integration solutions using ETL tools (Ex: Datastage 11.x)Minimum 1 year Data Build Tool (DBT) experience is a mustStrong yaml, SQL &...

  • ETL Developer

    2 weeks ago


    plano, United States MANDO TECHNOLOGIES INC Full time

    Looking for Mid level Data Engineers with 8+ years ETL Experience for financial client in Dallas, TXLocation: Plano, TX (Onsite Day 1)Duration: 1 year and may get extendedMust-Have:Experience designing and developing data integration solutions using ETL tools (Ex: Datastage 11.x)Minimum 1 year Data Build Tool (DBT) experience is a mustStrong yaml, SQL &...

  • ETL Developer

    2 weeks ago


    Plano, United States MANDO TECHNOLOGIES INC Full time

    Looking for Mid level Data Engineers with 8+ years ETL Experience for financial client in Dallas, TXLocation: Plano, TX (Onsite Day 1)Duration: 1 year and may get extendedMust-Have:Experience designing and developing data integration solutions using ETL tools (Ex: Datastage 11.x)Minimum 1 year Data Build Tool (DBT) experience is a mustStrong yaml, SQL &...


  • Plano, Texas, United States Syntricate Technologies Full time

    Job Title: ETL Datastage Developer - Snowflake ExpertWe are seeking an experienced ETL Datastage Developer with expertise in Snowflake to join our team at Syntricate Technologies.Key Responsibilities:Design, develop, and implement ETL processes using Datastage and SnowflakeDevelop and maintain complex data pipelines using Datastage and SnowflakeCollaborate...

  • ETL Tester

    1 month ago


    Plano, United States Algobrain Inc Full time

    ETL Tester: Data Quality Champion This is a Hybrid opportunity, 3 days a week in the office Are you passionate about ensuring data integrity and accuracy? Do you thrive in a fast-paced environment where your analytical skills can make a real difference? If so, we're looking for you! As an ETL Tester, you'll be the guardian of our clients data warehouse,...

  • ETL Developer

    6 days ago


    Plano, United States Zenith services Full time

    12 years of technology experience 7 years of experience identifying technical solutions for complex business problems identifying the benefits and risks of the solutions and providing recommendations 7 years of experience in Technology Data Engineering field in architecting developing endtoend scalable data applications and data pipelines; work with product...


  • Plano, Texas, United States Syntricate Technologies Full time

    ETL Datastage with Snowflake Job DescriptionWe are seeking an experienced ETL Datastage professional with expertise in Snowflake integration to join our team at Syntricate Technologies.Key Responsibilities:Design and develop ETL processes for data movements using Datastage and SnowflakeDevelop Unix shell scripting skills for text processing and data...


  • Plano, Texas, United States Syntricate Technologies Full time

    ETL Datastage with Snowflake Job DescriptionWe are seeking an experienced ETL Datastage professional with expertise in Snowflake integration to join our team at Syntricate Technologies.Key Responsibilities:Design and develop ETL processes for data movements using Datastage and SnowflakeDevelop Unix shell scripting skills for text processing and data...