Job Seekers, Please send resumes to resumes@hireitpeople.com Detailed Job Description: Strong working experience in Informatica PowerCenter, Teradata, Oracle, SQL and UNIX. Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica PowerCenter. Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow. Experience in Extraction, Transformation and Loading (ETL) of data from various data sources into Data Marts and Data Warehouse using Informatica PowerCenter components (Repository Manager, Designer, Workflow Manager and Workflow Monitor). Good Experience in creating Transformations and mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets. Should have very good knowledge in Teradata. Good knowledge of creating/Modifying Bteq files is essential. Should have very good skills in UNIX, should be able to analyze/create UNIX scripts individually. Should have good knowledge in ETL process, standards, and best practices. Hands on experience in Batch processing, scheduling jobs in Teradata and SQL Programming/Querying (Stored procedures, Functions, Complex joins, Triggers, Indexing, DML and DDL) Control - M Knowledge is must for job monitoring and job scheduling Performing database diagnostics, query optimizations, performance tuning and monitoring Should have Proven Experience into Data Modelling Translating complex business requirements into scalable technical solutions meeting development standards Should be able to individually attend client calls and perform requirement gathering and prepare required documents Should be good in debugging and analyzing the issues and resolve in a timely manner. Keeping up to date with the latest technical advances within the agreed technical specialism Candidates should be flexible / willing to work across this delivery landscape which includes and not limited to Agile Applications Development, Support and Deployment.

Certifications Needed: No

Interview Process (Is face to face required?): No

Does this position require Visa independent candidates only? No