Be an early applicantLess than 25 applicants

Company

Original Job Post

myGwork - LGBTQ+ Business Community · 2 days ago

Informatica Business Intelligence/ETL Developer

Princeton, NJ

Full-time

Hybrid

Mid, Senior Level

$72K/yr - $120K/yr

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Internet

Insider Connection @myGwork - LGBTQ+ Business Community

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Work closely with functional heads, stakeholders, and developers to understand requirements and create data pipelines using ETL tools while maintaining data quality and accuracy.

Perform analysis of complex data sets to better understand trends, relationships between variables, and to formulate business intelligence insights.

Excellent problem solving and analytical skills to analyze business needs and effective communication and presentation skills (verbal & written) to be able to articulate the problems and recommended solution to make design decisions with conviction.

Work in an Agile team and able to articulate problem statements & solutions.

Identify and implement opportunities in the solution that will drive improvements in performance, scalability, reliability, and re-usability.

Continue to drive down technical debt and cost of operations/support by keeping pace with latest cutting-edge technologies and newer development methods & strategies.

Ensure “operational excellence” capabilities (usability, availability, resilience, security, etc.) at-all-times.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data Warehouse DesignETL ToolsInformaticaOracle Data IntegratorAWS RedshiftOracle 12cOracle Autonomous Data WarehousePL/SQLSQL QueriesData ValidationData Warehouse LifecycleMultidimensional ModelsData MartsStar SchemaOracle ERP FinanceSalesforce CRMCPQ systemsREST APISOAP messagingIICSOracle PaaSData analytical toolsAlteryxVisualization toolsTableauPower BIAgile project implementationMicrosoft AzureVSTS

Required

Overall, 5-8 years of work experience in designing, developing, and implementing Data Warehouse solutions.

3-5 years of work experience in ETL tools like Informatica Intelligent Cloud Services (Data & Application Integration), Oracle Data Integrator

3-5 years of collective work experience in multiple databases like AWS Redshift, Oracle 12c, and Oracle Autonomous Data Warehouse.

At least 5 years of hands-on experience in PL/SQL.

Write/Manage complex SQL queries and perform end-to-end data validation.

Must have complete understanding of Data warehouse life cycle right from data source to ETL transformations to multidimensional models like data marts, star schema and Reporting.

A bachelor’s or master’s degree in engineering or business or finance or accounting.

Preferred

Experience on Oracle ERP Finance application modules: Account Payables (AP) or Account Receivables (AR) or General Ledger (GL) or Fixed Assets (FA) or Cash Management (CM)

Knowledge in Salesforce CRM and CPQ systems will be an added advantage.

Experience with REST API, SOAP messaging and integrations with other enterprise applications / SaaS applications using IICS / Oracle PaaS

Good to have knowledge of data analytical tools like Alteryx.

Basic knowledge and usage of visualization tools like Tableau, Power BI etc.

Working experience in estimating effort required to develop code.

Knowledge on Agile project implementation methods or usage of Microsoft Azure (VSTS) tool will be an added advantage.