*Hi* *Please go through the below position and if you feel comfortable, then please send me your updated resume*
*Title: **ETL developer* *Location: San Ramon, CA* *Duration: 6-18 months* *Mode of Interview: Phone/Webex/Skype * *visa: Any (Must be able to pass background check, drug test.)* *JD: * *Must be Local* *Position Description * Qualified and motivated candidate to be responsible for proper ETL development, standards and best practices, collaborating with existing ETL resources to set cutting edge industry standards. *Required Experience* · 7 - 10 years of overall experience at Enterprise-level ETL development and ETL architecture using Informatica · 3+ years of experience deploying large scale projects using Informatica Tools · Strong Oracle Database technical knowledge in the areas of general SQL and PL/SQL · 3+ years in banking and financial services is preferred (not required) · understanding the COBOL file structures preferred (not required) *Essential Functions* · Manages development and testing tasks and ensuring adherence to previously agreed to timelines communicating status; · Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies; · Counsels team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit. Applies data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities of IDQ; · Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members; · Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.; · Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets. *Skills* · Experience at Enterprise-level ETL development and ETL architecture using Informatica · understanding the COBOL file structures; · Strong Oracle Database technical knowledge in the areas of general SQL and PL/SQL; · Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor; · Good knowledge of analytical and logical conceptual level programming skills; · Good knowledge of Erwin model generation tools (logical and physical); · Data analysis, data mapping, data loading, and data validation; · Understand reusability, parameterization, workflow design, etc.; · Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions; · Should have thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies; · Performance tuning and end-to-end lifecycle experience with Enterprise wide data warehouse. [image: logo] *Ankush Nirala* | Technical Recruiter | Apetan Consulting LLC Tel: 201- 620- 9700* 112 | Mail: 72 Van Reipen Avenue # 255 Jersey City, NJ 07306 | Corp.Office: 15 Union Avenue, office # 6, Rutherford, New Jersey 07070 | [email protected] | G-talk: [email protected] | www.apetan.com *[image: https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png]* <http://www.facebook.com/Apetanconsulting> *[image: https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png]* <http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home> *[image: https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.png]* <http://twitter.com/ApetanLLC> [image: e verify] *Disclaimer*: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience.
![https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png]*](https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png]*){kind=link}
![https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png]*](https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png]*){kind=link}
![https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.png]*](https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.png]*){kind=link}