Diverse Lynx
ETL Informatica Power Center Developer
Diverse Lynx, San Antonio, Texas, United States, 78208
Role: ETL Informatica Power Center Developer
Location: San Antonio, TX
Experience: 8+ Year
Duration: 12+ Months
Experience :
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 on site 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.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Experience :
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 on site 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.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.