T*****

T*****

 

BI CONSULTANT

 

  • Permanent
  • USA Work Ready
  • Oracle 11g

  • SQL SERVER INTEGRATION SERVICE

  • SQL Server 2008

  • FORT REPORTING

  • Teradata

  • Unix

  • Maestro

  • BUSINESS OBJECT XI

  • Windows

  • Informatica

  • Db2

  • TIDAL

  • DATA INTEGRATOR

Read More

  • Job Posted: Tuesday, March 17, 2015

  • Expires On: Monday, June 29, 2015

  • Job Type: Permanent

  • Desired Salary: $100000/yr

  • Work Authorization: H1-B

§ 8 years of strong experience in Data Warehousing and ETL using Informatica Power Center 9.5.0,9.1.0, 8.x, 7.x, and 6.x (Workflow Manager, Workflow monitor, Warehouse Designer, Source Analyzer, , Repository manager, Informatica server), Informatica Power Mart, Informatica Power Exchange, Data mart, OLAP, OLTP, SQL, PL/SQL, Stored Procedures. Experienced in using parameter files, mapping parameters in mappings. Teradata 13, Oracle 11g/10g/9i, DB2 , SQL server , ETL process , Reporting (BOXI,Fort Reporting).SQL Server integration services (SSIS), Business Object data integrator § Experiences in leading a big team and on the ETL and took a responsibility for end to end development and support.   § Experience in Life Cycle Development of building a Data Warehouse for large technology projects including Analysis, Design, Development, Testing, Maintenance and Documentation   § Extensively worked on Teradata database including TSQL, BTEQ, Multiload, Fastload, Fastexport. Hands-on experience in performance tuning of queries.   § Extensively worked on ORACLE got certified in OCA oracle 9i   § Experience in integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat-files, CSV files, COBOL files and XML files.
  • Teradata DBA role has been performed Experience working with UNIX Shell Scripts and Perl for automatically running sessions, Aborting sessions and creating parameter files.
§ Ability to transition business expectations through IT's budgetary and technical limitations to design effective and efficient applications. As a Data Analyst I have successfully helped clients meet their business objectives by utilizing information technology § Extensively executed SQL queries worked on adhoc reports to extract data on Oracle, Teradata, DB2 and SQL server tables in order to view successful transaction of data and to validate data.   § Experience in Teradata Stored Procedures and Triggers Capacity planning and space optimization in Teradata database   § Good Knowledge in Maestro and other scheduler tools. Experienced in implementing error-handling process.
  • Good understanding of Data warehousing, ER Modeling and Dimensional Modeling concepts
  • Testing skills include performing Regression, Integration, and Volume testing as well as Development, Execution, and Maintenance of Test plans, Test specifications and Test scenarios.
  • Strong knowledge of Data Warehousing concepts and end-to-end Data Warehousing project life cycle.
§ Experience in providing On Call (24*7) Support for Production Problem Resolution (Resolve Production issues and problems in an expedited manner). § Good understanding of Hadoop and its products § Good understanding of Product Life Cycle and Comprehensive Delivery Process’s. § Team player with strong People Management skills, excellent Communication and Problem Solving skills and exposed to various design and presentation tools like Visio and MS-Office utilities. Domain knowledge in Retail and Insurance.  Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire  to achieve specified goals. Excellent written and verbal communication skills.
  • Minneapolis, MN

  • Texas City, TX

  • Colorado City, CO

  • Michigan Center, MI

  • Ohio City, OH