Job Description :
*Design, implement, automate and maintain large scale enterprise data ETL processes.
*Heavy informatica background
*Extracts structured and unstructured data from source systems, transforming it to fit business performance management needs, and loading it into a data mart.
*Ensures ETL process is developed in modular fashion in shared folders and reusable objects to enforce consistency timely development.
*Reviews ETL production design for performance optimization.
*Collaborates with business functional leaders by analyzing and evaluating business requirements; diagnose the design, propose/design alternatives and recommendations.
*Plans and coordinates the implementation of new data requirements
*Oversees the data load production process and the implementation of new data load files in accordance with the department’s change management process
*Resolves issues through troubleshooting and quick diagnoses.
*Ensures data quality by designing and implementing adequate internal controls and monitoring processes.
*Includes controls to identify individual ETL flows that are performance issues.
*Ensures controls are maintained when designing new structures by utilizing object naming conventions to encourage consistent development and ease of migration from development to test to production.
*Works closely with Information Technology staff through the phases of coding and implementation of external data source files providing clarifications as necessary.
*Maintains effective ongoing communications with the business and IT community and operational management regarding system plans, projects, budgets, expenditures and policies.
*Participates in the research and resolution of enterprise data governance issues.

Qualifications:

*Bachelor''s degree in a technical field such as computer science, computer engineering or related field required
*7+ years experience required
*Experience in providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance monitoring/planning and incident/problem troubleshooting and resolution
*Strong knowledge of SQL.
*Expert knowledge of relational databases, flat files and non-relational database structures.
*Proven ability to write excellent technical documentation.
             

Similar Jobs you may be interested in ..