-- Please Share Me Profile [email protected]
*Title : ETL Developer (DataStage)* *Location : Richardson, TX* *Duration : 6 months* *Mode of Interview: face to face preferred but phone only might work for the right candidate* Description: ETL Developer (DataStage) Position Description: Direct responsibility for the design, maintenance, and support of Data Warehouse Systems. The developer requires a high level of analytical and creative skills and an in-depth knowledge of database structure, data warehouse configuration, methodology, design, and modeling. The developer’s typical duties includes but not limited to designing and building data warehouses, designing ETL architectures and procedures, performing analysis, SQL scripting, tuning and optimization on very large (multi-terabyte) databases, managing capacity planning and performance analysis, working with application developers to design and develop database objects and structures according to project specifications, addressing data quality issues with users, vendors and management, analyzing organizational data requirements and creating logical and physical Data Flow Diagrams and Entity Relationship Diagrams using tools such as Visio and Erwin. Must be able to work with and within a cross-functional development, QA and production team. Skills Required: This position supporting data extracts, i.e., pulling data primarily from the warehouse and creating outbound data files. This position does not reflect the requirement for warehouse data acquisition. PGP UNIX: For development of Kornshell scripts to execute Teradata BTEQ & UNIX functions. (Data transformations are performed using SQL.) FTP Connect Direct ETL Ascential DataStage (minimum 3 years) ZENA: For development of processes & scheduling. Mainframe BTEQ Advanced Teradata skills (e.g., SQL, FastExport, compression), minimum of 5 years experience. Effectively develops complex Teradata SQL coding (use of temp/volatile tables, complex joins, etc.) Software development lifecycle process and the requirement to generate supporting artifacts for each phase Experience in data warehousing/data mart environment Possesses strong analytical thinking skills for activities such as: data profiling, data analysis, data quality checking with supporting analytics Verbal & written communication skills with both IT and business (who represent multiple levels within organization) Creates clear and concise documentation, produces source to target maps, understands and validates metrics Ability to multi-task and work on multiple projects & prioritize correctly Regards, Mukesh *E-Mail* : [email protected] Cell : 732-722-2842 **Yahoo-IM- mukeshinc -- You received this message because you are subscribed to the Google Groups "GTA DBA" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/gtadba. For more options, visit https://groups.google.com/groups/opt_out.
