The Role : Senior ETL Developer - Informatica
Job Grade (for internal candidates only) : 10
Location : Islamabad, Pakistan
The Team : We are the premier provider of data feed products to the global investment community. As we continue to expand our coverage - not only in the US, but Europe and Asia as well - and improve our products and solutions, it is increasingly important to complement our best-in-class services with an exceptional organization of people.
We pursue excellence in everything we do. We value results, encourage teamwork, and embrace change. Our team is responsible for the design, architecture, develop, and implement CRM and Oracle Financial Cloud applications for the organization wide needs
Primary Responsibilities :
Work with application developers, business analysts, DBAs, system administrators, data modeling teams for ETL build and design.
Translate business requirements into technical requirements.
Understanding of data quality methodologies and data governance to ensure standardization of data.
Contribute to the requirements elicitation process, create application architecture documents.
Design, develop and test ETL tasks utilizing dynamic mappings, mapplets, and taskflows in Informatica Cloud
Performance tuning of end-to-end ETL integration processes.
Determine optimal approach for obtaining data from diverse source systems.
Key contributor to initiatives that require technical expertise.
Interface with business stakeholders to understand requirements and offer solutions.
Coordinate ETL release process; ensuring compliance requirements and code management standards are met
Respond to system generated alerts / escalations relating to any failures on application platform.
Work on projects focused on continuous improvement of the application support model and associated processes using appropriate technologies.
Must Haves :
Bachelor’s degree in Computer Science or technology related field
4 + years’ experience with ETL tools, preferably Informatica Cloud
3+ years working with relation databases Oracle & SQL Server including complex SQL constructs and DDL generation
Strong knowledge of relational databases and extensive experience with SQL scripting / stored procedures in PostgreSQL.
Strong exposure working with web service sources / Targets, XML Sources and Restful API’s.
Experience with Linux / shell scripting complementary with Informatica.
Experience in performance tuning.
Experience with data modeling and data mapping design.
Strong scripting skills with some experience in software engineering.
Experience working with globally distributed teams utilizing agile practices.
Strong communication skills at all levels of stakeholders (technical and non-technical)
Good to Have :
To have experience working with salesforce
Professional experience providing application support
Experience or familiarity with Azure DevOps
Experience with Informatica Operational Insights
Experience or familiarity with Unix / Linux command line or executing bash scripts
Proven record of accomplishment in solution focused problem-solving skills
About S&P Global
At S&P Global Market Intelligence, we know that not all information is important some of it is vital. Accurate, deep and insightful.
We integrate financial and industry data, research, and news into tools that help track performance, generate alpha, identify investment ideas, understand industry dynamics, perform valuation and assess credit risk.
Investment professionals, government agencies, corporations and universities globally can gain the intelligence essential to making business and financial decisions with conviction.
Market Intelligence is a division of S&P Global (NYSE : SPGI), which provides essential intelligence for individuals, companies, and governments to make decisions with confidence.
For more information, visit : S&P Global Market Intelligence S&P Global is an equal opportunity employer committed to making all employment decisions without regard to race / ethnicity, gender, pregnancy, gender identity or expression, color, creed, religion, national origin, age, disability, marital status (including domestic partnerships and civil unions), sexual orientation, military veteran status, unemployment status, or other legally protected categories, subject to applicable law.
20 - Professional (EEO-2 Job Categories-United States of America), IFTECH202.1 - Middle Professional Tier I (EEO Job Group), SWP Priority Ratings - (Strategic Workforce Planning)
Job ID : 263390
Posted On : 2021-09-02
Location : Islamabad, Pakistan