Wednesday, January 2, 2019

Need ETL Informatica Developer

Please send resumes to durgaprasad@metasisinfo.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 Informatica Developer

Location: Richmond, VA

Duration: 12 Months

 

Job description:

Professional Experience:
- Requires 8-10 years of Informatica and SSRS 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
- SSRS 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

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 & Regards,

 

Durga Prasad

Team Lead - Talent Acquisition

Metasis Information Systems

Email : durgaprasad@metasisinfo.com

www.metasisinfo.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.

No comments:

Post a Comment