Position: PL/SQL lead
Location: Chicago Metropolitan Area (onsite)
JD:
Skills: PLSQL, SQL with ETL background, preferably IICS; Exp working in Data Migration projects at lead level; Salesforce knowledge and Salesforce Data Load experience; Good to have - Snowflake, AWS
8+ years of total experience in ETL as a PLSQL Lead Data Developer with Very good understanding of healthcare domain- Patient/Prospect, Medical Claims, Member, Payers, Providers etc. and good to have SFDC knowledge.
Strong in querying SQL server databases, writing complex SQL queries.
Develop PL/SQL reusable code components to be used across the Data migration projects with minimal code changes.
Responsible for the analysis of requirements to create technical data requirements, logical data models, design report logic, and write code to produce the data set(s).
Perform quantitative analysis on data from various sources.
Strong background in PL/SQL, database management, and data manipulation techniques, along with a passion for uncovering meaningful patterns and trends.
Develop and maintain complex SQL queries to extract and manipulate data from various databases and data sources.
Analyze large datasets to identify trends, patterns, and correlations, and present findings to stakeholders in a clear and actionable manner.
Good to have Migration projects experience in health care domain.
Essential Function
Team Leading skills; Onshore-Offshore coordination.
Work independently with business and technical stakeholders to understand the organization's obstacles, and provide due diligence
Design solutions to meet functional and non-functional requirements
Can review architecture and solution design artifacts
Proactively provide guidance on engineering methodologies, standards, and leading practices
Guidance of engineering staff and reviews of as-built configurations during construction phase
Identify, communicate, and mitigate Risks, Assumptions, Issues and Decisions throughout full lifecycle
Estimate and outline the recommended solutions
Execute the hands-on implementation of proposed solutions and provide technical guidance to teams during the solutions' development and deployment phases
Lead PL/SQL Developer