Hope all are doing good, Please go through the below requirement,if you have any consultant please send me the updated profile to a...@pronixinc.com or reach me at 732-476-6387
Title : ETL Developer Location : Rockville, MD Duration : Contract Local candidates to VA/MD. 7-10 years of prior software development experience required Design, Develop and Provide support in all aspects of data movement for a data warehouse environment residing on Netezza, with emphasis on the Extract-Transform-Load (ETL) process using Informatica. • Ability to administer ETL system and upgrade to new releases • Develop data warehouse process models, including sourcing, extracting, transforming and loading as per business requirements. • Design Extract-Transform-Load (ETL) Workflows for data migration from various sources to data warehouse using batch or incremental loading strategies. • Document database design including data modeling, metadata and business process flow for the new business integration requirements. • Create data model and reverse engineer data warehouse using CASE tools like ER Studio. • Create test plans and scripts for data warehouse testing, ranging from unit to integration testing. • Ensure delivered Data warehouse code is running and conforms to specifications and design guidelines. • Create Informatica mappings, transformations, stored procedures and functions to implement the data process flow defined by the business rules. • Document technical ETL specifications for data warehouse. Perform periodic code reviews and test plans to ensure data quality and integrity. • Navigate on the host server for file management, file cleanup and configuration tasks. Maintain Informatica on UNIX and Windows environments. Write Shell scripts, PL/SQL scripts and SQL scripts • Prior Experience in Upgrading Informatica Power Center versions. • Excellent communication skills with knowledge of ETL field, tools and technologies, implementations and solutions, as well as specific experience with the Informatica ETL tool • Excellent motivational skills required to ensure good team synergy and collaboration of cross functional teams. A strong facilitation and “positive” attitude will be mandatory. • Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning, and High Volume Data Loads • Excellent ability to multi-task. • Demonstrated proficiency with a database SQL language for user-defined database extracts or updates statements. • Proficient in Netezza 6.0.4 • Proficient on all Informatica 9.x Platform tools (Power Exchange, Power Center) • Proficient use of CASE tools (Embarcadero ER Studio preferred) *Thanks and Regards,* *Anil Reddy* *ProNix* *Inc * *a...@pronixinc.com* <a...@pronixinc.com> *Ph: **732 476 6387* <732%20476%206387>*| Fax: **732 909 2000* <732%20909%202000> *www.pronixinc.com* <http://www.pronixinc.com/> *|"E-Verify Employer"| * *PS: We welcome referrals, We pay $1000 for each referral you make if the referral consultant work on our billing/project. We sponsor for Fresh H1B applicants/H1B transfers, Immediate Greencard processing sponsorship, FREE Job Oriented Training along with the pay rates on Percentage hourly basis for Qualified Candidates. Call us to discuss further.* -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to corptocorp+unsubscr...@googlegroups.com. To post to this group, send email to corptocorp@googlegroups.com. Visit this group at http://groups.google.com/group/corptocorp. For more options, visit https://groups.google.com/d/optout.