Informatica Production Support

Tata Consultancy Services Mclean , VA 22107

Posted 2 months ago

Job Description:

  • At least 7+ years of experience in DataStage(ETL) or Informatica, shell scripting and db2/oracle Sql skills, Autosys, SAS.

  • Work in production support to analyze, troubleshoot, resolve issues on timely basis

  • Available based on production incidents and respond quickly to SDM, support teams

  • Strong communication with status reporting skills

  • Provide ETL development expertise in relational database management concepts and data warehousing best practices and apply dimensional modeling experience and a background in general programming concepts

  • Lead the development of source-to-target mapping design specifications, data dictionaries, review database schemas

  • Develop and test Extract, Transform, and Loading (ETL) modules based on design specifications

  • Develop and test ETL Mappings in Informatica PowerCenter

  • Develop complex sequential and parallel jobs.

  • Perform unit and system testing on the ETL processes and resulting data warehouse /ad hoc tables

  • Create test cases and test the data.

  • Assist with capacity planning and performance tuning activities.

  • Mentor others on the team with product functionality and provide guidelines and solutions on performance tuning techniques and industry best practices.

  • Understanding the existing ETL environment, translating into new environment requirements and planning tasks to meet those requirements.

  • Plan, test and deploy ETL mappings, and database code

  • Exposure working in an Agile and/or waterfall-based projects environments.

  • Candidate must attend face-to-face or Skype interview

  • Strong analytical and development skills required to trouble the issues and developed effective solutions.

  • Strong experience and knowledge of database concepts with working knowledge on SQL, DB2 or Sybase database, and Stored Procedures

  • Good attitude that will allow the team to perform better, work as a team player

  • Innovative in providing solutions, and strives to constantly improve the application development processes and tools

  • Experience in all aspects of system development life cycle methodologies including waterfall and/or agile development

  • Experience leading development teams

  • Experience with Mainframe and Unix

  • Experience working with Agile methodology

  • Experience with Java and WebMethods.

  • Professional who is motivated and is an effective team player

  • Strong written and oral communication skills with the ability to convey technology solutions to business partners

  • Proactive in nature with customer satisfaction as primary goal.

  • Experience in Mortgage Industry or direct Freddie Mac experience


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
ETL / Informatica Developer

Two95 International Inc.

Posted 1 week ago

VIEW JOBS 11/19/2020 12:00:00 AM 2021-02-17T00:00 <p><strong>Title: </strong><strong>ETL / Informatica Developer</strong></p> <p><strong>Job Type: 6+Months Contract</strong></p> <p><strong>Location: 100% Remote</strong></p> <p><strong>Rate: $Open/hour</strong></p><p><strong>Requirements</strong></p><p><strong>Job Requirements:</strong></p> <ul> <li>Must have ETL / Informatica Tool knowledge.</li> <li>NCPDP knowledge and pbm experience is mandatory.</li> <li>Understanding and Performance Tuning of PL/SQL</li> <li>Nice to have Well knowledge in formats PA 4.2, 4.7</li> </ul><p><strong>Benefits</strong></p><p><strong>Note:</strong> If interested please send your updated resume to <a href="" rel="nofollow noreferrer noopener" class="external"></a> and include your salary requirement along with your contact details with a suitable time when we can reach you. If you know of anyone in your sphere of contacts, who would be a perfect match for this job then, we would appreciate if you can forward this posting to them with a copy to us.</p> Two95 International Inc. McLean VA

Informatica Production Support

Tata Consultancy Services