Hope you are doing well..
I have positions for ETL DataStage Developer with our client. Kindly review the job description below and see if it might be an option worth considering. I can be reached at 201-377-1715 any between 8:30am EST to 5:30 EST
Please send your consultant profile to agautam@sourceinfotech.com
DataStage Developer
Minneapolis, MN
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,
Amit Gautam
Source Infotech Inc.
40 Brunswick Avenue, Suite # 200, Edison, NJ, 08817
EMAIL: agautam@sourceinfotech.com
Phone: 201.377.1715 | Fax: 732-909-2282 | Gtalk: recamitgautam
Yahoo: amit.gautam754
Certified Minority Business Enterprise - MBE
Please don't print this email unless you really need to.
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at http://groups.google.com/group/it-jobs-in-usa.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment