Informatica Power Center Developer

Syntricate Technologies Inc

San Antonio, TX

JOB DETAILS
SKILLS
Algorithms, American National Standards Institute (ANSI), Analysis Skills, Application Programming Interface (API), Banking Services, Business Intelligence, Customer Relations, Data Analysis, Data Mart, Data Modeling, Data Visualization Tools, Data Warehousing, Database Extract Transform and Load (ETL), Informatica, Knowledge Management Systems, Load Balancing, Microsoft SQL Server, NCR Teradata, Oracle Database, Performance Metrics, Performance Tuning/Optimization, Procedure Development, Programming Languages, Python Programming/Scripting Language, Relational Databases (RDBMS), SQL (Structured Query Language), Stored Procedures, Unix Shell Programming
LOCATION
San Antonio, TX
POSTED
30+ days ago
Required Skills:
  • 5-12 years (min 5 years in Informatica Power Center + DWH Development )
  • IICS basic development/mig skills is a plus.
  • ETL Development project for Data Warehouse program with a strong Sql and data analysis skills in either of ANSI db (Teradata, Oracle, Sql server etc) with onsite coordination experience with offshore and customer interfacing role. Banking domain is a plus
  • ETL skills: strategies, adept in writing complex SQL queries and understanding Queries as well.
  • He / She should be able to understand the Data warehousing, concepts such as schema types, Dimensions, facts, SCD concepts and Basic data modelling/data architecture concepts, pushdown optimization, partitioning. understand the properties and uses of various transformations and functions available for use in Informatica as well as SQL.
  • Should have knowledge of basic data cleansing, load balancing, performance tuning, parameterization as well as Data integration from various types of sources.
  • DB skills: Relational database management systems basic knowledge is a must, along with the capacity to create logics to perform various functions in an efficient and error free manner, should at least knowhow to create algorithms to perform specific functions which could later be translated in any required programming language.
  • Knowledge of any other programming languages like Python, APIs, Stored procedure development, Data Marts, Data Visualization tools,, KPI extraction, Scheduling tools, Unix or batch scripting and other BI reporting tools is a plus point.

About the Company

S

Syntricate Technologies Inc