*Please revert with resume @ [email protected] <[email protected]>*----*Phone:* *732-722-2842*
Minneapolis, MN Client: UHG 12+MONTHS Seeking replacement for an existing ETL developer on the Stars program. Many of the same skills as ODM ETL developers needed with the exception of Datastage, which is not required. This role will be generating data extracts, imports and reports within a SQL database supporting Stars reporting. *SSRS experience is a plus. (let’s call this a must) * *ETL Developer Job Description* In this exciting role, you will participate in the systems development life cycle for new development, enhancements and maintenance projects in Data Warehouse/Data Analytics environment. As a member of the Delivery Management team, you will lead development project teams to design, develop and deploy ETL software needed to support a variety of business needs. The position will report to a resource manager, but will be matrixed to project managers for completion of project activity. *Responsibilities*: · Research, evaluate, identify alternative approaches to support development needs · Recommend, design and code efficient and effective solutions for challenging problems for medium to large work efforts of medium to high complexity · Comply with standards and guidelines related to the design, construction, testing, and deployment activities within the Delivery Management environments · Demonstrate collaborative skills working within a project team of diverse skills · Bring strong communication skills including oral, written and presentation skills plus creativity, and problem solving skills to a challenging environment · Provide guidance and direction to less-seasoned staff *Requirements:* · 6+ years of experience working in a high volume *DataStage* environment. · 4+ years of experience in developing Oracle *procedures*, *functions*, *packages*, *database* *triggers* and troubleshooting using *PL*/*SQL* and *SQL*. · 4+ years of experience in implementing advanced features of Oracle like Autonomous Transactions, Ref-Cursors, PL/SQL Tables, Table Partitioning, V-Arrays, Materialized Views, Merge statements,SQL*Loader, External Tables, Pipelined/Table functions, Result Cache, With Clause and Multi Table Inserts. · 4+ years of experience troubleshooting performance issues, SQL tuning is a must. · Evaluate and understand a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models. · Develop ETL code meeting 100 percent of technical specifications and business requirements according to the established designs. · 4+ years experience in applications systems analysis and/or development and/or support. · 4+ years experience with multiple file structures and programming languages. · 4+ years experience with high level technical phases of applications systems analysis and programming activities · Thorough understanding of technological infrastructure and how it relates to projects is a plus · 4+ years experience with Oracle, SQL Server, Teradata or GreenPlum in Unix environment. · 4+ years experience with MS Office (Outlook, Excel and Word) · Experience with any SSH client. · Highly experience with complex shell scripting using *Unix*, and *PERL* and *crontab*. · Healthcare domain background is a plus. · Clinical domain experience is a plus. · Knowledge with HIE formats 837 i&p, HL7/ADT is a plus. · 4+ years of experience in converting specifications to programs and data mapping in an ETL DataStage environment. · 4+ years of experience working with and deploying TWS/d job automation. *Nice to have*: · Act as a Project Development Lead with one or more developers matrixed for the completion of the project · Previous experience in Pentaho is a plus. · Strong knowledge in data base technologies Teradata, Oracle, SQL Server, DB2, Netezza and GreenPlum. · Understanding of Hadoop stack such as Hadoop (Java, Map Map Reduce, Pig, Hive). · AIX · Multiple programming languages (Perl, Shell script, C++) · UDB/EEE · Autosys or equivalent job scheduling tool experience Thanks & Regards, *Viren Yadav* *Source Infotech Inc.* 40 Brunswick Avenue, Suite # 200, Edison, NJ, 08817 EMAIL: *[email protected]* <[email protected]> *Phone:* *732-722-2842* | Fax: *732-909-2282* | Gtalk/Yahoo: *viren.rgtalent* -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" 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/us_itgroups. For more options, visit https://groups.google.com/d/optout.
