Need ETL Informatica Developer with Mongo DB experience

Please send resumes to durgaprasad@sparinfosys.com

 //h1b copy must// 

Appreciate your responses with updated word profile, contact details and rate specifications.

 Full Name:

Phone Number:

Email ID:

Current Location:

Visa Status:

Relocation:

Availability:

Rate:

Role: Sr ETL Developer with Mongo DB experience

Location: Richmond, VA

Duration: 12+ Months

 

Job description:

Professional Experience:

·         Requires 10+ years of MS DB, INFA and SSIS 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 9.6 and above

·         Experience in Informatica Velocity proven methodology and ETL Industry standards

·         Good understanding of Reporting and Data Warehousing concepts

·         Experience in design and development of dashboards and reports, including the development of detailed design specifications using SSRS.

·         Design, develop, revise and maintain a wide variety of custom SSRS reports to support business (e.g., dashboards, scorecards, custom extracts).

·         Support the business for report modification requirements and on demand requests in timely fashion

 

Mandatory Skills:

·         INFORMATICA 9.6 and above

·         SSIS 2012 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

·         Tidal or Control M scheduling tool

 

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

 

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

·         Report development experience must include sub reports, writing complex formulas and conditional formatting

·         Designs, develops and maintain various business intelligence applications (reports, dashboards, scorecards)

Expertized creating parameterized reports, drilldown reports and scheduled reports.

Thanks

Durga Prasad

Spar Information Systems

Email:durgaprasad@sparinfosys.com

--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To post to this group, send email to sureshotjobs@googlegroups.com.
Visit this group at https://groups.google.com/group/sureshotjobs.
For more options, visit https://groups.google.com/d/optout.