US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 28th Feb 2024
Responsibilities:
Leverage extensive domain expertise to identify and access data from a range of sources, including SQL/NoSQL databases, social media, surveys within the organization, and additional public domain market data sources.
Collaborate with Business SMEs, Product Owners, Data stewards, and Data Architect to identify crucial data elements, define business terms, capture Metadata, define data schemes, clean, and prepare data in an appropriate format to perform analysis.
Build and maintain internal visualization platforms for clients, providing historical data insights, issuer comparisons, and analytics for different bonds and markets.
Conduct Data Extraction, Transformation, and Loading (ETL) processes using Informatica Power Centre and Azure tools.
Perform data analysis and reporting using NoSQL databases such as MongoDB, applying advanced techniques for data cleaning and transformation.
Collaborate with development teams to design and implement efficient data models, particularly in MongoDB and Cosmos DB.
Implement and optimize secure data pipelines into cloud data warehouses, such as Azure Redshift.
Utilize statistical analysis skills for hypothesis testing, ANNOVA, and P-Test to validate business rules and identify data quality issues.
Additional Required Skills:
Experience in Data identification, querying, cleaning, and wrangling, checking quality, working with common relational and non-relational databases in Big data environments on both on-prem and cloud platforms such as Azure, AWS, and Google Cloud.
Experience in articulating and translating business questions and using statistical techniques to arrive at an answer using data.
Experience in writing and speaking about technical concepts for business, technical, and lay audiences and giving data-driven presentations.
Experience working with relational databases using SQL.
Mandatory Skills:
Azure
SQL
NoSQL (MongoDB, Cosmos DB)
Statistical Analysis (P-Test, ANNOVA, Hypothesis Testing)
Data Warehousing
ETL Tools (Informatica)
Reporting Tools (Power BI, Tableau)
Business Intelligence Tools (SSIS, SSRS)
Cloud Services (AWS Redshift, Azure)
Database Management (Oracle, SQL Server)
Python programming