Etl Informatica Developers Job in Optimized Solutions Limited

Technical Skills :

• 6+ years of experience in Information Technology with emphasis on Data Warehouse/Data Mart development using developing strategies for extraction, transformation, and loading (ETL) in Informatica power Center from various database sources.
• Strong work experience in Data Mart life cycle development, performed ETL procedure to load data from different sources like SQL Server, Oracle, Teradata, DB2, COBOL files & XML Files and flat files into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
• Involved in the understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Highly motivated and goal-oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies
• Strong knowledge of Entity-Relationship concept, Facts and Dimensions tables and developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Comprehensive experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, Flat Files into the staging area, ODS, Data Warehouse and Data Mart
• Extensive experience in developing Stored Procedures, Functions and Triggers, Complex SQL queries using SQL Server TSQL and Oracle PL/SQL.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Good working knowledge of variousInformaticadesigner transformations like Source Qualifier, Dynamic and Static Lookups, connected and Unconnected lookups, Expression, Filter, Router, Joiner, Normalizer and Update Strategy transformation.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

SAP Native HANA Lead:

Location: Hyderabad, IN.Apply

Technical Skills:

• 10 + years Experience in Data Warehouse/Business Intelligence spaceleading team
• Experience working on a onsite offshore engagement models
• Expertise in Data warehouse development projects using Native HANA
• Expertise in native HANA data modeling
• Performance tuning of data models and reports
• Sharp troubleshooting skills to identify and fix issues quickly
• Experience working on a Enterprise data warehouse environment
• Data modeling experience in building Logical and Physical data modelLeadership, critical thinking and excellent verbal and written communication skills
• Strong problem-solving and analytical ability.

SAP Native HANA Developers

Location: Hyderabad, INApply

Technical Skills:

• 7+ years of Experience with Good Communication/presentation skills to present solutions to the Business Users
• Must be good in understanding the business specific requirements and capable of proposing efficient solutions.
• Good to have Functional Knowledge/ Hands-on experience on any of the SAP Module such Supply Chain Management, Finance, Marketing &Sales, Material Management etc
• Experience on best practices of modelling
• Expertise on Design and develop HANA models
• Expertise on integration of HANA with multiple provisioning tools like SLT, SDA, SDI etc
• Experience in data provisioning from multiple sources like BW, ECC and other systems Experience on building CDS artifacts like, tables, views, schemas
• Experience in HANA SQL to build procedures, scalars and table functions
• Expertise in Optimizing techniques
• Expertise in multiple modelling approaches for solution design
• Expertise in Multi tenant database Containers
• Experience in HANA Application development