| Tomorrow Interview || ETL Developer || Richmond, VA (Onsite from Day1) at Richmond, Virginia, USA |
| Email: [email protected] |
| From: Rahul Kumar, SPAR Information Systems [email protected] Reply to: [email protected] Hello Folks, Hope you all are doing good. Please go through the Job description and let me know your interest. Title: ETL Developer Work Location: Richmond, VA (Onsite from Day1) Duration: 12+ months contract Note: Onsite from Day 1 at Richmond. Initially it will be 2 days (Tuesday & Thursday) in office and by mid of 2023 all 5 days in office Job Description: Requires 10+ years of MS DB, INFA developer. Expert in creating and analyzing complex stored procedures. Knowledge of database administration techniques and database administration tools. Experience in design and development of new and existing multi-tier online transactional systems. Experience in performance tuning and query optimization Experience in Healthcare Business, Agile delivery model and Scrum methodologies Knowledge of Data Warehouse concept, ETL concepts and tools preferred Demonstrated results and competence developing ETL process using Informatica Power Center and Power Exchange Experience in Informatica Velocity proven methodology and ETL Industry standards Good understanding of Reporting and Data Warehousing concepts Mandatory Skills: INFORMATICA 10.1 and above Oracle/MS SQL server 2014 and above JIRA and Confluence Bit Bucket Source Tree Transformations like Normalizer/aggregator/Java Transformation Putty/WINSCP Shell scripting and commands Excel experience with vlookup and other functions MongoDB Additional skills: Work closely with DBAs to support and deliver application releases Excellent analytical and problem solving skills Experience in the health care insurance industries desired Excellent written, verbal and interpersonal communication SharePoint MS Visio SQL Sentry PL/SQL Red Gate tools SOAP/Rest experience Tidal or Control M scheduling tool Responsibilities: Familiar with Logical Data Model and Physical Database design. Strong skills in Data Analysis, Data Profiling and Data Mapping for ETL processes. Performed analysis of Business and system requirements including Impact analysis of existing systems and create design specifications with the consultation of Business users and technical architects. Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views. Experience in database programming in TSQL Provides support during the system implementation. Partner with the architects to plan and develop solutions. May work with business operations to capture metadata to build out data models. Work with project teams to plan and execute the quality control process. Details all aspects of functional designs, including record layouts, pseudo-code, detailed data mapping, etc Strong experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor and Repository Manager Develop ETL data work flows and code for new data integrations and maintain/enhance existing workflow and code. Experience in using complex transformations Experience in error/exception handling using Informatica mapping Proficient in performance tuning, usage of partitions, etc., Preferable experience using Informatica IDQ Contact: Rahul Kumar Sr Technical Recruiter Direct No: 469-829-4899 / Desk No: 469-409-0307 Ext: 338 Cell No: 936-304-8292 Email: [email protected] Keywords: database information technology golang |
| [email protected] View all |
| Fri Dec 16 20:20:00 UTC 2022 |