Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman",serif;} Hi, Hope you are doing well. This is Krishna from ICS Global Soft. Kindly find the below job description and let me know your availability. Requirement: Sr. Data Warehouse Developer Location: Harrisburg, PA (Remote) Duration: Long Term Contract Job Description: Position Description: The position serves as a senior data warehouse developer for data warehousing and business intelligence (DW/BI) solutions in the Commonwealth of PAs Infrastructure and Economic IT Delivery Centers (IED DC) Bureau of Data Management and Analytics. Duties include senior-level data warehouse and application database design and development work supporting DW/BI projects and data analytics projects, enterprise data warehouse initiatives, new BI applications, and data integration and data migrations. Technologies involved include Oracle Pl/SQL, Informatica, IICS, Azure, and Erwin. Responsibilities: Informatica architecture and technical support, Informatica ETL development and troubleshooting, Azure data engineering (which includes working with Azure Synapse, Azure SQL, and Azure Data Factory), dimensional modeling, SQL and PL/SQL development, Oracle performance tuning, and BI development support. Involvement in all phases of data warehouse implementation, including requirements gathering, design, and testing. Design and develop ETL using Oracle PL/SQL, Informatica PowerCenter 10.4 and above, IICS & Azure. Create and maintain tables, create views, write queries, build PL/SQL packages, write stored procedures, triggers, and functions, and design and develop complex ETL processes. Read and interpret physical data models, primarily dimensional models. Use Informatica PowerCenter 10.4 and above, IICS (Informatica Intelligence Cloud Services), Oracle 12c, PL/SQL, Azure Synapse, Azure SQL, Azure Data Factory, Erwin 2020 R2 SP2 to accomplish project deliverables and to provide data solutions for the business areas we support. Hands-on development (estimated 75%) and data architecture-related work (estimated 25%). Specific Duties: DW/BI projects and initiatives, including business analysis, independent technical design, and development. Informatica architecture and troubleshooting support. Provide Informatica expertise where needed. Oracle SQL and PL/SQL performance tuning and troubleshooting. Data architecture duties, including OLAP and OLTP data modeling. Intensive data analysis on source system databases. Analysis of source system databases, identification of required data, and data profiling. Diagnose, analyze, troubleshoot, and choose the appropriate solution to fix data-related issues. Support the BI development team in building data visualization, reporting, and dashboards, specifically on the data side of that development. Implement data-related processes, functionality, and structures including data ingestion pipelines, cleansing, and transformation activities, and data stores for analytical workload in Azure. Skill Matrix: Skills Required / Desired Experience Required Consultant Experience IT Experience. Required 10 years Data warehouse development with 1 year or more of team lead experience. Required 7 years Oracle development experience that includes writing complex SQL and PL/SQL, and doing performance tuning. Required 7 years Data integration and ETL development experience with Informatica Power Center. Required 5 years Data analysis and requirements gathering and testing. Required 3 years Data modeling experience with at least 6 months of doing dimensional modeling. Required 1 year Strong oral and written communication skills. Required MS SQL Server and/or DB2 experience. Desired 3 years Azure data development/engineering experience. Desired 2 years IICS (Informatica Intelligent Cloud Services) experience. Desired 6 months Experience using Erwin data modeling tool. Desired 6 months Best Regards Krishna Chalasani Recruitment Lead 1231 Greenway Drive|Ste 375| Irving, TX 75038 E-mail: krishna@icsglobalsoft.com Office:(9 7 2 ) (4 8 3) (5 8 7 1 )