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
Tata Consultancy Services