Senior Etl Developer

 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