Etl Informatica Developers Job in Optimized Solutions Limited
Etl Informatica Developers
Optimized Solutions Limited
4+ weeks ago
- Hyderabad, Telangana
- Not Disclosed
- Full-time
- Permanent
Job Summary
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
Experience Required :
Minimum 6 Years
Vacancy :
2 - 4 Hires
Similar Jobs for you
×
Help us improve TheIndiaJobs
Need Help? Contact us