• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 17th Jul 2021

· Development experience in Informatica PowerCenter.

· Development experience in Microsoft SQL Server 2005-2012, Oracle 10g/11g

· Build experience in SQL Stored Procedures, User Defined Functions, Views.

· Understanding of scheduling techniques (CA Workload automation or equivalent).

· Strong communication skills.

· Self-Driven.

· Agile working experience would be an advantage.

 

Roles & Responsibilities

· Analysis, Design and Development of ETL Mappings.

· Analysis, Design and Development of SQL Components.

· Support QA and UAT Testing.

· Provide Implementation and Post Implementation Support.

· Development, Operation and Administration of ETL and Database Applications.

 

The ETL/ Informatica Lead is accountable for analyzing and developing complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements. Understands the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations. Responsible for the identification and resolution of information flow, content issues, and the transformation of business requirements into logical data models. This position identifies opportunities to reduce data redundancy, trends in data uses and single sources of data.

 

Essential Functions:

 

This role is accountable for analyzing and developing complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements. Identifies and resolves information flow, content issues, and the transformation of business requirements into logical data models. Also identifies opportunities to reduce data redundancy, trends in data issues, and single sources of data.

 

Responsibilities may include:

 

1. Defining, improving, and advocating corporate data standards, procedures, metrics, and policies.

2. Establishes project level logical data models, which provide basis for detailed design of all applications including data warehouses/marts and databases.

3. Identifies data organized into logical groupings and domains, independent of any application or system.

4. Provides centralized direction for metadata repositories, data definitions, and data relationships.

5. Creates data models for assigned projects.

6. Analyzes business rules, use cases, and object models for applicability in the development of a data model.

7. Documents data models including a fully normalized version.

8. Defines and attributes all objects/entities.

9. Establishes data definitions and values at the object/entity level.

10. Identifies, evaluates, and recommends use of industry leading ETL tools and business intelligence tools.

11. Work closely with the Enterprise Architecture team as a data/application architect to represent the application development needs.

Software:

Informatica Power Center 10.2

Informatica Cloud

SQL Server Management Studio

PL/SQL Developer

CA Workload Automation (or equivalent enterprise scheduler software)

Programming Languages:

T-SQL

Oracle PL/SQL

Windows Scripting (e.g.PowerShell Script)

 

Please share with me Updated Resume and below details asap for submission purpose.