*Dear,* *Hope you are doing well…..*
*Please send resumes to* *prave...@hclglobal.com* <prave...@hclglobal.com> *ROLE* *Sr ETL DataStage Developer* *LOCATION* *Atlanta GA* *DURATION* *LONG TERM* *RATE* *DOE* *DIRECT CLIENT* *YES* *INTERVIEW TYPE* *Phone or In-person* *State Experience Highly Preferred* *U.S. Citizens and those authorized to work in the U.S. are encouraged to apply* *Note: For H1 While submitting I need consultant I 797 OR ID Proof.* *Job Purpose* The Senior ETL (Extract, Transfer, and Load) Developer is responsible for the movement of data into and out of the Enterprise Data Warehouse (EDW) which will source data from many of Georgia Tech’s institutional systems. Analyze data requirements, complex source data, and the data model, and determine the best methods in extracting, transforming and loading the data into the data warehouse and other system integration projects. *Impact and Influence* This position will interact on a consistent basis with: other ETL developers, business/functional analysts, programmer/analysts, database/data warehouse administrators and architect. This position typically will advise and counsel: EDM and OIT staff for implementation of Data Stage and other units using Data Stage in best practices related to ETL development. This position will supervise: NA *Technical Skills Required* · Full life-cycle experience on large/complex enterprise software development projects. · Hands on experience in IBM DataStage ETL Design, Development & Build. · Experience in project life cycle activities on DW/BI (Data warehouse and Business Intelligence) development and maintenance projects. · Experience in developing best practices, unit testing and developer code reviews. · Understanding of Unix/Linux system, files systems, shell scripting. · Understanding of databases/ data marts/data warehouses and complex SQL and Oracle PL/SQL. Experience with databases including Oracle (11gR2), Microsoft SQL Server, and MySQL. *Other Skills Required* Strong written and verbal communication skills including the ability to express ideas concisely and clearly to both technical and non-technical audiences. Good problem solving and analytical skills used to resolve technical problems. Must possess a good understanding of business requirements and IT strategies. Ability to work independently, but is also a team player. Ability to lead a team of ETL developers. *Specialized skills preferred:* Experience in a Higher Education environment. Experience with PeopleSoft HCM and/or PeopleSoft Financials Experience with Banner. *EDUCATION, SPECIALIZED KNOWLEDGE AND EXPERIENCE: * Degrees required for this job: Bachelor’s degree in related field, or equivalent combination of experience and education *Degrees preferred* Years of experience required for this job: 6- 8 years of job related experience. At least 6 years in ETL development on any tool and at least 4 years in IBM Data Stage ETL tool. These may overlap for a total of 6 years work experience *Years preferred* Certifications or licenses required for this job: Certifications or licenses preferred: *SPECIALIZED SKILLS* Specialized skills required for this job: *Key Responsibilities* · Analyze reporting requirements to determine development methods, development templates, and to determine job scheduling. · Work in an Enterprise Data Warehouse (EDW) environment tasked to build a data warehouse using complex transformations that come from many of Georgia Tech’s systems. · Develop ETL jobs primarily in IBM Data Stage that satisfy identified business process and data models. · Troubleshoot and help improve existing ETL jobs. · Follow set standards and best practices in ETL development. Refactor existing jobs that do not follow set standards. · Provide guidance in some Data Stage administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues in unusually long running jobs, etc. · Work with other development units in improving best practices in ETL development for Georgia Tech. · Monitor nightly loads and troubleshoot any issues that may arise. · Maintain technical support documentation. · Other related duties as assigned. *Skills* *Required* *Years Used* *Last Used* Data Warehousing *Yes* IBM Infosphere DataStage *Yes* Oracle *Yes* SQL *Yes* -- You received this message because you are subscribed to the Google Groups "SAP Workflow" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-workflow+unsubscr...@googlegroups.com. To post to this group, send email to sap-workflow@googlegroups.com. Visit this group at https://groups.google.com/group/sap-workflow. For more options, visit https://groups.google.com/d/optout.
